20240926@180649.8143 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406235 and bi.ref ='324.1676.00.1' and bi.lordem =1
20240926@180649.8599 fka6amevp0174i0b6hkan5uk5e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.698.00.01'
20240926@180649.8749 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406235 and bi.ref ='324.698.00.01' and bi.lordem =2
20240926@180649.9059 fka6amevp0174i0b6hkan5uk5e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1675.3015'
20240926@180649.9081 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406235 and bi.ref ='325.1675.3015' and bi.lordem =3
20240926@180649.9393 fka6amevp0174i0b6hkan5uk5e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240926@180649.9543 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406235 and bi.ref ='324.948.00.01' and bi.lordem =4
20240926@180649.9847 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180649.9850 fka6amevp0174i0b6hkan5uk5e Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240926@180649.9883 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180649.9887 fka6amevp0174i0b6hkan5uk5e Query : select top 1 1 valor from td where td.ndoc = 39
20240926@180649.9923 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180649.9926 fka6amevp0174i0b6hkan5uk5e 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')
20240926@180649.9957 fka6amevp0174i0b6hkan5uk5e 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
20240926@180649.9995 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180649.9998 fka6amevp0174i0b6hkan5uk5e Query : select top 1 ~inactivo valor from cl where no = '102370' and estab = 0 order by inactivo desc
20240926@180650.1270 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180650.1300 fka6amevp0174i0b6hkan5uk5e Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240926@180650.1650 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180650.1690 fka6amevp0174i0b6hkan5uk5e Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240926@180650.2170 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180650.2200 fka6amevp0174i0b6hkan5uk5e Query : select szadrsstamp valor from szadrs where szadrsdesc='genial & fabuloso electrodomÉsticos,unipessoal, lda.'
20240926@180650.2670 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180650.2700 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from td where ndoc = 39
20240926@180650.2830 fka6amevp0174i0b6hkan5uk5e Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240926@180650.2990 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.3150 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240926@180650.3330 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.3490 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240926@180650.3800 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.3940 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@180650.4060 fka6amevp0174i0b6hkan5uk5e Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@180650.4710 fka6amevp0174i0b6hkan5uk5e Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@180650.4830 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.4990 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@180650.5140 fka6amevp0174i0b6hkan5uk5e Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f595128266f594aa09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240926@180650.6940 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.7100 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240926@180650.7560 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240926@180650.7690 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240926@180650.7820 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240926@180650.7940 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240926@180650.8050 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240926@180650.8180 fka6amevp0174i0b6hkan5uk5e Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240926@180650.8290 fka6amevp0174i0b6hkan5uk5e Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f595128266f594aa09',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240926@180650.1065 fka6amevp0174i0b6hkan5uk5e Query : select top 1 fno valor from wsftdata order by fno desc
20240926@180650.1099 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.1125 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240926@180650.1147 fka6amevp0174i0b6hkan5uk5e Query : select 'normal' from dummy
20240926@180650.1164 fka6amevp0174i0b6hkan5uk5e Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f595128266f594aa09',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',953,102370,0,'2024-09-26',39,'euro',0,0,2024 ,?,?)
20240926@180650.1456 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180650.1459 fka6amevp0174i0b6hkan5uk5e Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20240926@180650.1480 fka6amevp0174i0b6hkan5uk5e Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1676.00.1'
20240926@180650.1493 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.1510 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.1535 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.1551 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.1559 fka6amevp0174i0b6hkan5uk5e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180650.1571 fka6amevp0174i0b6hkan5uk5e Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20240926@180650.1583 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.1597 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.1608 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f592064666f594aa26','aut66f595128266f594aa09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180650.1615 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.1629 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.1658 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f592064666f594aa26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66f595128266f594aa09' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240926@180650.1898 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180650.1900 fka6amevp0174i0b6hkan5uk5e Query : select st.usalote valor from st where st.ref = '324.698.00.01'
20240926@180650.1920 fka6amevp0174i0b6hkan5uk5e 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.698.00.01'
20240926@180650.2063 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.2078 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.2103 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.2117 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.2125 fka6amevp0174i0b6hkan5uk5e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180650.2137 fka6amevp0174i0b6hkan5uk5e Query : select sestamp valor from se where ref ='324.698.00.01' and lote = 'r2400061200a'
20240926@180650.2152 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.2166 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.2180 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f592897166f594aa34','aut66f595128266f594aa09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180650.2183 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.2197 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.2225 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f592897166f594aa34',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66f595128266f594aa09' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240926@180650.2477 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.2494 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.2521 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.2539 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.2548 fka6amevp0174i0b6hkan5uk5e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180650.2560 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.2575 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.2587 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f590231166f594aa3e','aut66f595128266f594aa09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180650.2591 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.2606 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.3247 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f590231166f594aa3e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f595128266f594aa09' ,0,0 ,2,23.00,30000,?,?,?)
20240926@180650.3536 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180650.3539 fka6amevp0174i0b6hkan5uk5e Query : select st.usalote valor from st where st.ref = '325.1675.3015'
20240926@180650.3558 fka6amevp0174i0b6hkan5uk5e 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 = '325.1675.3015'
20240926@180650.3571 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.3586 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.3610 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.3623 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.3632 fka6amevp0174i0b6hkan5uk5e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180650.3643 fka6amevp0174i0b6hkan5uk5e Query : select sestamp valor from se where ref ='325.1675.3015' and lote = '1303'
20240926@180650.3655 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.3669 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.3680 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f591023166f594aa59','aut66f595128266f594aa09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180650.3684 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.3701 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.3728 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f591023166f594aa59',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66f595128266f594aa09' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240926@180650.4007 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180650.4010 fka6amevp0174i0b6hkan5uk5e Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240926@180650.4031 fka6amevp0174i0b6hkan5uk5e 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.948.00.01'
20240926@180650.4179 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.4195 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.4221 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.4235 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.4243 fka6amevp0174i0b6hkan5uk5e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180650.4255 fka6amevp0174i0b6hkan5uk5e Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240926@180650.4268 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.4283 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.4299 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f595825266f594aa68','aut66f595128266f594aa09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180650.4303 fka6amevp0174i0b6hkan5uk5e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.4318 fka6amevp0174i0b6hkan5uk5e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.4345 fka6amevp0174i0b6hkan5uk5e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f595825266f594aa68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f595128266f594aa09' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240926@180650.4599 fka6amevp0174i0b6hkan5uk5e Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f595128266f594aa09','2406235','wait',39,'adm09112754980.682000002')
20240926@180650.4716 fka6amevp0174i0b6hkan5uk5e Query : use flama_phc
20240926@180650.4719 fka6amevp0174i0b6hkan5uk5e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240926@180650.4759 fka6amevp0174i0b6hkan5uk5e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2241';
20240926@180650.4789 fka6amevp0174i0b6hkan5uk5e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2241';
20240926@180650.4837 fka6amevp0174i0b6hkan5uk5e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2241';
20240926@180650.4865 fka6amevp0174i0b6hkan5uk5e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2241';
20240926@180650.5398 3836ovoa31i3q5s331il3cdpci Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240926@180650.5409 3836ovoa31i3q5s331il3cdpci Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240926@180650.5473 3836ovoa31i3q5s331il3cdpci Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2242';
20240926@180650.5531 3836ovoa31i3q5s331il3cdpci Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2242';
20240926@180650.5591 3836ovoa31i3q5s331il3cdpci Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2242';
20240926@180650.5625 3836ovoa31i3q5s331il3cdpci Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2242';
20240926@180650.5693 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.5696 3836ovoa31i3q5s331il3cdpci Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240926@180650.5764 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.5766 3836ovoa31i3q5s331il3cdpci Query : select no, estab,szadrsdesc from szadrs where u_coddest=8548
20240926@180650.5847 3836ovoa31i3q5s331il3cdpci Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240926@180650.5870 3836ovoa31i3q5s331il3cdpci Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406239 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240926@180650.6208 3836ovoa31i3q5s331il3cdpci Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240926@180650.6228 3836ovoa31i3q5s331il3cdpci Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406239 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240926@180650.6540 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.6544 3836ovoa31i3q5s331il3cdpci Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240926@180650.6580 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.6584 3836ovoa31i3q5s331il3cdpci Query : select top 1 1 valor from td where td.ndoc = 39
20240926@180650.6615 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.6618 3836ovoa31i3q5s331il3cdpci 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')
20240926@180650.6648 3836ovoa31i3q5s331il3cdpci 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
20240926@180650.6685 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.6689 3836ovoa31i3q5s331il3cdpci Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240926@180650.6719 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.6723 3836ovoa31i3q5s331il3cdpci Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240926@180650.6757 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.6760 3836ovoa31i3q5s331il3cdpci Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240926@180650.6804 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.6807 3836ovoa31i3q5s331il3cdpci Query : select szadrsstamp valor from szadrs where szadrsdesc='jom- maia ( nova loja)'
20240926@180650.6861 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.6864 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from td where ndoc = 39
20240926@180650.6877 3836ovoa31i3q5s331il3cdpci Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240926@180650.6891 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.6908 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240926@180650.6927 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.6942 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240926@180650.6971 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.6985 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@180650.6998 3836ovoa31i3q5s331il3cdpci Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@180650.7064 3836ovoa31i3q5s331il3cdpci Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@180650.7078 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.7092 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@180650.7109 3836ovoa31i3q5s331il3cdpci Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f594278866f594aaaa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240926@180650.7570 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.7592 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240926@180650.7627 3836ovoa31i3q5s331il3cdpci Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240926@180650.7640 3836ovoa31i3q5s331il3cdpci Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240926@180650.7652 3836ovoa31i3q5s331il3cdpci Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240926@180650.7682 3836ovoa31i3q5s331il3cdpci Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240926@180650.7693 3836ovoa31i3q5s331il3cdpci Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240926@180650.7705 3836ovoa31i3q5s331il3cdpci Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240926@180650.7716 3836ovoa31i3q5s331il3cdpci Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f594278866f594aaaa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240926@180650.7966 3836ovoa31i3q5s331il3cdpci Query : select top 1 fno valor from wsftdata order by fno desc
20240926@180650.7987 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.8002 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240926@180650.8026 3836ovoa31i3q5s331il3cdpci Query : select 'normal' from dummy
20240926@180650.8042 3836ovoa31i3q5s331il3cdpci Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f594278866f594aaaa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',954,101621,0,'2024-09-26',39,'euro',0,0,2024 ,?,?)
20240926@180650.8322 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180650.8325 3836ovoa31i3q5s331il3cdpci Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240926@180650.8347 3836ovoa31i3q5s331il3cdpci 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.1831.00.2'
20240926@180650.8360 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.8376 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.8402 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.8416 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.8425 3836ovoa31i3q5s331il3cdpci Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180650.8437 3836ovoa31i3q5s331il3cdpci Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400401175a'
20240926@180650.8450 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.8464 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.8475 3836ovoa31i3q5s331il3cdpci Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f597956966f594aace','aut66f594278866f594aaaa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180650.8479 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.8496 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.8524 3836ovoa31i3q5s331il3cdpci Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f597956966f594aace',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66f594278866f594aaaa' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240926@180650.8914 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.8931 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180650.8956 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.8972 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180650.8980 3836ovoa31i3q5s331il3cdpci Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180650.8994 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180650.9011 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180651.1460 3836ovoa31i3q5s331il3cdpci Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f595931266f594aadb','aut66f594278866f594aaaa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180651.1510 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.1680 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180651.1980 3836ovoa31i3q5s331il3cdpci Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f595931266f594aadb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f594278866f594aaaa' ,0,0 ,2,23.00,20000,?,?,?)
20240926@180651.4660 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180651.4690 3836ovoa31i3q5s331il3cdpci Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240926@180651.4890 3836ovoa31i3q5s331il3cdpci 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.1831.00.2'
20240926@180651.5030 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.5190 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180651.5440 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.5600 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180651.5690 3836ovoa31i3q5s331il3cdpci Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180651.5810 3836ovoa31i3q5s331il3cdpci Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400401175a'
20240926@180651.5940 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.6120 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180651.6230 3836ovoa31i3q5s331il3cdpci Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f592951566f594ab0e','aut66f594278866f594aaaa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180651.6270 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.6410 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180651.6700 3836ovoa31i3q5s331il3cdpci Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f592951566f594ab0e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66f594278866f594aaaa' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240926@180651.9300 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.9450 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180651.9710 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.9860 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180651.9940 3836ovoa31i3q5s331il3cdpci Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180651.1007 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.1021 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180651.1033 3836ovoa31i3q5s331il3cdpci Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f598422666f594ab18','aut66f594278866f594aaaa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180651.1037 3836ovoa31i3q5s331il3cdpci Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.1051 3836ovoa31i3q5s331il3cdpci Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180651.1079 3836ovoa31i3q5s331il3cdpci Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f598422666f594ab18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f594278866f594aaaa' ,0,0 ,2,23.00,50000,?,?,?)
20240926@180651.1325 3836ovoa31i3q5s331il3cdpci Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f594278866f594aaaa','2406239','wait',39,'adm09112754980.682000002')
20240926@180651.1398 3836ovoa31i3q5s331il3cdpci Query : use flama_phc
20240926@180651.1401 3836ovoa31i3q5s331il3cdpci Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240926@180651.1432 3836ovoa31i3q5s331il3cdpci Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2242';
20240926@180651.1462 3836ovoa31i3q5s331il3cdpci Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2242';
20240926@180651.1503 3836ovoa31i3q5s331il3cdpci Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2242';
20240926@180651.1530 3836ovoa31i3q5s331il3cdpci Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2242';
20240926@180651.2049 hkfjo14210u0vm9egndudgi5d5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240926@180651.2062 hkfjo14210u0vm9egndudgi5d5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240926@180651.2116 hkfjo14210u0vm9egndudgi5d5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2243';
20240926@180651.2171 hkfjo14210u0vm9egndudgi5d5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2243';
20240926@180651.2223 hkfjo14210u0vm9egndudgi5d5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2243';
20240926@180651.2248 hkfjo14210u0vm9egndudgi5d5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2243';
20240926@180651.2910 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.2917 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240926@180651.2987 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.2990 hkfjo14210u0vm9egndudgi5d5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2316
20240926@180651.3088 hkfjo14210u0vm9egndudgi5d5 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'
20240926@180651.3241 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406241 and bi.ref ='324.5540.00.1' and bi.lordem =1
20240926@180651.3554 hkfjo14210u0vm9egndudgi5d5 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'
20240926@180651.3699 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406241 and bi.ref ='324.1643.00.1' and bi.lordem =2
20240926@180651.4011 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.4015 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240926@180651.4047 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.4050 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 1 valor from td where td.ndoc = 39
20240926@180651.4081 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.4084 hkfjo14210u0vm9egndudgi5d5 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')
20240926@180651.4113 hkfjo14210u0vm9egndudgi5d5 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
20240926@180651.4152 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.4156 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 ~inactivo valor from cl where no = '102238' and estab = 0 order by inactivo desc
20240926@180651.4279 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.4282 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240926@180651.4311 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.4314 hkfjo14210u0vm9egndudgi5d5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240926@180651.4355 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.4358 hkfjo14210u0vm9egndudgi5d5 Query : select szadrsstamp valor from szadrs where szadrsdesc='sergio manuel quaresma miranda'
20240926@180651.4406 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.4409 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from td where ndoc = 39
20240926@180651.4421 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240926@180651.4435 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.4450 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240926@180651.4469 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.4483 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240926@180651.4511 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.4526 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@180651.4538 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@180651.4605 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@180651.4618 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.4633 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@180651.4649 hkfjo14210u0vm9egndudgi5d5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f594779566f594ab6e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240926@180651.4828 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.4844 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240926@180651.4876 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240926@180651.4888 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240926@180651.4900 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240926@180651.4911 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240926@180651.4924 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240926@180651.4936 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240926@180651.4948 hkfjo14210u0vm9egndudgi5d5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f594779566f594ab6e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240926@180651.5201 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 fno valor from wsftdata order by fno desc
20240926@180651.5223 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.5240 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240926@180651.5264 hkfjo14210u0vm9egndudgi5d5 Query : select 'normal' from dummy
20240926@180651.5279 hkfjo14210u0vm9egndudgi5d5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f594779566f594ab6e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',955,102238,0,'2024-09-26',39,'euro',0,0,2024 ,?,?)
20240926@180651.5578 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.5582 hkfjo14210u0vm9egndudgi5d5 Query : select st.usalote valor from st where st.ref = '324.5540.00.1'
20240926@180651.5603 hkfjo14210u0vm9egndudgi5d5 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'
20240926@180651.5745 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.5760 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180651.5787 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.5802 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180651.5811 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180651.5823 hkfjo14210u0vm9egndudgi5d5 Query : select sestamp valor from se where ref ='324.5540.00.1' and lote = 'r2300830100a'
20240926@180651.5837 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.5851 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180651.5862 hkfjo14210u0vm9egndudgi5d5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f594831766f594ab8e','aut66f594779566f594ab6e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180651.5866 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.5880 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180651.5908 hkfjo14210u0vm9egndudgi5d5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f594831766f594ab8e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66f594779566f594ab6e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240926@180651.6160 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.6163 hkfjo14210u0vm9egndudgi5d5 Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20240926@180651.6183 hkfjo14210u0vm9egndudgi5d5 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'
20240926@180651.6325 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.6341 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180651.6366 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.6381 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180651.6389 hkfjo14210u0vm9egndudgi5d5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180651.6400 hkfjo14210u0vm9egndudgi5d5 Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20240926@180651.6414 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.6428 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180651.6439 hkfjo14210u0vm9egndudgi5d5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f593435466f594ab9c','aut66f594779566f594ab6e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180651.6443 hkfjo14210u0vm9egndudgi5d5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180651.6458 hkfjo14210u0vm9egndudgi5d5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180651.6486 hkfjo14210u0vm9egndudgi5d5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f593435466f594ab9c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66f594779566f594ab6e' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240926@180651.6739 hkfjo14210u0vm9egndudgi5d5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f594779566f594ab6e','2406241','wait',39,'adm09112754980.682000002')
20240926@180651.6813 hkfjo14210u0vm9egndudgi5d5 Query : use flama_phc
20240926@180651.6816 hkfjo14210u0vm9egndudgi5d5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240926@180651.6847 hkfjo14210u0vm9egndudgi5d5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2243';
20240926@180651.6876 hkfjo14210u0vm9egndudgi5d5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2243';
20240926@180651.6917 hkfjo14210u0vm9egndudgi5d5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2243';
20240926@180651.6942 hkfjo14210u0vm9egndudgi5d5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2243';
20240926@180651.7468 h8ikeeaqtu77lg0u11e0n5heen Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240926@180651.7481 h8ikeeaqtu77lg0u11e0n5heen Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240926@180651.7539 h8ikeeaqtu77lg0u11e0n5heen Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2244';
20240926@180651.7600 h8ikeeaqtu77lg0u11e0n5heen Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2244';
20240926@180651.7652 h8ikeeaqtu77lg0u11e0n5heen Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2244';
20240926@180651.7679 h8ikeeaqtu77lg0u11e0n5heen Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2244';
20240926@180651.7728 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180651.7731 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240926@180651.7796 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180651.7799 h8ikeeaqtu77lg0u11e0n5heen Query : select no, estab,szadrsdesc from szadrs where u_coddest=248
20240926@180651.7881 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20240926@180651.8048 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.1816.00.1' and bi.lordem =1
20240926@180651.8357 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20240926@180651.8377 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.1816.00.1' and bi.lordem =1
20240926@180651.8395 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20240926@180651.8418 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.1816.00.1' and bi.lordem =2
20240926@180651.8733 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240926@180651.8755 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.1833.00.2' and bi.lordem =3
20240926@180651.9202 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240926@180651.9223 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.1833.00.2' and bi.lordem =3
20240926@180651.9239 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240926@180651.9258 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.1833.00.2' and bi.lordem =4
20240926@180651.9569 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240926@180651.9590 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='304.421.00.04' and bi.lordem =5
20240926@180651.9880 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240926@180652.2800 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.4970.00.1' and bi.lordem =7
20240926@180652.3880 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4521.00.1'
20240926@180652.4100 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.4521.00.1' and bi.lordem =9
20240926@180652.7300 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.946.00.01'
20240926@180652.8840 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.946.00.01' and bi.lordem =10
20240926@180652.1203 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20240926@180652.1348 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.945.00.01' and bi.lordem =12
20240926@180652.1662 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.734.00.02'
20240926@180652.1685 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.734.00.02' and bi.lordem =14
20240926@180652.1983 h8ikeeaqtu77lg0u11e0n5heen 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'
20240926@180652.2133 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.5396.00.1' and bi.lordem =15
20240926@180652.2445 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240926@180652.2601 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2062 and bo.obrano = 2406242 and bi.ref ='324.5343.00.1' and bi.lordem =17
20240926@180652.2929 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.2933 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240926@180652.3580 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.3584 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 1 valor from td where td.ndoc = 39
20240926@180652.3617 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.3620 h8ikeeaqtu77lg0u11e0n5heen 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')
20240926@180652.3648 h8ikeeaqtu77lg0u11e0n5heen 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
20240926@180652.3686 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.3690 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 ~inactivo valor from cl where no = '101837' and estab = 0 order by inactivo desc
20240926@180652.3815 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.3818 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240926@180652.3848 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.3850 h8ikeeaqtu77lg0u11e0n5heen Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240926@180652.3913 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.3916 h8ikeeaqtu77lg0u11e0n5heen Query : select szadrsstamp valor from szadrs where szadrsdesc='jose domingues araÚjo unipessoal, lda'
20240926@180652.3961 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.3964 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from td where ndoc = 39
20240926@180652.3976 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240926@180652.4005 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.4021 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240926@180652.4040 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.4054 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240926@180652.4084 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.4100 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@180652.4118 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@180652.4184 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@180652.4197 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.4212 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@180652.4228 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240926@180652.4407 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.4424 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240926@180652.4457 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240926@180652.4469 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240926@180652.4481 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240926@180652.4493 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240926@180652.4506 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240926@180652.4517 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240926@180652.4529 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f591648066f594ac64',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240926@180652.4768 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 fno valor from wsftdata order by fno desc
20240926@180652.4789 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.4804 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240926@180652.4827 h8ikeeaqtu77lg0u11e0n5heen Query : select 'normal' from dummy
20240926@180652.4842 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f591648066f594ac64',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',956,101837,0,'2024-09-26',39,'euro',0,0,2024 ,?,?)
20240926@180652.5135 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.5139 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240926@180652.5162 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20240926@180652.5312 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.5327 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.5355 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.5373 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.5382 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.5394 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400199200a'
20240926@180652.5409 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.5425 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.5437 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f591763066f594ac84','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.5442 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.5457 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.5484 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f591763066f594ac84',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240926@180652.5743 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.5758 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.5785 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.5801 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.5810 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.5822 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.5836 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.5848 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f598566066f594ac8e','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.5852 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.5867 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.5894 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f598566066f594ac8e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,20000,?,?,?)
20240926@180652.6150 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.6153 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240926@180652.6172 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20240926@180652.6187 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.6203 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.6227 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.6241 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.6250 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.6262 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400199200a'
20240926@180652.6274 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.6288 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.6301 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f598330866f594ac99','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.6305 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.6319 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.6346 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f598330866f594ac99',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240926@180652.6594 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.6614 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.6641 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.6655 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.6664 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.6677 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.6691 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.6705 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f595840166f594aca3','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.6710 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.6724 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.6754 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f595840166f594aca3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,50000,?,?,?)
20240926@180652.7002 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.7005 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240926@180652.7024 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20240926@180652.7038 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7053 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.7078 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7093 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.7102 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.7114 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400199200a'
20240926@180652.7126 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7140 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.7151 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f591768266f594acad','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.7155 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7169 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.7196 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f591768266f594acad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240926@180652.7447 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7463 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.7491 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7505 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.7514 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.7527 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7541 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.7552 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f599212966f594acb7','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.7557 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7571 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.7598 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f599212966f594acb7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,80000,?,?,?)
20240926@180652.7862 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.7866 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240926@180652.7887 h8ikeeaqtu77lg0u11e0n5heen 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.1833.00.2'
20240926@180652.7901 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7916 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.7942 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.7956 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.7965 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.7977 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240926@180652.7989 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8004 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.8016 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f597702966f594acc3','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.8020 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8034 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.8063 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f597702966f594acc3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240926@180652.8316 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.8318 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240926@180652.8337 h8ikeeaqtu77lg0u11e0n5heen 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.1833.00.2'
20240926@180652.8351 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8367 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.8391 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8406 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.8415 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.8428 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240926@180652.8440 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8454 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.8465 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f594387866f594acce','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.8470 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8484 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.8511 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f594387866f594acce',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20240926@180652.8754 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.8757 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240926@180652.8778 h8ikeeaqtu77lg0u11e0n5heen 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.1833.00.2'
20240926@180652.8792 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8808 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.8833 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8848 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.8856 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.8868 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240926@180652.8880 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8895 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.8906 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f590034066f594acd8','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.8911 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.8925 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.8953 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f590034066f594acd8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20240926@180652.9300 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180652.9342 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240926@180652.9369 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240926@180652.9382 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.9400 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.9424 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.9438 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.9447 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.9459 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '241001'
20240926@180652.9472 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.9486 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.9498 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f593732866f594ace7','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.9502 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.9517 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.9546 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f593732866f594ace7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240926@180652.9807 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.9822 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.9848 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.9863 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.9871 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180652.9884 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.9898 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180652.9909 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f593588166f594acf1','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180652.9913 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180652.9927 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180652.9956 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f593588166f594acf1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,140000,?,?,?)
20240926@180653.2130 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180653.2160 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240926@180653.2370 h8ikeeaqtu77lg0u11e0n5heen 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.4970.00.1'
20240926@180653.4000 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.4180 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180653.4450 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.4590 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180653.4680 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180653.4800 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240926@180653.4930 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.5090 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180653.5220 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f592115866f594ad0c','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180653.5260 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.5420 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180653.5700 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f592115866f594ad0c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20240926@180653.8530 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180653.8560 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20240926@180653.8750 h8ikeeaqtu77lg0u11e0n5heen 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'
20240926@180653.8890 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.9040 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180653.9320 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.9460 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180653.9550 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180653.9670 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400052200a'
20240926@180653.9810 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.9960 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180653.1007 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f591095166f594ad17','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180653.1011 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.1029 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180653.1058 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f591095166f594ad17',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,170000,?,?,?,?,?)
20240926@180653.1305 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180653.1308 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.946.00.01'
20240926@180653.1328 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.946.00.01'
20240926@180653.1471 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.1487 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180653.1514 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.1529 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180653.1539 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180653.1551 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.946.00.01' and lote = 'r2300941200a'
20240926@180653.1565 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.1580 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180653.1591 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f594465866f594ad26','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180653.1595 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.1612 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180653.1641 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f594465866f594ad26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,180000,?,?,?,?,?)
20240926@180653.1896 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180653.1899 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20240926@180653.1919 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.945.00.01'
20240926@180653.2063 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.2079 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180653.2105 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.2120 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180653.2128 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180653.2140 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2200799100a'
20240926@180653.2154 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.2168 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180653.2180 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f598733366f594ad34','aut66f591648066f594ac64' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240926@180653.2184 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.2198 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180653.2227 h8ikeeaqtu77lg0u11e0n5heen Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f598733366f594ad34',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66f591648066f594ac64' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20240926@180653.2471 h8ikeeaqtu77lg0u11e0n5heen Query : use flama_phc
20240926@180653.2474 h8ikeeaqtu77lg0u11e0n5heen Query : select st.usalote valor from st where st.ref = '324.734.00.02'
20240926@180653.2493 h8ikeeaqtu77lg0u11e0n5heen 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.734.00.02'
20240926@180653.2508 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.2524 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240926@180653.2551 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.2567 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240926@180653.2576 h8ikeeaqtu77lg0u11e0n5heen Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240926@180653.2588 h8ikeeaqtu77lg0u11e0n5heen Query : select sestamp valor from se where ref ='324.734.00.02' and lote = 'r2400471100a'
20240926@180653.2603 h8ikeeaqtu77lg0u11e0n5heen Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@180653.2618 h8ikeeaqtu77lg0u11e0n5heen Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
