20240409@181935.9942 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402657 and bi.ref ='324.1833.00.2' and bi.lordem =1
20240409@181936.2750 rmj4hv3f6lc1acdmg42qh9gvld 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'
20240409@181936.2880 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402657 and bi.ref ='324.1833.00.2' and bi.lordem =2
20240409@181936.6720 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.6760 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240409@181936.6900 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.6940 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 1 valor from td where td.ndoc = 39
20240409@181936.7040 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.7070 rmj4hv3f6lc1acdmg42qh9gvld Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240409@181936.7180 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240409@181936.7320 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.7350 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240409@181936.8420 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.8460 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240409@181936.8590 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.8620 rmj4hv3f6lc1acdmg42qh9gvld Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240409@181936.8730 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.8760 rmj4hv3f6lc1acdmg42qh9gvld Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - tudo para o seu lar'
20240409@181936.8900 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.8920 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from td where ndoc = 39
20240409@181936.9020 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240409@181936.9150 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240409@181936.9290 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240409@181936.9460 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240409@181936.9590 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240409@181936.9850 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240409@181936.9980 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240409@181936.1008 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240409@181936.1105 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240409@181936.1114 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240409@181936.1128 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240409@181936.1138 rmj4hv3f6lc1acdmg42qh9gvld Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6615702795661578a818' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240409@181936.1354 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240409@181936.1369 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240409@181936.1396 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240409@181936.1400 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240409@181936.1405 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240409@181936.1410 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240409@181936.1414 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240409@181936.1418 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240409@181936.1422 rmj4hv3f6lc1acdmg42qh9gvld Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6615702795661578a818',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240409@181936.1735 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 fno valor from wsft039data order by fno desc
20240409@181936.1754 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240409@181936.1795 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240409@181936.2016 rmj4hv3f6lc1acdmg42qh9gvld Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6615702795661578a818',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',820,101621,0,'2024-04-09',39,'euro',0,0,2024 ,'20240409','1849',?,?,?,?)
20240409@181936.2399 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.3123 rmj4hv3f6lc1acdmg42qh9gvld Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240409@181936.3523 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1833.00.2'
20240409@181936.3692 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181936.3707 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181936.3729 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181936.3742 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181936.3746 rmj4hv3f6lc1acdmg42qh9gvld Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301256100a'
20240409@181936.3757 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181936.3767 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181936.3779 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181936.3801 rmj4hv3f6lc1acdmg42qh9gvld Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6615724129661578a85b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6615702795661578a818' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240409@181936.4104 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181936.4121 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181936.4125 rmj4hv3f6lc1acdmg42qh9gvld Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615724129661578a85b','aut6615702795661578a818' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181936.4129 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.4132 rmj4hv3f6lc1acdmg42qh9gvld Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240409@181936.4144 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1833.00.2'
20240409@181936.4155 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181936.4168 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181936.4190 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181936.4203 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181936.4207 rmj4hv3f6lc1acdmg42qh9gvld Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301256100a'
20240409@181936.4217 rmj4hv3f6lc1acdmg42qh9gvld Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181936.4226 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181936.4238 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181936.4429 rmj4hv3f6lc1acdmg42qh9gvld Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6615775319661578a867',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6615702795661578a818' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240409@181936.4732 rmj4hv3f6lc1acdmg42qh9gvld Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181936.4749 rmj4hv3f6lc1acdmg42qh9gvld Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181936.4754 rmj4hv3f6lc1acdmg42qh9gvld Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615775319661578a867','aut6615702795661578a818' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181936.4758 rmj4hv3f6lc1acdmg42qh9gvld Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6615702795661578a818','2402657','wait',39,'ari17112337378,753000005')
20240409@181936.4773 rmj4hv3f6lc1acdmg42qh9gvld Query : use flama_phc
20240409@181936.4776 rmj4hv3f6lc1acdmg42qh9gvld Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@181936.4787 rmj4hv3f6lc1acdmg42qh9gvld Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1061';
20240409@181936.4804 rmj4hv3f6lc1acdmg42qh9gvld Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1061';
20240409@181936.4819 rmj4hv3f6lc1acdmg42qh9gvld Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1061';
20240409@181936.4832 rmj4hv3f6lc1acdmg42qh9gvld Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1061';
20240409@181936.5244 3df4gheknm2j6b827o3lm14b60 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240409@181936.5257 3df4gheknm2j6b827o3lm14b60 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240409@181936.5285 3df4gheknm2j6b827o3lm14b60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1062';
20240409@181936.5327 3df4gheknm2j6b827o3lm14b60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1062';
20240409@181936.5342 3df4gheknm2j6b827o3lm14b60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1062';
20240409@181936.5356 3df4gheknm2j6b827o3lm14b60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1062';
20240409@181936.5369 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.5372 3df4gheknm2j6b827o3lm14b60 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240409@181936.5384 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.5388 3df4gheknm2j6b827o3lm14b60 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2686
20240409@181936.5473 3df4gheknm2j6b827o3lm14b60 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.682.00.01'
20240409@181936.5623 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402659 and bi.ref ='324.682.00.01' and bi.lordem =1
20240409@181936.5976 3df4gheknm2j6b827o3lm14b60 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.682.00.01'
20240409@181936.5988 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402659 and bi.ref ='324.682.00.01' and bi.lordem =1
20240409@181936.5994 3df4gheknm2j6b827o3lm14b60 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'
20240409@181936.6005 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402659 and bi.ref ='324.4970.00.1' and bi.lordem =2
20240409@181936.6327 3df4gheknm2j6b827o3lm14b60 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.682.00.01'
20240409@181936.6339 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402659 and bi.ref ='324.682.00.01' and bi.lordem =3
20240409@181936.6646 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.6650 3df4gheknm2j6b827o3lm14b60 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240409@181936.6663 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.6667 3df4gheknm2j6b827o3lm14b60 Query : select top 1 1 valor from td where td.ndoc = 39
20240409@181936.6677 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.6680 3df4gheknm2j6b827o3lm14b60 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240409@181936.6692 3df4gheknm2j6b827o3lm14b60 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240409@181936.6708 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.6711 3df4gheknm2j6b827o3lm14b60 Query : select top 1 ~inactivo valor from cl where no = '102189' and estab = 0 order by inactivo desc
20240409@181936.6870 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.6873 3df4gheknm2j6b827o3lm14b60 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240409@181936.6884 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.6887 3df4gheknm2j6b827o3lm14b60 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240409@181936.6909 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.6912 3df4gheknm2j6b827o3lm14b60 Query : select szadrsstamp valor from szadrs where szadrsdesc='bom preÇo, lda.- entrega'
20240409@181936.6928 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.6930 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from td where ndoc = 39
20240409@181936.6941 3df4gheknm2j6b827o3lm14b60 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240409@181936.6952 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240409@181936.6966 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240409@181936.6981 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240409@181936.6994 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240409@181936.7021 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240409@181936.7034 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240409@181936.7046 3df4gheknm2j6b827o3lm14b60 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240409@181936.7156 3df4gheknm2j6b827o3lm14b60 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240409@181936.7166 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240409@181936.7180 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240409@181936.7189 3df4gheknm2j6b827o3lm14b60 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6615760214661578a8ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240409@181936.7381 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240409@181936.7397 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240409@181936.8577 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240409@181936.8584 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240409@181936.8590 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240409@181936.8595 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240409@181936.8601 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240409@181936.8606 3df4gheknm2j6b827o3lm14b60 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240409@181936.8611 3df4gheknm2j6b827o3lm14b60 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6615760214661578a8ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240409@181936.8916 3df4gheknm2j6b827o3lm14b60 Query : select top 1 fno valor from wsft039data order by fno desc
20240409@181936.8934 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240409@181936.8949 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240409@181936.8966 3df4gheknm2j6b827o3lm14b60 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6615760214661578a8ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',821,102189,0,'2024-04-09',39,'euro',0,0,2024 ,'20240409','1849',?,?,?,?)
20240409@181936.9292 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181936.9296 3df4gheknm2j6b827o3lm14b60 Query : select st.usalote valor from st where st.ref = '324.682.00.01'
20240409@181936.9309 3df4gheknm2j6b827o3lm14b60 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.682.00.01'
20240409@181936.9460 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181936.9478 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181936.9501 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181936.9514 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181936.9518 3df4gheknm2j6b827o3lm14b60 Query : select sestamp valor from se where ref ='324.682.00.01' and lote = 'r2301262200a'
20240409@181936.9528 3df4gheknm2j6b827o3lm14b60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181936.9538 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181936.9550 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181936.9574 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6615736293661578a8e8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6615760214661578a8ac' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240409@181936.9877 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181936.9892 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181936.9896 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615736293661578a8e8','aut6615760214661578a8ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181936.9901 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181936.9917 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181936.9940 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181936.9977 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181936.9981 3df4gheknm2j6b827o3lm14b60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181936.9993 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.1200 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181937.3700 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6615775652661578a8f3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6615760214661578a8ac' ,0,0 ,2,23.00,20000,?,?,?)
20240409@181937.3230 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.3520 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181937.3560 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615775652661578a8f3','aut6615760214661578a8ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181937.3610 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181937.3640 3df4gheknm2j6b827o3lm14b60 Query : select st.usalote valor from st where st.ref = '324.682.00.01'
20240409@181937.3740 3df4gheknm2j6b827o3lm14b60 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.682.00.01'
20240409@181937.3850 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.3980 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181937.4210 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.4320 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181937.4370 3df4gheknm2j6b827o3lm14b60 Query : select sestamp valor from se where ref ='324.682.00.01' and lote = 'r2301262200a'
20240409@181937.4510 3df4gheknm2j6b827o3lm14b60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181937.4620 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.4740 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181937.4980 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6615738232661578a90b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6615760214661578a8ac' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240409@181937.8350 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.8520 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181937.8560 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615738232661578a90b','aut6615760214661578a8ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181937.8610 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.8950 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181937.9190 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.9320 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181937.9360 3df4gheknm2j6b827o3lm14b60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181937.9450 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.9570 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181937.9790 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6615749253661578a917',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6615760214661578a8ac' ,0,0 ,2,23.00,50000,?,?,?)
20240409@181937.1274 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.1304 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181937.1309 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615749253661578a917','aut6615760214661578a8ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181937.1313 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181937.1316 3df4gheknm2j6b827o3lm14b60 Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240409@181937.1326 3df4gheknm2j6b827o3lm14b60 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240409@181937.1336 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.1350 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181937.1374 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.1386 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181937.1390 3df4gheknm2j6b827o3lm14b60 Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240409@181937.1400 3df4gheknm2j6b827o3lm14b60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181937.1410 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.1421 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181937.1444 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6615776460661578a922',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6615760214661578a8ac' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240409@181937.1734 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.1764 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181937.1769 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615776460661578a922','aut6615760214661578a8ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181937.1773 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181937.1775 3df4gheknm2j6b827o3lm14b60 Query : select st.usalote valor from st where st.ref = '324.682.00.01'
20240409@181937.1787 3df4gheknm2j6b827o3lm14b60 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.682.00.01'
20240409@181937.1797 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.1810 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181937.1833 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.1846 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181937.1850 3df4gheknm2j6b827o3lm14b60 Query : select sestamp valor from se where ref ='324.682.00.01' and lote = 'r2301262200a'
20240409@181937.1861 3df4gheknm2j6b827o3lm14b60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181937.1873 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.1885 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181937.1913 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6615781848661578a92d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6615760214661578a8ac' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240409@181937.2226 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.2241 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181937.2246 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615781848661578a92d','aut6615760214661578a8ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181937.2251 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.2264 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181937.2287 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.2303 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181937.2307 3df4gheknm2j6b827o3lm14b60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181937.2316 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.2329 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181937.2352 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6615743695661578a938',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6615760214661578a8ac' ,0,0 ,2,23.00,90000,?,?,?)
20240409@181937.2668 3df4gheknm2j6b827o3lm14b60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.2683 3df4gheknm2j6b827o3lm14b60 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181937.2687 3df4gheknm2j6b827o3lm14b60 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615743695661578a938','aut6615760214661578a8ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181937.2691 3df4gheknm2j6b827o3lm14b60 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6615760214661578a8ac','2402659','wait',39,'ari17112337378,753000005')
20240409@181937.2707 3df4gheknm2j6b827o3lm14b60 Query : use flama_phc
20240409@181937.2710 3df4gheknm2j6b827o3lm14b60 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@181937.2723 3df4gheknm2j6b827o3lm14b60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1062';
20240409@181937.2744 3df4gheknm2j6b827o3lm14b60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1062';
20240409@181937.2762 3df4gheknm2j6b827o3lm14b60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1062';
20240409@181937.2791 3df4gheknm2j6b827o3lm14b60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1062';
20240409@181937.3213 kesvo1hashelpcp40895hh584j Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240409@181937.3226 kesvo1hashelpcp40895hh584j Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240409@181937.3250 kesvo1hashelpcp40895hh584j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1063';
20240409@181937.3298 kesvo1hashelpcp40895hh584j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1063';
20240409@181937.3317 kesvo1hashelpcp40895hh584j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1063';
20240409@181937.3377 kesvo1hashelpcp40895hh584j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1063';
20240409@181937.3392 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3395 kesvo1hashelpcp40895hh584j Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240409@181937.3408 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3411 kesvo1hashelpcp40895hh584j Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240409@181937.3455 kesvo1hashelpcp40895hh584j Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1470.00.1'
20240409@181937.3466 kesvo1hashelpcp40895hh584j Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402660 and bi.ref ='324.1470.00.1' and bi.lordem =1
20240409@181937.3797 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3801 kesvo1hashelpcp40895hh584j Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240409@181937.3813 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3817 kesvo1hashelpcp40895hh584j Query : select top 1 1 valor from td where td.ndoc = 39
20240409@181937.3831 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3834 kesvo1hashelpcp40895hh584j Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240409@181937.3846 kesvo1hashelpcp40895hh584j Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240409@181937.3863 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3866 kesvo1hashelpcp40895hh584j Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240409@181937.3877 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3880 kesvo1hashelpcp40895hh584j Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240409@181937.3891 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3894 kesvo1hashelpcp40895hh584j Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240409@181937.3905 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3908 kesvo1hashelpcp40895hh584j Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240409@181937.3920 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.3922 kesvo1hashelpcp40895hh584j Query : select 1 valor from td where ndoc = 39
20240409@181937.3932 kesvo1hashelpcp40895hh584j Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240409@181937.3944 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240409@181937.3963 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240409@181937.3979 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240409@181937.3992 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240409@181937.4019 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240409@181937.4032 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240409@181937.4057 kesvo1hashelpcp40895hh584j Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240409@181937.4150 kesvo1hashelpcp40895hh584j Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240409@181937.4159 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240409@181937.4172 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240409@181937.4181 kesvo1hashelpcp40895hh584j Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6615745068661578a963' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240409@181937.4379 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240409@181937.4394 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240409@181937.4428 kesvo1hashelpcp40895hh584j Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240409@181937.4433 kesvo1hashelpcp40895hh584j Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240409@181937.4450 kesvo1hashelpcp40895hh584j Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240409@181937.4455 kesvo1hashelpcp40895hh584j Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240409@181937.4459 kesvo1hashelpcp40895hh584j Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240409@181937.4465 kesvo1hashelpcp40895hh584j Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240409@181937.4469 kesvo1hashelpcp40895hh584j Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6615745068661578a963',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240409@181937.4757 kesvo1hashelpcp40895hh584j Query : select top 1 fno valor from wsft039data order by fno desc
20240409@181937.4777 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240409@181937.4791 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240409@181937.4832 kesvo1hashelpcp40895hh584j Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6615745068661578a963',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',822,100810,0,'2024-04-09',39,'euro',0,0,2024 ,'20240409','1849',?,?,?,?)
20240409@181937.5619 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.6067 kesvo1hashelpcp40895hh584j Query : select st.usalote valor from st where st.ref = '324.1470.00.1'
20240409@181937.6086 kesvo1hashelpcp40895hh584j Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1470.00.1'
20240409@181937.6099 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.6113 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240409@181937.6137 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.6150 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240409@181937.6155 kesvo1hashelpcp40895hh584j Query : select sestamp valor from se where ref ='324.1470.00.1' and lote = 'r2100312200a'
20240409@181937.6165 kesvo1hashelpcp40895hh584j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240409@181937.6176 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240409@181937.6189 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240409@181937.6242 kesvo1hashelpcp40895hh584j Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6615736325661578a996',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6615745068661578a963' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240409@181937.6563 kesvo1hashelpcp40895hh584j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240409@181937.6578 kesvo1hashelpcp40895hh584j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240409@181937.6582 kesvo1hashelpcp40895hh584j Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6615736325661578a996','aut6615745068661578a963' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240409@181937.6587 kesvo1hashelpcp40895hh584j Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6615745068661578a963','2402660','wait',39,'ari17112337378,753000005')
20240409@181937.6602 kesvo1hashelpcp40895hh584j Query : use flama_phc
20240409@181937.6605 kesvo1hashelpcp40895hh584j Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@181937.6616 kesvo1hashelpcp40895hh584j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1063';
20240409@181937.6635 kesvo1hashelpcp40895hh584j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1063';
20240409@181937.6650 kesvo1hashelpcp40895hh584j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1063';
20240409@181937.6667 kesvo1hashelpcp40895hh584j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1063';
20240409@183612.5200 k78l74tpufarn8ug604o3ueitf Query : use flama_phc
20240409@183612.5212 k78l74tpufarn8ug604o3ueitf Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@183612.5230 k78l74tpufarn8ug604o3ueitf Query : use flama_phc
20240409@183612.5233 k78l74tpufarn8ug604o3ueitf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@191914.3670 648fpq415gjenjnv91757reot9 Query : use flama_phc
20240409@191914.3675 648fpq415gjenjnv91757reot9 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@191914.3729 648fpq415gjenjnv91757reot9 Query : use flama_phc
20240409@191914.3732 648fpq415gjenjnv91757reot9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@193614.5230 onpqt36gq096nvi93gobo1ap4a Query : use flama_phc
20240409@193614.5234 onpqt36gq096nvi93gobo1ap4a Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@193614.5250 onpqt36gq096nvi93gobo1ap4a Query : use flama_phc
20240409@193614.5254 onpqt36gq096nvi93gobo1ap4a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@201933.3185 hhao7f3am8511pmaedjjloomeo Query : use flama_phc
20240409@201933.3190 hhao7f3am8511pmaedjjloomeo Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@201933.3208 hhao7f3am8511pmaedjjloomeo Query : use flama_phc
20240409@201933.3211 hhao7f3am8511pmaedjjloomeo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@203633.2495 jgg1au7jmsntet6oe4lo6uk2d5 Query : use flama_phc
20240409@203633.2500 jgg1au7jmsntet6oe4lo6uk2d5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@203633.2521 jgg1au7jmsntet6oe4lo6uk2d5 Query : use flama_phc
20240409@203633.2524 jgg1au7jmsntet6oe4lo6uk2d5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@211911.6232 vapium2pt92nrgdcjl0ne52gf6 Query : use flama_phc
20240409@211911.6237 vapium2pt92nrgdcjl0ne52gf6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@211911.6256 vapium2pt92nrgdcjl0ne52gf6 Query : use flama_phc
20240409@211911.6260 vapium2pt92nrgdcjl0ne52gf6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@213611.7005 df2h1om2f3hahb84ieoblcuksn Query : use flama_phc
20240409@213611.7010 df2h1om2f3hahb84ieoblcuksn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@213611.7053 df2h1om2f3hahb84ieoblcuksn Query : use flama_phc
20240409@213611.7056 df2h1om2f3hahb84ieoblcuksn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@221913.6234 oaotomio54fe575shpal5et5l7 Query : use flama_phc
20240409@221913.6256 oaotomio54fe575shpal5et5l7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@221913.6272 oaotomio54fe575shpal5et5l7 Query : use flama_phc
20240409@221913.6275 oaotomio54fe575shpal5et5l7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@223613.5080 q0fnqg1dck67sbk7e7ohfdoqno Query : use flama_phc
20240409@223613.5310 q0fnqg1dck67sbk7e7ohfdoqno Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@223613.6230 q0fnqg1dck67sbk7e7ohfdoqno Query : use flama_phc
20240409@223613.6450 q0fnqg1dck67sbk7e7ohfdoqno Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@231911.4400 jmmmn5lia6ibii6rs44gluafcl Query : use flama_phc
20240409@231911.4405 jmmmn5lia6ibii6rs44gluafcl Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@231911.4422 jmmmn5lia6ibii6rs44gluafcl Query : use flama_phc
20240409@231911.4425 jmmmn5lia6ibii6rs44gluafcl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240409@233611.5040 r6r9ct4gb8p4ue441svdgfga6r Query : use flama_phc
20240409@233611.5045 r6r9ct4gb8p4ue441svdgfga6r Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240409@233611.5061 r6r9ct4gb8p4ue441svdgfga6r Query : use flama_phc
20240409@233611.5064 r6r9ct4gb8p4ue441svdgfga6r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@071917.3414 ak2c4bp1i32t31j8c4ho0kiuua Query : use flama_phc
20240410@071917.3420 ak2c4bp1i32t31j8c4ho0kiuua Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@071917.3983 ak2c4bp1i32t31j8c4ho0kiuua Query : use flama_phc
20240410@071917.3988 ak2c4bp1i32t31j8c4ho0kiuua Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@073621.3525 7tpabjm2798q5qgmsb546ijqra Query : use flama_phc
20240410@073621.3529 7tpabjm2798q5qgmsb546ijqra Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@073621.3545 7tpabjm2798q5qgmsb546ijqra Query : use flama_phc
20240410@073621.3548 7tpabjm2798q5qgmsb546ijqra Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@080302.5287 lckn9ev8r2cdnvfs2v4c88p65r Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240410@080302.5336 lckn9ev8r2cdnvfs2v4c88p65r Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240410@080302.5502 lckn9ev8r2cdnvfs2v4c88p65r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1064';
20240410@080302.5553 lckn9ev8r2cdnvfs2v4c88p65r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1064';
20240410@080302.5584 lckn9ev8r2cdnvfs2v4c88p65r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1064';
20240410@080302.5600 lckn9ev8r2cdnvfs2v4c88p65r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1064';
20240410@080302.5617 lckn9ev8r2cdnvfs2v4c88p65r Query : use flama_phc
20240410@080302.5620 lckn9ev8r2cdnvfs2v4c88p65r Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240410@080302.5666 lckn9ev8r2cdnvfs2v4c88p65r Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1832.00.2'
20240410@080302.5800 lckn9ev8r2cdnvfs2v4c88p65r Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =trh and bo.boano =20u5 and bo.obrano = 7 and bi.ref ='324.1832.00.2' and bi.lordem =2
20240410@080302.6267 7vp6s25k37mhprbal1kpbom7gc Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240410@080302.6279 7vp6s25k37mhprbal1kpbom7gc Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240410@080302.6340 7vp6s25k37mhprbal1kpbom7gc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1065';
20240410@080302.6398 7vp6s25k37mhprbal1kpbom7gc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1065';
20240410@080302.6419 7vp6s25k37mhprbal1kpbom7gc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1065';
20240410@080302.6434 7vp6s25k37mhprbal1kpbom7gc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1065';
20240410@080302.6451 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.6454 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240410@080302.6480 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.6490 7vp6s25k37mhprbal1kpbom7gc Query : select no, estab,szadrsdesc from szadrs where u_coddest=8102
20240410@080302.6586 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4005.00.2'
20240410@080302.6738 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4005.00.2'
20240410@080302.6749 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.6753 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240410@080302.6929 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.6933 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 1 valor from td where td.ndoc = 39
20240410@080302.7038 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.7042 7vp6s25k37mhprbal1kpbom7gc Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240410@080302.7091 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240410@080302.7228 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.7232 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 ~inactivo valor from cl where no = '102936' and estab = 0 order by inactivo desc
20240410@080302.7431 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.7434 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240410@080302.8487 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.8833 7vp6s25k37mhprbal1kpbom7gc Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240410@080302.8903 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.8907 7vp6s25k37mhprbal1kpbom7gc Query : select szadrsstamp valor from szadrs where szadrsdesc='casa por itm'
20240410@080302.8922 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080302.8925 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from td where ndoc = 39
20240410@080302.9011 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240410@080302.9082 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240410@080302.9465 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240410@080302.9538 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240410@080302.9871 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240410@080302.9966 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240410@080303.3480 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240410@080303.3970 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240410@080303.7650 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240410@080303.9080 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240410@080303.9220 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240410@080303.1002 7vp6s25k37mhprbal1kpbom7gc Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6616349365661639a709' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240410@080303.1596 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240410@080303.1614 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240410@080303.1668 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240410@080303.1762 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240410@080303.1834 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240410@080303.1900 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240410@080303.1974 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240410@080303.2126 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240410@080303.2204 7vp6s25k37mhprbal1kpbom7gc Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6616349365661639a709',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240410@080303.2680 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 fno valor from wsft039data order by fno desc
20240410@080303.2773 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240410@080303.2786 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240410@080303.2823 7vp6s25k37mhprbal1kpbom7gc Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6616349365661639a709',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',823,102936,0,'2024-04-10',39,'euro',0,0,2024 ,'20240410','0833',?,?,?,?)
20240410@080303.4539 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080303.4543 7vp6s25k37mhprbal1kpbom7gc Query : select st.usalote valor from st where st.ref = '304.4005.00.2'
20240410@080303.4733 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4005.00.2'
20240410@080303.4884 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240410@080303.5186 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240410@080303.5247 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240410@080303.5554 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240410@080303.5579 7vp6s25k37mhprbal1kpbom7gc Query : select sestamp valor from se where ref ='304.4005.00.2' and lote = '230086'
20240410@080303.5659 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240410@080303.5696 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240410@080303.5710 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240410@080303.5755 7vp6s25k37mhprbal1kpbom7gc Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut6616377466661639a78b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut6616349365661639a709' ,0,0 ,2,23.00,10000,?,?,?,?)
20240410@080303.6497 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240410@080303.6513 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240410@080303.6538 7vp6s25k37mhprbal1kpbom7gc Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6616377466661639a78b','aut6616349365661639a709' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240410@080303.6648 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080303.6653 7vp6s25k37mhprbal1kpbom7gc Query : select st.usalote valor from st where st.ref = '304.4005.00.2'
20240410@080303.6666 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4005.00.2'
20240410@080303.6679 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240410@080303.6692 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240410@080303.6719 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240410@080303.6759 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240410@080303.6764 7vp6s25k37mhprbal1kpbom7gc Query : select sestamp valor from se where ref ='304.4005.00.2' and lote = '230086'
20240410@080303.6775 7vp6s25k37mhprbal1kpbom7gc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240410@080303.6784 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240410@080303.6799 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240410@080303.6823 7vp6s25k37mhprbal1kpbom7gc Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut6616330561661639a7a5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut6616349365661639a709' ,0,0 ,2,23.00,20000,?,?,?,?)
20240410@080303.7109 7vp6s25k37mhprbal1kpbom7gc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240410@080303.7134 7vp6s25k37mhprbal1kpbom7gc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240410@080303.7138 7vp6s25k37mhprbal1kpbom7gc Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6616330561661639a7a5','aut6616349365661639a709' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240410@080303.7144 7vp6s25k37mhprbal1kpbom7gc Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6616349365661639a709','2402588','wait',39,'ari17112337378,753000005')
20240410@080303.7225 7vp6s25k37mhprbal1kpbom7gc Query : use flama_phc
20240410@080303.7229 7vp6s25k37mhprbal1kpbom7gc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@080303.7258 7vp6s25k37mhprbal1kpbom7gc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1065';
20240410@080303.7277 7vp6s25k37mhprbal1kpbom7gc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1065';
20240410@080303.7292 7vp6s25k37mhprbal1kpbom7gc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1065';
20240410@080303.7306 7vp6s25k37mhprbal1kpbom7gc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1065';
20240410@081914.3595 bbiakqe6lhu0n2pt6e91vmjjeo Query : use flama_phc
20240410@081914.3600 bbiakqe6lhu0n2pt6e91vmjjeo Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@081914.3666 bbiakqe6lhu0n2pt6e91vmjjeo Query : use flama_phc
20240410@081914.3669 bbiakqe6lhu0n2pt6e91vmjjeo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@083614.2887 vpm400vep57ebom53t5a4qj7fn Query : use flama_phc
20240410@083614.2891 vpm400vep57ebom53t5a4qj7fn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@083614.2909 vpm400vep57ebom53t5a4qj7fn Query : use flama_phc
20240410@083614.2912 vpm400vep57ebom53t5a4qj7fn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@091911.7089 q8kp9lamdkbk4fsh31tap31pui Query : use flama_phc
20240410@091911.7103 q8kp9lamdkbk4fsh31tap31pui Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@091911.7234 q8kp9lamdkbk4fsh31tap31pui Query : use flama_phc
20240410@091911.7237 q8kp9lamdkbk4fsh31tap31pui Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@093612.1995 559videnod7h83csg87mtp2msh Query : use flama_phc
20240410@093612.2002 559videnod7h83csg87mtp2msh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@093612.2022 559videnod7h83csg87mtp2msh Query : use flama_phc
20240410@093612.2025 559videnod7h83csg87mtp2msh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@101919.5051 mc84t110b0sovnat6kt7027f5h Query : use flama_phc
20240410@101919.5056 mc84t110b0sovnat6kt7027f5h Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@101919.5074 mc84t110b0sovnat6kt7027f5h Query : use flama_phc
20240410@101919.5077 mc84t110b0sovnat6kt7027f5h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@103619.2930 qma083r3gr40m7hboqjk825oi3 Query : use flama_phc
20240410@103619.2941 qma083r3gr40m7hboqjk825oi3 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@103619.3041 qma083r3gr40m7hboqjk825oi3 Query : use flama_phc
20240410@103619.3044 qma083r3gr40m7hboqjk825oi3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@104925.5631 c8kr1cofd7u424fbh416qg7m2n Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240410@104925.5668 c8kr1cofd7u424fbh416qg7m2n Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240410@104925.5801 c8kr1cofd7u424fbh416qg7m2n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1066';
20240410@104925.5857 c8kr1cofd7u424fbh416qg7m2n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1066';
20240410@104925.5890 c8kr1cofd7u424fbh416qg7m2n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1066';
20240410@104925.5907 c8kr1cofd7u424fbh416qg7m2n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1066';
20240410@104925.5921 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104925.5925 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240410@104925.5981 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104925.5985 c8kr1cofd7u424fbh416qg7m2n Query : select no, estab,szadrsdesc from szadrs where u_coddest=3155
20240410@104925.6076 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2231.00.1'
20240410@104925.6222 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.736.00.01'
20240410@104925.6435 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1536.00.1'
20240410@104925.6617 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1685.00.1'
20240410@104925.6775 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240410@104925.7413 c8kr1cofd7u424fbh416qg7m2n 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'
20240410@104925.8427 c8kr1cofd7u424fbh416qg7m2n 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'
20240410@104925.9059 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104925.9150 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240410@104925.9544 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104925.9547 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 1 valor from td where td.ndoc = 39
20240410@104925.9625 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104925.9628 c8kr1cofd7u424fbh416qg7m2n Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240410@104925.9678 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240410@104925.9801 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104925.9804 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 ~inactivo valor from cl where no = '101176' and estab = 0 order by inactivo desc
20240410@104925.9914 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104925.9918 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240410@104926.1000 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104926.4000 c8kr1cofd7u424fbh416qg7m2n Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240410@104926.5300 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104926.5600 c8kr1cofd7u424fbh416qg7m2n Query : select szadrsstamp valor from szadrs where szadrsdesc='soares & filhos, lda.-entrega'
20240410@104926.1040 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104926.1070 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from td where ndoc = 39
20240410@104926.2010 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240410@104926.2790 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240410@104926.6540 c8kr1cofd7u424fbh416qg7m2n Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240410@104926.7110 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240410@104926.1034 c8kr1cofd7u424fbh416qg7m2n Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240410@104926.1097 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240410@104926.1417 c8kr1cofd7u424fbh416qg7m2n Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240410@104926.1488 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240410@104926.1721 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240410@104926.1848 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240410@104926.1903 c8kr1cofd7u424fbh416qg7m2n Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240410@104926.1962 c8kr1cofd7u424fbh416qg7m2n Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6616605855661660a624' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240410@104926.2649 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240410@104926.2664 c8kr1cofd7u424fbh416qg7m2n Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240410@104926.2720 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240410@104926.2808 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240410@104926.2888 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240410@104926.2972 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240410@104926.3061 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240410@104926.3142 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240410@104926.3227 c8kr1cofd7u424fbh416qg7m2n Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6616605855661660a624',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240410@104926.3892 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 fno valor from wsft039data order by fno desc
20240410@104926.3983 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240410@104926.3998 c8kr1cofd7u424fbh416qg7m2n Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240410@104926.4149 c8kr1cofd7u424fbh416qg7m2n Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6616605855661660a624',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',824,101176,0,'2024-04-10',39,'euro',0,0,2024 ,'20240410','1119',?,?,?,?)
20240410@104926.5394 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104926.5399 c8kr1cofd7u424fbh416qg7m2n Query : select st.usalote valor from st where st.ref = '324.2231.00.1'
20240410@104926.6185 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2231.00.1'
20240410@104926.6984 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240410@104926.7358 c8kr1cofd7u424fbh416qg7m2n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240410@104926.7417 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240410@104926.7831 c8kr1cofd7u424fbh416qg7m2n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240410@104926.7858 c8kr1cofd7u424fbh416qg7m2n Query : select sestamp valor from se where ref ='324.2231.00.1' and lote = 'r2301141275a'
20240410@104926.7921 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240410@104926.7991 c8kr1cofd7u424fbh416qg7m2n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240410@104926.8005 c8kr1cofd7u424fbh416qg7m2n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240410@104926.8092 c8kr1cofd7u424fbh416qg7m2n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut6616612047661660a6c3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6616605855661660a624' ,0,0 ,2,23.00,10000,?,?,?,?)
20240410@104926.8832 c8kr1cofd7u424fbh416qg7m2n Query : use flama_phc
20240410@104926.8835 c8kr1cofd7u424fbh416qg7m2n Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20240410@104926.8946 c8kr1cofd7u424fbh416qg7m2n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1066';
20240410@104926.8965 c8kr1cofd7u424fbh416qg7m2n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1066';
20240410@111914.4137 tf2ipjplmd4to13vg4mm6qgjo7 Query : use flama_phc
20240410@111914.4143 tf2ipjplmd4to13vg4mm6qgjo7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@111914.4200 tf2ipjplmd4to13vg4mm6qgjo7 Query : use flama_phc
20240410@111914.4230 tf2ipjplmd4to13vg4mm6qgjo7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@113614.6921 kuu0c5gp8ngn6lc6s9g37cjb7b Query : use flama_phc
20240410@113614.6960 kuu0c5gp8ngn6lc6s9g37cjb7b Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@113614.6977 kuu0c5gp8ngn6lc6s9g37cjb7b Query : use flama_phc
20240410@113614.6980 kuu0c5gp8ngn6lc6s9g37cjb7b Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@121912.6749 7831539of1pd89mmv9e84c2632 Query : use flama_phc
20240410@121912.6753 7831539of1pd89mmv9e84c2632 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@121912.6813 7831539of1pd89mmv9e84c2632 Query : use flama_phc
20240410@121912.6816 7831539of1pd89mmv9e84c2632 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@131912.8428 2eripj9qv40i2e9plg2jgnf76c Query : use flama_phc
20240410@131912.8433 2eripj9qv40i2e9plg2jgnf76c Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@131912.8453 2eripj9qv40i2e9plg2jgnf76c Query : use flama_phc
20240410@131912.8456 2eripj9qv40i2e9plg2jgnf76c Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@133615.5599 ih0fmore2famvkf9de5dvu1g08 Query : use flama_phc
20240410@133615.5604 ih0fmore2famvkf9de5dvu1g08 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@133615.5620 ih0fmore2famvkf9de5dvu1g08 Query : use flama_phc
20240410@133615.5623 ih0fmore2famvkf9de5dvu1g08 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@141910.4940 4a38u1s432mcaslbv5qmcvivqd Query : use flama_phc
20240410@141910.4944 4a38u1s432mcaslbv5qmcvivqd Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@141910.4961 4a38u1s432mcaslbv5qmcvivqd Query : use flama_phc
20240410@141910.4963 4a38u1s432mcaslbv5qmcvivqd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@143405.2196 09cfrdce1d3l1i92h3api3h63f Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240410@143405.2217 09cfrdce1d3l1i92h3api3h63f Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240410@143405.2298 09cfrdce1d3l1i92h3api3h63f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1067';
20240410@143405.2359 09cfrdce1d3l1i92h3api3h63f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1067';
20240410@143405.2377 09cfrdce1d3l1i92h3api3h63f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1067';
20240410@143405.2397 09cfrdce1d3l1i92h3api3h63f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1067';
20240410@143405.2412 09cfrdce1d3l1i92h3api3h63f Query : use flama_phc
20240410@143405.2416 09cfrdce1d3l1i92h3api3h63f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240410@143405.2437 09cfrdce1d3l1i92h3api3h63f Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1879.00.1'
20240410@143405.2556 09cfrdce1d3l1i92h3api3h63f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =gt2 and bo.boano =2002 and bo.obrano = 1 and bi.ref ='324.1879.00.1' and bi.lordem =2
20240410@143611.3370 4h0g1eh9j9c70pugs0dd785hdr Query : use flama_phc
20240410@143611.3420 4h0g1eh9j9c70pugs0dd785hdr Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@143611.3960 4h0g1eh9j9c70pugs0dd785hdr Query : use flama_phc
20240410@143611.4300 4h0g1eh9j9c70pugs0dd785hdr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@151916.6422 7kj2qb8cdlj505egdg7hhnl8t2 Query : use flama_phc
20240410@151916.6426 7kj2qb8cdlj505egdg7hhnl8t2 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@151916.6465 7kj2qb8cdlj505egdg7hhnl8t2 Query : use flama_phc
20240410@151916.6468 7kj2qb8cdlj505egdg7hhnl8t2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@153616.6968 sdpe5rlsu20mtl3jqsgq855mn1 Query : use flama_phc
20240410@153616.6972 sdpe5rlsu20mtl3jqsgq855mn1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@153616.6997 sdpe5rlsu20mtl3jqsgq855mn1 Query : use flama_phc
20240410@153616.7000 sdpe5rlsu20mtl3jqsgq855mn1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@161912.8932 goo3tn02e4g4lngotqh3frpbgn Query : use flama_phc
20240410@161912.8942 goo3tn02e4g4lngotqh3frpbgn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@161912.8961 goo3tn02e4g4lngotqh3frpbgn Query : use flama_phc
20240410@161912.8964 goo3tn02e4g4lngotqh3frpbgn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@163612.8577 s6h3p8grm4n9t95ntkatp50s2q Query : use flama_phc
20240410@163612.8588 s6h3p8grm4n9t95ntkatp50s2q Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@163612.8603 s6h3p8grm4n9t95ntkatp50s2q Query : use flama_phc
20240410@163612.8606 s6h3p8grm4n9t95ntkatp50s2q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@171911.1810 bqpln2dqgq7ck8hiaj21jkf9nk Query : use flama_phc
20240410@171911.1890 bqpln2dqgq7ck8hiaj21jkf9nk Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@171911.2140 bqpln2dqgq7ck8hiaj21jkf9nk Query : use flama_phc
20240410@171911.2180 bqpln2dqgq7ck8hiaj21jkf9nk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@173610.7647 dabdbu2q0303pvmg0lsijhmcoq Query : use flama_phc
20240410@173610.7652 dabdbu2q0303pvmg0lsijhmcoq Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@173610.7716 dabdbu2q0303pvmg0lsijhmcoq Query : use flama_phc
20240410@173610.7719 dabdbu2q0303pvmg0lsijhmcoq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@181912.9250 a08rc5u78blf91uruv7j5pikn5 Query : use flama_phc
20240410@181912.9290 a08rc5u78blf91uruv7j5pikn5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@181912.9840 a08rc5u78blf91uruv7j5pikn5 Query : use flama_phc
20240410@181912.9870 a08rc5u78blf91uruv7j5pikn5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@183611.8986 b3osm4a23tchobmrcnqe3pilbn Query : use flama_phc
20240410@183611.8991 b3osm4a23tchobmrcnqe3pilbn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@183611.9008 b3osm4a23tchobmrcnqe3pilbn Query : use flama_phc
20240410@183611.9010 b3osm4a23tchobmrcnqe3pilbn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@191911.3059 i6mcr6m20eqdkvfdfif58oc5r7 Query : use flama_phc
20240410@191911.3063 i6mcr6m20eqdkvfdfif58oc5r7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@191911.3079 i6mcr6m20eqdkvfdfif58oc5r7 Query : use flama_phc
20240410@191911.3082 i6mcr6m20eqdkvfdfif58oc5r7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@193611.6789 pbmp1vailqbf7rr08tcoho8cpe Query : use flama_phc
20240410@193611.6793 pbmp1vailqbf7rr08tcoho8cpe Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@193611.6808 pbmp1vailqbf7rr08tcoho8cpe Query : use flama_phc
20240410@193611.6811 pbmp1vailqbf7rr08tcoho8cpe Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@201913.2310 puvfbokgo73ks3d9n3lofa0duq Query : use flama_phc
20240410@201913.2315 puvfbokgo73ks3d9n3lofa0duq Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@201913.2331 puvfbokgo73ks3d9n3lofa0duq Query : use flama_phc
20240410@201913.2334 puvfbokgo73ks3d9n3lofa0duq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@201913.4147 qbck9e1f9uav3k42nntpb1o6r6 Query : use flama_phc
20240410@201913.4151 qbck9e1f9uav3k42nntpb1o6r6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@201913.4165 qbck9e1f9uav3k42nntpb1o6r6 Query : use flama_phc
20240410@201913.4168 qbck9e1f9uav3k42nntpb1o6r6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@201923.6378 r5uvfgtfanrb7aahf3kpdlf50b Query : use flama_phc
20240410@201923.6391 r5uvfgtfanrb7aahf3kpdlf50b Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@201923.6407 r5uvfgtfanrb7aahf3kpdlf50b Query : use flama_phc
20240410@201923.6410 r5uvfgtfanrb7aahf3kpdlf50b Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@203623.6407 oqoljv3bj9jp320355f4u3mahb Query : use flama_phc
20240410@203623.6469 oqoljv3bj9jp320355f4u3mahb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@203623.6486 oqoljv3bj9jp320355f4u3mahb Query : use flama_phc
20240410@203623.6490 oqoljv3bj9jp320355f4u3mahb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@211911.6790 c7o3btp4fl3nd9b90u24rnclkn Query : use flama_phc
20240410@211911.6796 c7o3btp4fl3nd9b90u24rnclkn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@211911.6814 c7o3btp4fl3nd9b90u24rnclkn Query : use flama_phc
20240410@211911.6817 c7o3btp4fl3nd9b90u24rnclkn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@213611.6252 qhlrft5hqtn3ml5o7amudcv3em Query : use flama_phc
20240410@213611.6257 qhlrft5hqtn3ml5o7amudcv3em Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@213611.6276 qhlrft5hqtn3ml5o7amudcv3em Query : use flama_phc
20240410@213611.6280 qhlrft5hqtn3ml5o7amudcv3em Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@221911.7045 63ik7h6ncnn3adscrtsubrf03u Query : use flama_phc
20240410@221911.7050 63ik7h6ncnn3adscrtsubrf03u Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@221911.7065 63ik7h6ncnn3adscrtsubrf03u Query : use flama_phc
20240410@221911.7067 63ik7h6ncnn3adscrtsubrf03u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@223611.5431 sdgenu6gg2mnmoj7h26idi2js0 Query : use flama_phc
20240410@223611.5435 sdgenu6gg2mnmoj7h26idi2js0 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@223611.5453 sdgenu6gg2mnmoj7h26idi2js0 Query : use flama_phc
20240410@223611.5456 sdgenu6gg2mnmoj7h26idi2js0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@231910.4337 mk423r46vbp30lakmm70j2ht8e Query : use flama_phc
20240410@231910.4341 mk423r46vbp30lakmm70j2ht8e Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@231910.4360 mk423r46vbp30lakmm70j2ht8e Query : use flama_phc
20240410@231910.4364 mk423r46vbp30lakmm70j2ht8e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240410@233610.1421 64knkicbrha7jee0b43sd73h1k Query : use flama_phc
20240410@233610.1428 64knkicbrha7jee0b43sd73h1k Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240410@233610.1445 64knkicbrha7jee0b43sd73h1k Query : use flama_phc
20240410@233610.1448 64knkicbrha7jee0b43sd73h1k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240411@071913.2173 kikfb2hbflegshfghv86pdo8d9 Query : use flama_phc
20240411@071913.2178 kikfb2hbflegshfghv86pdo8d9 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240411@071913.2275 kikfb2hbflegshfghv86pdo8d9 Query : use flama_phc
20240411@071913.2278 kikfb2hbflegshfghv86pdo8d9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240411@073627.5719 mh44bta30pgqld99j3k34aljvh Query : use flama_phc
20240411@073627.5785 mh44bta30pgqld99j3k34aljvh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240411@073627.6170 mh44bta30pgqld99j3k34aljvh Query : use flama_phc
20240411@073627.6174 mh44bta30pgqld99j3k34aljvh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240411@074414.3773 7s4t3m85rdho467bmvga2hnnt5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240411@074414.5001 7s4t3m85rdho467bmvga2hnnt5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240411@074414.5626 7s4t3m85rdho467bmvga2hnnt5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1068';
20240411@074414.6061 7s4t3m85rdho467bmvga2hnnt5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1068';
20240411@074414.6166 7s4t3m85rdho467bmvga2hnnt5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1068';
20240411@074414.6312 7s4t3m85rdho467bmvga2hnnt5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1068';
20240411@074414.6364 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074414.6443 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240411@074414.6566 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074414.6570 7s4t3m85rdho467bmvga2hnnt5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4789
20240411@074414.6891 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1536.00.1'
20240411@074414.7348 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402599 and bi.ref ='324.1536.00.1' and bi.lordem =1
20240411@074414.8247 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240411@074414.8555 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402599 and bi.ref ='304.4320.00.1' and bi.lordem =2
20240411@074414.9135 7s4t3m85rdho467bmvga2hnnt5 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'
20240411@074414.9662 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402599 and bi.ref ='324.4970.00.1' and bi.lordem =3
20240411@074415.5920 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4743.00.1'
20240411@074415.9010 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402599 and bi.ref ='324.4743.00.1' and bi.lordem =4
20240411@074415.1479 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074415.1521 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240411@074415.2054 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074415.2096 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 1 valor from td where td.ndoc = 39
20240411@074415.2532 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074415.2576 7s4t3m85rdho467bmvga2hnnt5 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240411@074415.2708 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240411@074415.3163 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074415.3206 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 ~inactivo valor from cl where no = '101987' and estab = 0 order by inactivo desc
20240411@074415.3656 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074415.3697 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240411@074415.4017 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074415.4058 7s4t3m85rdho467bmvga2hnnt5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240411@074415.4322 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074415.4326 7s4t3m85rdho467bmvga2hnnt5 Query : select szadrsstamp valor from szadrs where szadrsdesc='101987 - media markt nascente, lda.'
20240411@074415.4399 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074415.4441 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from td where ndoc = 39
20240411@074415.4575 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240411@074415.4868 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240411@074415.5964 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240411@074415.7041 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240411@074415.7785 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240411@074415.8674 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240411@074415.9402 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240411@074415.9781 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240411@074416.6220 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240411@074416.8510 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240411@074416.8660 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240411@074416.9060 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6617840425661786bfee' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240411@074416.4225 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240411@074416.4438 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240411@074416.4905 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240411@074416.5139 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240411@074416.5309 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240411@074416.5553 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240411@074416.5777 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240411@074416.6021 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240411@074416.6271 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6617840425661786bfee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240411@074416.8669 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 fno valor from wsft039data order by fno desc
20240411@074416.8903 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240411@074416.9044 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240411@074416.9440 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6617840425661786bfee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',824,101987,0,'2024-04-11',39,'euro',0,0,2024 ,'20240411','0814',?,?,?,?)
20240411@074417.4857 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074417.4888 7s4t3m85rdho467bmvga2hnnt5 Query : select st.usalote valor from st where st.ref = '324.1536.00.1'
20240411@074417.5302 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1536.00.1'
20240411@074417.5695 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074417.6416 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240411@074417.7010 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240411@074417.7724 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240411@074417.7748 7s4t3m85rdho467bmvga2hnnt5 Query : select sestamp valor from se where ref ='324.1536.00.1' and lote = 'r2100240100a'
20240411@074417.7916 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240411@074417.8093 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074417.8142 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240411@074417.8760 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6617862990661786c1c5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6617840425661786bfee' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240411@074418.3431 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240411@074418.3577 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240411@074418.4125 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6617862990661786c1c5','aut6617840425661786bfee' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240411@074418.5981 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074418.6022 7s4t3m85rdho467bmvga2hnnt5 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240411@074418.6173 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240411@074418.6617 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074418.6828 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240411@074418.7135 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240411@074418.7299 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240411@074418.7304 7s4t3m85rdho467bmvga2hnnt5 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240350'
20240411@074418.7316 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240411@074418.7326 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074418.7423 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240411@074418.7703 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6617857171661786c2b2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6617840425661786bfee' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240411@074418.8487 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240411@074418.8696 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240411@074418.8796 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6617857171661786c2b2','aut6617840425661786bfee' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240411@074418.8840 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074418.8883 7s4t3m85rdho467bmvga2hnnt5 Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240411@074418.8923 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240411@074418.9208 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074418.9222 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240411@074418.9252 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240411@074418.9454 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240411@074418.9521 7s4t3m85rdho467bmvga2hnnt5 Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240411@074418.9704 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240411@074418.9913 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074419.1280 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240411@074419.3910 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6617807945661786c2f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6617840425661786bfee' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240411@074419.8890 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240411@074419.1076 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240411@074419.1081 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6617807945661786c2f2','aut6617840425661786bfee' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240411@074419.1087 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074419.1090 7s4t3m85rdho467bmvga2hnnt5 Query : select st.usalote valor from st where st.ref = '324.4743.00.1'
20240411@074419.1270 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4743.00.1'
20240411@074419.1769 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074419.1980 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240411@074419.2312 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240411@074419.2326 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240411@074419.2330 7s4t3m85rdho467bmvga2hnnt5 Query : select sestamp valor from se where ref ='324.4743.00.1' and lote = 'r2200085100a'
20240411@074419.2352 7s4t3m85rdho467bmvga2hnnt5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240411@074419.2527 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074419.2630 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240411@074419.2908 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6617850298661786c33d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6617840425661786bfee' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240411@074419.3742 7s4t3m85rdho467bmvga2hnnt5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240411@074419.4794 7s4t3m85rdho467bmvga2hnnt5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240411@074419.4843 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6617850298661786c33d','aut6617840425661786bfee' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240411@074419.4848 7s4t3m85rdho467bmvga2hnnt5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6617840425661786bfee','2402599','wait',39,'ari17112337378,753000005')
20240411@074419.4889 7s4t3m85rdho467bmvga2hnnt5 Query : use flama_phc
20240411@074419.4959 7s4t3m85rdho467bmvga2hnnt5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240411@074419.5043 7s4t3m85rdho467bmvga2hnnt5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1068';
20240411@074419.5156 7s4t3m85rdho467bmvga2hnnt5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1068';
20240411@074419.5258 7s4t3m85rdho467bmvga2hnnt5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1068';
20240411@074419.5476 7s4t3m85rdho467bmvga2hnnt5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1068';
20240411@074419.6057 8u539c1nc4jl0t0qqe9e3phl8i Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240411@074419.6103 8u539c1nc4jl0t0qqe9e3phl8i Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240411@074419.6225 8u539c1nc4jl0t0qqe9e3phl8i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1069';
20240411@074419.6273 8u539c1nc4jl0t0qqe9e3phl8i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1069';
20240411@074419.6349 8u539c1nc4jl0t0qqe9e3phl8i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1069';
20240411@074419.6568 8u539c1nc4jl0t0qqe9e3phl8i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1069';
20240411@074419.6585 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074419.6588 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240411@074419.6812 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074419.6853 8u539c1nc4jl0t0qqe9e3phl8i Query : select no, estab,szadrsdesc from szadrs where u_coddest=4789
20240411@074419.7092 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240411@074419.7515 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402612 and bi.ref ='324.4990.00.1' and bi.lordem =1
20240411@074419.8149 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20240411@074419.8473 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402612 and bi.ref ='324.4960.00.1' and bi.lordem =2
20240411@074419.9171 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074419.9215 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240411@074419.9425 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074419.9467 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 1 valor from td where td.ndoc = 39
20240411@074419.9636 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074419.9639 8u539c1nc4jl0t0qqe9e3phl8i Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240411@074419.9690 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240411@074419.9807 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074419.9844 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 ~inactivo valor from cl where no = '101987' and estab = 0 order by inactivo desc
20240411@074419.9861 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074419.9864 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240411@074420.1020 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074420.1390 8u539c1nc4jl0t0qqe9e3phl8i Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240411@074420.1530 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074420.1560 8u539c1nc4jl0t0qqe9e3phl8i Query : select szadrsstamp valor from szadrs where szadrsdesc='101987 - media markt nascente, lda.'
20240411@074420.4920 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074420.5340 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from td where ndoc = 39
20240411@074420.7410 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240411@074420.9900 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240411@074420.1124 8u539c1nc4jl0t0qqe9e3phl8i Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240411@074420.1305 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240411@074420.1319 8u539c1nc4jl0t0qqe9e3phl8i Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240411@074420.1501 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240411@074420.1607 8u539c1nc4jl0t0qqe9e3phl8i Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240411@074420.1653 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240411@074420.2010 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240411@074420.2243 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240411@074420.2808 8u539c1nc4jl0t0qqe9e3phl8i Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240411@074420.2987 8u539c1nc4jl0t0qqe9e3phl8i Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6617891401661786c428' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240411@074420.3627 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240411@074420.3854 8u539c1nc4jl0t0qqe9e3phl8i Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240411@074420.4567 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240411@074420.4621 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240411@074420.4627 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240411@074420.4633 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240411@074420.4639 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240411@074420.4644 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240411@074420.4649 8u539c1nc4jl0t0qqe9e3phl8i Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6617891401661786c428',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240411@074420.4962 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 fno valor from wsft039data order by fno desc
20240411@074420.4978 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240411@074420.4996 8u539c1nc4jl0t0qqe9e3phl8i Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240411@074420.5012 8u539c1nc4jl0t0qqe9e3phl8i Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6617891401661786c428',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',825,101987,0,'2024-04-11',39,'euro',0,0,2024 ,'20240411','0814',?,?,?,?)
20240411@074420.5361 8u539c1nc4jl0t0qqe9e3phl8i Query : use flama_phc
20240411@074420.5367 8u539c1nc4jl0t0qqe9e3phl8i Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20240411@074420.5378 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4990.00.1'
20240411@074420.5527 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074420.5540 8u539c1nc4jl0t0qqe9e3phl8i Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240411@074420.5597 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240411@074420.5610 8u539c1nc4jl0t0qqe9e3phl8i Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240411@074420.5614 8u539c1nc4jl0t0qqe9e3phl8i Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20240411@074420.5631 8u539c1nc4jl0t0qqe9e3phl8i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240411@074420.5640 8u539c1nc4jl0t0qqe9e3phl8i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240411@074420.5652 8u539c1nc4jl0t0qqe9e3phl8i Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240411@074420.5673 8u539c1nc4jl0t0qqe9e3phl8i Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6617879579661786c489',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6617891401661786c428' ,0,0 ,2,23.00,10000,?,?,?,?,?)
