20230516@162110.5824 q1dndrl72am22d5jorvq6u5e5f Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23051644613.617000002 '
20230516@162110.5914 q1dndrl72am22d5jorvq6u5e5f Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23051644613.617000002 '
20230516@162110.6077 q1dndrl72am22d5jorvq6u5e5f Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut646390614464639f667d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230516@162110.6392 q1dndrl72am22d5jorvq6u5e5f Query : select top 1 fno valor from wsft039data order by fno desc
20230516@162110.6409 q1dndrl72am22d5jorvq6u5e5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162110.6430 q1dndrl72am22d5jorvq6u5e5f Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230516@162110.6451 q1dndrl72am22d5jorvq6u5e5f 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 ,encomenda ) values ('aut646390614464639f667d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',312,199508,0,'2023-05-16',39,'euro',0,0,2023 ,'20230516','1651',?,?,?,?,?)
20230516@162110.6918 q1dndrl72am22d5jorvq6u5e5f Query : use flama_phc
20230516@162110.6923 q1dndrl72am22d5jorvq6u5e5f Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20230516@162110.6956 q1dndrl72am22d5jorvq6u5e5f 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 = '327.8261.00.1'
20230516@162110.7114 q1dndrl72am22d5jorvq6u5e5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162110.7136 q1dndrl72am22d5jorvq6u5e5f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162110.7161 q1dndrl72am22d5jorvq6u5e5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162110.7175 q1dndrl72am22d5jorvq6u5e5f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162110.7180 q1dndrl72am22d5jorvq6u5e5f Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2200712100a'
20230516@162110.7192 q1dndrl72am22d5jorvq6u5e5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162110.7202 q1dndrl72am22d5jorvq6u5e5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162110.7217 q1dndrl72am22d5jorvq6u5e5f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162110.7241 q1dndrl72am22d5jorvq6u5e5f Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646391212964639f66af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut646390614464639f667d' ,225.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230516@162110.7506 q1dndrl72am22d5jorvq6u5e5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162110.7524 q1dndrl72am22d5jorvq6u5e5f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162110.7529 q1dndrl72am22d5jorvq6u5e5f Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646391212964639f66af','aut646390614464639f667d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162110.7535 q1dndrl72am22d5jorvq6u5e5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162110.7554 q1dndrl72am22d5jorvq6u5e5f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162110.7578 q1dndrl72am22d5jorvq6u5e5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162110.7610 q1dndrl72am22d5jorvq6u5e5f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162110.7615 q1dndrl72am22d5jorvq6u5e5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162110.7627 q1dndrl72am22d5jorvq6u5e5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162110.7642 q1dndrl72am22d5jorvq6u5e5f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162110.7672 q1dndrl72am22d5jorvq6u5e5f Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646395247764639f66ba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut646390614464639f667d' ,0,0 ,2,23.00,20000,?,?,?)
20230516@162110.8013 q1dndrl72am22d5jorvq6u5e5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162110.8029 q1dndrl72am22d5jorvq6u5e5f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162110.8034 q1dndrl72am22d5jorvq6u5e5f Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646395247764639f66ba','aut646390614464639f667d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162110.8053 q1dndrl72am22d5jorvq6u5e5f Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut646390614464639f667d','119230000269','wait',39,'ari17112337378,753000005')
20230516@162110.8071 q1dndrl72am22d5jorvq6u5e5f Query : use flama_phc
20230516@162110.8074 q1dndrl72am22d5jorvq6u5e5f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@162110.8087 q1dndrl72am22d5jorvq6u5e5f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='428';
20230516@162110.8133 q1dndrl72am22d5jorvq6u5e5f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='428';
20230516@162110.8146 q1dndrl72am22d5jorvq6u5e5f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='428';
20230516@162110.8158 q1dndrl72am22d5jorvq6u5e5f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='428';
20230516@162110.8472 9o6j7919re8mc0sh4qq2tlvctd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230516@162110.8492 9o6j7919re8mc0sh4qq2tlvctd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230516@162110.8508 9o6j7919re8mc0sh4qq2tlvctd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='429';
20230516@162110.8546 9o6j7919re8mc0sh4qq2tlvctd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='429';
20230516@162110.8559 9o6j7919re8mc0sh4qq2tlvctd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='429';
20230516@162110.8571 9o6j7919re8mc0sh4qq2tlvctd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='429';
20230516@162110.8583 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.8586 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230516@162110.8602 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.8605 9o6j7919re8mc0sh4qq2tlvctd Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20230516@162110.8744 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20230516@162110.8898 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000270 and bi.ref ='324.5342.00.1' and bi.lordem =20000
20230516@162110.9251 9o6j7919re8mc0sh4qq2tlvctd Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655819,5760000-2 ' 
20230516@162110.9578 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20230516@162110.9600 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000270 and bi.ref ='324.5342.00.1' and bi.lordem =20000
20230516@162110.9613 9o6j7919re8mc0sh4qq2tlvctd Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655819,5760000-2 ' 
20230516@162110.9623 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.9626 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230516@162110.9638 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.9641 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 1 valor from td where td.ndoc = 39
20230516@162110.9652 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.9655 9o6j7919re8mc0sh4qq2tlvctd Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230516@162110.9665 9o6j7919re8mc0sh4qq2tlvctd 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
20230516@162110.9678 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.9681 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20230516@162110.9784 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.9787 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230516@162110.9798 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.9801 9o6j7919re8mc0sh4qq2tlvctd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230516@162110.9810 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.9813 9o6j7919re8mc0sh4qq2tlvctd Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20230516@162110.9825 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162110.9828 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from td where ndoc = 39
20230516@162110.9837 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230516@162110.9847 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162110.9860 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230516@162110.9874 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162110.9885 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230516@162110.9910 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162110.9923 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230516@162110.9933 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162110.9973 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162110.9983 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162110.9995 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230516@162111.6000 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut646393215264639f66f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230516@162111.1680 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162111.2130 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230516@162111.2410 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23050330289,397000001 '
20230516@162111.3570 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23050330289,397000001 '
20230516@162111.4570 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23050330289,397000001 '
20230516@162111.5440 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23050330289,397000001 '
20230516@162111.6290 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23050330289,397000001 '
20230516@162111.7180 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23050330289,397000001 '
20230516@162111.8130 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut646393215264639f66f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230516@162111.1126 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 fno valor from wsft039data order by fno desc
20230516@162111.1196 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162111.1210 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230516@162111.1227 9o6j7919re8mc0sh4qq2tlvctd 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 ,encomenda ) values ('aut646393215264639f66f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',313,100810,0,'2023-05-16',39,'euro',0,0,2023 ,'20230516','1651',?,?,?,?,?)
20230516@162111.1531 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162111.1535 9o6j7919re8mc0sh4qq2tlvctd Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20230516@162111.1547 9o6j7919re8mc0sh4qq2tlvctd 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.5342.00.1'
20230516@162111.1694 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162111.1708 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162111.1731 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162111.1743 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162111.1747 9o6j7919re8mc0sh4qq2tlvctd Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = '06/20'
20230516@162111.1765 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162111.2926 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162111.3658 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162111.3683 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646395562364639f6747',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut646393215264639f66f2' ,19.600000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230516@162111.3928 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162111.3943 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162111.3948 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646395562364639f6747','aut646393215264639f66f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162111.3953 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162111.3966 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162111.3988 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162111.4000 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162111.4004 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162111.4014 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162111.4028 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162111.4051 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646399142464639f6761',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut646393215264639f66f2' ,0,0 ,2,23.00,20000,?,?,?)
20230516@162111.4506 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162111.5291 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162111.5296 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646399142464639f6761','aut646393215264639f66f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162111.5301 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162111.5305 9o6j7919re8mc0sh4qq2tlvctd Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20230516@162111.5335 9o6j7919re8mc0sh4qq2tlvctd 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.5342.00.1'
20230516@162111.5347 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162111.5361 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162111.5385 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162111.5398 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162111.5403 9o6j7919re8mc0sh4qq2tlvctd Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = '06/20'
20230516@162111.5413 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162111.5423 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162111.5435 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162111.5461 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646390632464639f6784',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',144.000 ,'aut646393215264639f66f2' ,19.600000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230516@162111.5719 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162111.5735 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162111.5741 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646390632464639f6784','aut646393215264639f66f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162111.5746 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162111.5760 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162111.5784 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162111.5796 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162111.5801 9o6j7919re8mc0sh4qq2tlvctd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162111.5811 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162111.5824 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162111.5849 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646394700864639f678d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut646393215264639f66f2' ,0,0 ,2,23.00,50000,?,?,?)
20230516@162111.6094 9o6j7919re8mc0sh4qq2tlvctd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162111.6110 9o6j7919re8mc0sh4qq2tlvctd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162111.6116 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646394700864639f678d','aut646393215264639f66f2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162111.6122 9o6j7919re8mc0sh4qq2tlvctd Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut646393215264639f66f2','119230000270','wait',39,'ari17112337378,753000005')
20230516@162111.6139 9o6j7919re8mc0sh4qq2tlvctd Query : use flama_phc
20230516@162111.6142 9o6j7919re8mc0sh4qq2tlvctd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@162111.6154 9o6j7919re8mc0sh4qq2tlvctd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='429';
20230516@162111.6168 9o6j7919re8mc0sh4qq2tlvctd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='429';
20230516@162111.6179 9o6j7919re8mc0sh4qq2tlvctd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='429';
20230516@162111.6190 9o6j7919re8mc0sh4qq2tlvctd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='429';
20230516@162111.6570 m58nmfhou31h1cqrqjpibfqqkd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230516@162111.6583 m58nmfhou31h1cqrqjpibfqqkd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230516@162111.6600 m58nmfhou31h1cqrqjpibfqqkd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='430';
20230516@162111.6640 m58nmfhou31h1cqrqjpibfqqkd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='430';
20230516@162111.6653 m58nmfhou31h1cqrqjpibfqqkd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='430';
20230516@162111.6664 m58nmfhou31h1cqrqjpibfqqkd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='430';
20230516@162111.6675 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.6678 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230516@162111.6690 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.6693 m58nmfhou31h1cqrqjpibfqqkd Query : select no, estab,szadrsdesc from szadrs where u_coddest=864
20230516@162111.6767 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20230516@162111.6783 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000271 and bi.ref ='324.1667.00.1' and bi.lordem =20000
20230516@162111.7127 m58nmfhou31h1cqrqjpibfqqkd Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655830,8810000-2 ' 
20230516@162111.7469 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.7473 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230516@162111.7485 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.7488 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 1 valor from td where td.ndoc = 39
20230516@162111.7504 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.7507 m58nmfhou31h1cqrqjpibfqqkd Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230516@162111.7518 m58nmfhou31h1cqrqjpibfqqkd 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
20230516@162111.7532 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.7535 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 ~inactivo valor from cl where no = '100923' and estab = 0 order by inactivo desc
20230516@162111.7645 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.7650 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230516@162111.7660 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.7663 m58nmfhou31h1cqrqjpibfqqkd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230516@162111.7675 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.7678 m58nmfhou31h1cqrqjpibfqqkd Query : select szadrsstamp valor from szadrs where szadrsdesc='jose manuel gama neves antunes'
20230516@162111.7692 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.7695 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from td where ndoc = 39
20230516@162111.7705 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230516@162111.7715 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162111.7728 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230516@162111.7745 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162111.7758 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230516@162111.7789 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162111.7802 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230516@162111.7813 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162111.7855 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162111.7865 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162111.7878 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230516@162111.7888 m58nmfhou31h1cqrqjpibfqqkd Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut646395558364639f67be' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230516@162111.8074 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162111.8089 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230516@162111.8118 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='af4d02add415d02069425c '
20230516@162111.8223 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='af4d02add415d02069425c '
20230516@162111.8323 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='af4d02add415d02069425c '
20230516@162111.8418 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='af4d02add415d02069425c '
20230516@162111.8511 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 bo.trab5 valor from bo where bo.bostamp='af4d02add415d02069425c '
20230516@162111.8600 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 bo.serie valor from bo where bo.bostamp='af4d02add415d02069425c '
20230516@162111.8702 m58nmfhou31h1cqrqjpibfqqkd Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut646395558364639f67be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230516@162111.8921 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 fno valor from wsft039data order by fno desc
20230516@162111.8935 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162111.8949 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230516@162111.8966 m58nmfhou31h1cqrqjpibfqqkd 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 ,encomenda ) values ('aut646395558364639f67be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',314,100923,0,'2023-05-16',39,'euro',0,0,2023 ,'20230516','1651',?,?,?,?,?)
20230516@162111.9559 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162111.9721 m58nmfhou31h1cqrqjpibfqqkd Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20230516@162112.1810 m58nmfhou31h1cqrqjpibfqqkd 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.1667.00.1'
20230516@162112.2000 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.2140 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162112.2360 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.2500 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162112.2540 m58nmfhou31h1cqrqjpibfqqkd Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2300059200a'
20230516@162112.2640 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162112.2740 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.2890 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162112.3120 m58nmfhou31h1cqrqjpibfqqkd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646395524564639f6806',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut646395558364639f67be' ,89.600000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230516@162112.5790 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.5960 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162112.6010 m58nmfhou31h1cqrqjpibfqqkd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646395524564639f6806','aut646395558364639f67be' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162112.6070 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.6210 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162112.6460 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.6610 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162112.6660 m58nmfhou31h1cqrqjpibfqqkd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162112.6770 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.6970 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162112.7230 m58nmfhou31h1cqrqjpibfqqkd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646394500664639f6810',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut646395558364639f67be' ,0,0 ,2,23.00,20000,?,?,?)
20230516@162112.1006 m58nmfhou31h1cqrqjpibfqqkd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.1022 m58nmfhou31h1cqrqjpibfqqkd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162112.1027 m58nmfhou31h1cqrqjpibfqqkd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646394500664639f6810','aut646395558364639f67be' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162112.1031 m58nmfhou31h1cqrqjpibfqqkd Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut646395558364639f67be','119230000271','wait',39,'ari17112337378,753000005')
20230516@162112.1048 m58nmfhou31h1cqrqjpibfqqkd Query : use flama_phc
20230516@162112.1051 m58nmfhou31h1cqrqjpibfqqkd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@162112.1062 m58nmfhou31h1cqrqjpibfqqkd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='430';
20230516@162112.1076 m58nmfhou31h1cqrqjpibfqqkd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='430';
20230516@162112.1087 m58nmfhou31h1cqrqjpibfqqkd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='430';
20230516@162112.1099 m58nmfhou31h1cqrqjpibfqqkd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='430';
20230516@162112.1552 bm4pgdk4f6o3m26vr4osca97ds Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230516@162112.1576 bm4pgdk4f6o3m26vr4osca97ds Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230516@162112.1593 bm4pgdk4f6o3m26vr4osca97ds Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='431';
20230516@162112.1634 bm4pgdk4f6o3m26vr4osca97ds Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='431';
20230516@162112.1646 bm4pgdk4f6o3m26vr4osca97ds Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='431';
20230516@162112.1657 bm4pgdk4f6o3m26vr4osca97ds Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='431';
20230516@162112.1668 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.1672 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230516@162112.1684 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.1688 bm4pgdk4f6o3m26vr4osca97ds Query : select no, estab,szadrsdesc from szadrs where u_coddest=2119
20230516@162112.1778 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20230516@162112.1936 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000272 and bi.ref ='324.1824.00.1' and bi.lordem =20000
20230516@162112.2287 bm4pgdk4f6o3m26vr4osca97ds Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655833,5540000-2 ' 
20230516@162112.2708 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20230516@162112.2719 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000272 and bi.ref ='324.1824.00.1' and bi.lordem =20000
20230516@162112.2849 bm4pgdk4f6o3m26vr4osca97ds Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655833,5540000-2 ' 
20230516@162112.2861 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20230516@162112.2871 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000272 and bi.ref ='324.1824.00.1' and bi.lordem =30000
20230516@162112.3304 bm4pgdk4f6o3m26vr4osca97ds Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655833,5840000-3 ' 
20230516@162112.3671 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20230516@162112.3683 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000272 and bi.ref ='324.1803.00.1' and bi.lordem =40000
20230516@162112.4058 bm4pgdk4f6o3m26vr4osca97ds Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655833,6070000-4 ' 
20230516@162112.4455 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20230516@162112.4467 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000272 and bi.ref ='324.1803.00.1' and bi.lordem =40000
20230516@162112.4479 bm4pgdk4f6o3m26vr4osca97ds Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655833,6070000-4 ' 
20230516@162112.4490 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.4494 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230516@162112.4507 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.4510 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 1 valor from td where td.ndoc = 39
20230516@162112.4520 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.4524 bm4pgdk4f6o3m26vr4osca97ds Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230516@162112.4534 bm4pgdk4f6o3m26vr4osca97ds 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
20230516@162112.4559 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.4562 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 ~inactivo valor from cl where no = '101631' and estab = 0 order by inactivo desc
20230516@162112.4684 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.4688 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230516@162112.4896 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.4902 bm4pgdk4f6o3m26vr4osca97ds Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230516@162112.4916 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.4919 bm4pgdk4f6o3m26vr4osca97ds Query : select szadrsstamp valor from szadrs where szadrsdesc='belmiro martins ribeiro,lda-1'
20230516@162112.4945 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.4948 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from td where ndoc = 39
20230516@162112.4958 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230516@162112.4970 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162112.5073 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230516@162112.5093 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162112.5109 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230516@162112.5136 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162112.5151 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230516@162112.5162 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162112.5203 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162112.5214 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162112.5229 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230516@162112.5241 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut646398185164639f687e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230516@162112.5414 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162112.5430 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230516@162112.5460 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='d84487a9541582475b0f8b '
20230516@162112.5562 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='d84487a9541582475b0f8b '
20230516@162112.5651 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='d84487a9541582475b0f8b '
20230516@162112.5737 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='d84487a9541582475b0f8b '
20230516@162112.5830 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bo.trab5 valor from bo where bo.bostamp='d84487a9541582475b0f8b '
20230516@162112.5923 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 bo.serie valor from bo where bo.bostamp='d84487a9541582475b0f8b '
20230516@162112.6008 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut646398185164639f687e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230516@162112.6238 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 fno valor from wsft039data order by fno desc
20230516@162112.6252 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162112.6267 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230516@162112.6285 bm4pgdk4f6o3m26vr4osca97ds 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 ,encomenda ) values ('aut646398185164639f687e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',315,101631,0,'2023-05-16',39,'euro',0,0,2023 ,'20230516','1651',?,?,?,?,?)
20230516@162112.6598 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.6602 bm4pgdk4f6o3m26vr4osca97ds Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20230516@162112.6616 bm4pgdk4f6o3m26vr4osca97ds 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.1824.00.1'
20230516@162112.6771 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.6784 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162112.6807 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.6819 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162112.6823 bm4pgdk4f6o3m26vr4osca97ds Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2200671200a'
20230516@162112.6834 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162112.6844 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.6856 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162112.6880 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646399743164639f68a7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut646398185164639f687e' ,54.800000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230516@162112.7145 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.7160 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162112.7164 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646399743164639f68a7','aut646398185164639f687e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162112.7169 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.7181 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162112.7204 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.7215 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162112.7219 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162112.7228 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.7240 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162112.7264 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646395532164639f68b0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut646398185164639f687e' ,0,0 ,2,23.00,20000,?,?,?)
20230516@162112.7521 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.7537 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162112.7541 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646395532164639f68b0','aut646398185164639f687e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162112.7545 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.7549 bm4pgdk4f6o3m26vr4osca97ds Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20230516@162112.7559 bm4pgdk4f6o3m26vr4osca97ds 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.1824.00.1'
20230516@162112.7569 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.7582 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162112.7605 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.7618 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162112.7622 bm4pgdk4f6o3m26vr4osca97ds Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2200671200a'
20230516@162112.7631 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162112.7641 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.7653 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162112.7676 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646399563864639f68ba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',17.000 ,'aut646398185164639f687e' ,54.800000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230516@162112.8010 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.8037 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162112.8055 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646399563864639f68ba','aut646398185164639f687e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162112.8060 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.8074 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162112.8110 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.8125 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162112.8129 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162112.8139 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.8317 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162112.8342 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646392608864639f68c6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut646398185164639f687e' ,0,0 ,2,23.00,50000,?,?,?)
20230516@162112.8625 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.8640 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162112.8733 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646392608864639f68c6','aut646398185164639f687e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162112.8739 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.8743 bm4pgdk4f6o3m26vr4osca97ds Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20230516@162112.8755 bm4pgdk4f6o3m26vr4osca97ds 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.1824.00.1'
20230516@162112.8766 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.8782 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162112.8806 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.8834 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162112.8839 bm4pgdk4f6o3m26vr4osca97ds Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2200671200a'
20230516@162112.8849 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162112.8858 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.8880 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162112.8901 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646398682664639f68d8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut646398185164639f687e' ,.000000,0 ,2,23.00,70000,?,?,?,?,?,?,?,?,?)
20230516@162112.9185 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.9200 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162112.9205 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646398682664639f68d8','aut646398185164639f687e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162112.9211 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.9240 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162112.9264 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.9275 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162112.9288 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162112.9297 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.9310 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162112.9352 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646394123264639f68e2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut646398185164639f687e' ,0,0 ,2,23.00,80000,?,?,?)
20230516@162112.9623 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.9638 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162112.9642 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646394123264639f68e2','aut646398185164639f687e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162112.9647 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162112.9650 bm4pgdk4f6o3m26vr4osca97ds Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20230516@162112.9701 bm4pgdk4f6o3m26vr4osca97ds 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.1803.00.1'
20230516@162112.9713 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162112.9726 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162112.9748 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162112.9760 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162112.9764 bm4pgdk4f6o3m26vr4osca97ds Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2200669200a'
20230516@162112.9774 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162112.9783 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162113.1700 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162113.3900 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646392829564639f68ee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut646398185164639f687e' ,71.300000,0 ,2,23.00,100000,?,?,?,?,?,?,?,?,?)
20230516@162113.3630 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162113.4030 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162113.4070 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646392829564639f68ee','aut646398185164639f687e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162113.4110 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162113.4140 bm4pgdk4f6o3m26vr4osca97ds Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20230516@162113.4240 bm4pgdk4f6o3m26vr4osca97ds 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.1803.00.1'
20230516@162113.4340 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162113.4450 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162113.4660 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162113.4770 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162113.4820 bm4pgdk4f6o3m26vr4osca97ds Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2200669200a'
20230516@162113.4910 bm4pgdk4f6o3m26vr4osca97ds Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162113.5060 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162113.5180 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162113.5390 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646396708664639f690c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut646398185164639f687e' ,71.300000,0 ,2,23.00,110000,?,?,?,?,?,?,?,?,?)
20230516@162113.7950 bm4pgdk4f6o3m26vr4osca97ds Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162113.8710 bm4pgdk4f6o3m26vr4osca97ds Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162113.8750 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646396708664639f690c','aut646398185164639f687e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162113.8800 bm4pgdk4f6o3m26vr4osca97ds Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut646398185164639f687e','119230000272','wait',39,'ari17112337378,753000005')
20230516@162113.8970 bm4pgdk4f6o3m26vr4osca97ds Query : use flama_phc
20230516@162113.9000 bm4pgdk4f6o3m26vr4osca97ds Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@162113.9110 bm4pgdk4f6o3m26vr4osca97ds Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='431';
20230516@162113.9250 bm4pgdk4f6o3m26vr4osca97ds Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='431';
20230516@162113.9360 bm4pgdk4f6o3m26vr4osca97ds Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='431';
20230516@162113.9530 bm4pgdk4f6o3m26vr4osca97ds Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='431';
20230516@162113.1286 67jnjudj9o52a5id6p6dps459l Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230516@162113.1302 67jnjudj9o52a5id6p6dps459l Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230516@162113.1318 67jnjudj9o52a5id6p6dps459l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='432';
20230516@162113.1360 67jnjudj9o52a5id6p6dps459l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='432';
20230516@162113.1372 67jnjudj9o52a5id6p6dps459l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='432';
20230516@162113.1383 67jnjudj9o52a5id6p6dps459l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='432';
20230516@162113.1394 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.1397 67jnjudj9o52a5id6p6dps459l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230516@162113.1410 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.1413 67jnjudj9o52a5id6p6dps459l Query : select no, estab,szadrsdesc from szadrs where u_coddest=339
20230516@162113.1491 67jnjudj9o52a5id6p6dps459l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.670.00.01'
20230516@162113.1503 67jnjudj9o52a5id6p6dps459l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000273 and bi.ref ='324.670.00.01' and bi.lordem =20000
20230516@162113.1855 67jnjudj9o52a5id6p6dps459l Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655844,1930000-2 ' 
20230516@162113.2188 67jnjudj9o52a5id6p6dps459l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.724.00.01'
20230516@162113.2394 67jnjudj9o52a5id6p6dps459l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000273 and bi.ref ='324.724.00.01' and bi.lordem =30000
20230516@162113.2739 67jnjudj9o52a5id6p6dps459l Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655844,2210000-3 ' 
20230516@162113.3088 67jnjudj9o52a5id6p6dps459l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4988.00.1'
20230516@162113.3247 67jnjudj9o52a5id6p6dps459l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000273 and bi.ref ='324.4988.00.1' and bi.lordem =40000
20230516@162113.3634 67jnjudj9o52a5id6p6dps459l Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051655844,2560000-4 ' 
20230516@162113.3993 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.3997 67jnjudj9o52a5id6p6dps459l Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230516@162113.4030 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.4034 67jnjudj9o52a5id6p6dps459l Query : select top 1 1 valor from td where td.ndoc = 39
20230516@162113.4043 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.4046 67jnjudj9o52a5id6p6dps459l Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230516@162113.4057 67jnjudj9o52a5id6p6dps459l 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
20230516@162113.4084 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.4088 67jnjudj9o52a5id6p6dps459l Query : select top 1 ~inactivo valor from cl where no = '102177' and estab = 0 order by inactivo desc
20230516@162113.4203 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.4208 67jnjudj9o52a5id6p6dps459l Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230516@162113.4218 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.4221 67jnjudj9o52a5id6p6dps459l Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230516@162113.4232 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.4234 67jnjudj9o52a5id6p6dps459l Query : select szadrsstamp valor from szadrs where szadrsdesc='electrÃo, lda.'
20230516@162113.4249 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.4252 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from td where ndoc = 39
20230516@162113.4261 67jnjudj9o52a5id6p6dps459l Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230516@162113.4272 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162113.4285 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230516@162113.4324 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162113.4338 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230516@162113.4376 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162113.4389 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230516@162113.4399 67jnjudj9o52a5id6p6dps459l Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162113.4440 67jnjudj9o52a5id6p6dps459l Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162113.4453 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162113.4465 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230516@162113.4476 67jnjudj9o52a5id6p6dps459l Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut646390572864639f696b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230516@162113.4683 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162113.4697 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230516@162113.4724 67jnjudj9o52a5id6p6dps459l Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='b94c6a8627ce1ef6006dfa '
20230516@162113.4822 67jnjudj9o52a5id6p6dps459l Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='b94c6a8627ce1ef6006dfa '
20230516@162113.4900 67jnjudj9o52a5id6p6dps459l Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='b94c6a8627ce1ef6006dfa '
20230516@162113.4984 67jnjudj9o52a5id6p6dps459l Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='b94c6a8627ce1ef6006dfa '
20230516@162113.5062 67jnjudj9o52a5id6p6dps459l Query : select top 1 bo.trab5 valor from bo where bo.bostamp='b94c6a8627ce1ef6006dfa '
20230516@162113.5226 67jnjudj9o52a5id6p6dps459l Query : select top 1 bo.serie valor from bo where bo.bostamp='b94c6a8627ce1ef6006dfa '
20230516@162113.5409 67jnjudj9o52a5id6p6dps459l Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut646390572864639f696b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230516@162113.5659 67jnjudj9o52a5id6p6dps459l Query : select top 1 fno valor from wsft039data order by fno desc
20230516@162113.5673 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162113.5688 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230516@162113.5705 67jnjudj9o52a5id6p6dps459l 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 ,encomenda ) values ('aut646390572864639f696b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',316,102177,0,'2023-05-16',39,'euro',0,0,2023 ,'20230516','1651',?,?,?,?,?)
20230516@162113.6004 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.6008 67jnjudj9o52a5id6p6dps459l Query : select st.usalote valor from st where st.ref = '324.670.00.01'
20230516@162113.6019 67jnjudj9o52a5id6p6dps459l 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.670.00.01'
20230516@162113.6030 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162113.6044 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162113.6065 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162113.6078 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162113.6082 67jnjudj9o52a5id6p6dps459l Query : select sestamp valor from se where ref ='324.670.00.01' and lote = 'r2200755200a'
20230516@162113.6092 67jnjudj9o52a5id6p6dps459l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162113.6101 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162113.6114 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162113.6138 67jnjudj9o52a5id6p6dps459l Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646396811964639f6994',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut646390572864639f696b' ,75.400000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230516@162113.6395 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162113.6410 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162113.6414 67jnjudj9o52a5id6p6dps459l Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646396811964639f6994','aut646390572864639f696b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162113.6418 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.6422 67jnjudj9o52a5id6p6dps459l Query : select st.usalote valor from st where st.ref = '324.724.00.01'
20230516@162113.6433 67jnjudj9o52a5id6p6dps459l 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.724.00.01'
20230516@162113.6595 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162113.6610 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162113.6633 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162113.6645 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162113.6650 67jnjudj9o52a5id6p6dps459l Query : select sestamp valor from se where ref ='324.724.00.01' and lote = '11/18'
20230516@162113.6680 67jnjudj9o52a5id6p6dps459l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162113.6690 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162113.6703 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162113.6727 67jnjudj9o52a5id6p6dps459l Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646391114164639f69a3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut646390572864639f696b' ,20.300000,0 ,2,23.00,20000,?,?,?,?,?,?,?,?,?)
20230516@162113.7021 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162113.7439 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162113.7683 67jnjudj9o52a5id6p6dps459l Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646391114164639f69a3','aut646390572864639f696b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162113.7727 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.8073 67jnjudj9o52a5id6p6dps459l Query : select st.usalote valor from st where st.ref = '324.4988.00.1'
20230516@162113.8087 67jnjudj9o52a5id6p6dps459l 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.4988.00.1'
20230516@162113.8246 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162113.8259 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162113.8282 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162113.8294 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162113.8298 67jnjudj9o52a5id6p6dps459l Query : select sestamp valor from se where ref ='324.4988.00.1' and lote = 'r2100743100a'
20230516@162113.8316 67jnjudj9o52a5id6p6dps459l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162113.8325 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162113.8336 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162113.8358 67jnjudj9o52a5id6p6dps459l Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646390913464639f69cb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut646390572864639f696b' ,26.100000,0 ,2,23.00,30000,?,?,?,?,?,?,?,?,?)
20230516@162113.8643 67jnjudj9o52a5id6p6dps459l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162113.8658 67jnjudj9o52a5id6p6dps459l Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162113.8665 67jnjudj9o52a5id6p6dps459l Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646390913464639f69cb','aut646390572864639f696b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162113.8670 67jnjudj9o52a5id6p6dps459l Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut646390572864639f696b','119230000273','wait',39,'ari17112337378,753000005')
20230516@162113.8686 67jnjudj9o52a5id6p6dps459l Query : use flama_phc
20230516@162113.8689 67jnjudj9o52a5id6p6dps459l Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@162113.8701 67jnjudj9o52a5id6p6dps459l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='432';
20230516@162113.8719 67jnjudj9o52a5id6p6dps459l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='432';
20230516@162113.8732 67jnjudj9o52a5id6p6dps459l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='432';
20230516@162113.8743 67jnjudj9o52a5id6p6dps459l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='432';
20230516@162113.9156 bqh10a8gf2o80tq68daev0fboa Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230516@162113.9169 bqh10a8gf2o80tq68daev0fboa Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230516@162113.9186 bqh10a8gf2o80tq68daev0fboa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='433';
20230516@162113.9224 bqh10a8gf2o80tq68daev0fboa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='433';
20230516@162113.9237 bqh10a8gf2o80tq68daev0fboa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='433';
20230516@162113.9248 bqh10a8gf2o80tq68daev0fboa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='433';
20230516@162113.9259 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162113.9263 bqh10a8gf2o80tq68daev0fboa Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230516@162113.9275 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162113.9278 bqh10a8gf2o80tq68daev0fboa Query : select no, estab,szadrsdesc from szadrs where u_coddest=770
20230516@162113.9352 bqh10a8gf2o80tq68daev0fboa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5347.00.1'
20230516@162113.9507 bqh10a8gf2o80tq68daev0fboa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000276 and bi.ref ='324.5347.00.1' and bi.lordem =20000
20230516@162113.9843 bqh10a8gf2o80tq68daev0fboa Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051656475,1970000-2 ' 
20230516@162114.1870 bqh10a8gf2o80tq68daev0fboa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5347.00.1'
20230516@162114.1980 bqh10a8gf2o80tq68daev0fboa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000276 and bi.ref ='324.5347.00.1' and bi.lordem =20000
20230516@162114.2100 bqh10a8gf2o80tq68daev0fboa Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051656475,1970000-2 ' 
20230516@162114.2200 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.2230 bqh10a8gf2o80tq68daev0fboa Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230516@162114.2360 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.2380 bqh10a8gf2o80tq68daev0fboa Query : select top 1 1 valor from td where td.ndoc = 39
20230516@162114.2480 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.2510 bqh10a8gf2o80tq68daev0fboa Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230516@162114.2610 bqh10a8gf2o80tq68daev0fboa 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
20230516@162114.2750 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.2800 bqh10a8gf2o80tq68daev0fboa Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20230516@162114.2900 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.2930 bqh10a8gf2o80tq68daev0fboa Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230516@162114.3040 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.3070 bqh10a8gf2o80tq68daev0fboa Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230516@162114.3220 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.3250 bqh10a8gf2o80tq68daev0fboa Query : select szadrsstamp valor from szadrs where szadrsdesc='worten-equipamentos para o lar,sa.- azambuja'
20230516@162114.3380 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.3410 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from td where ndoc = 39
20230516@162114.3500 bqh10a8gf2o80tq68daev0fboa Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230516@162114.3610 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162114.3750 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230516@162114.3910 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162114.4040 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230516@162114.4300 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162114.4430 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230516@162114.4520 bqh10a8gf2o80tq68daev0fboa Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162114.4930 bqh10a8gf2o80tq68daev0fboa Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@162114.5030 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@162114.5150 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230516@162114.5240 bqh10a8gf2o80tq68daev0fboa Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut646392022964639f6a0b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230516@162114.7000 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@162114.7160 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230516@162114.7430 bqh10a8gf2o80tq68daev0fboa Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23051651000,961000001 '
20230516@162114.8520 bqh10a8gf2o80tq68daev0fboa Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23051651000,961000001 '
20230516@162114.9910 bqh10a8gf2o80tq68daev0fboa Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23051651000,961000001 '
20230516@162114.1091 bqh10a8gf2o80tq68daev0fboa Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23051651000,961000001 '
20230516@162114.1177 bqh10a8gf2o80tq68daev0fboa Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23051651000,961000001 '
20230516@162114.1264 bqh10a8gf2o80tq68daev0fboa Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23051651000,961000001 '
20230516@162114.1349 bqh10a8gf2o80tq68daev0fboa Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut646392022964639f6a0b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230516@162114.1568 bqh10a8gf2o80tq68daev0fboa Query : select top 1 fno valor from wsft039data order by fno desc
20230516@162114.1582 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@162114.1595 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230516@162114.1612 bqh10a8gf2o80tq68daev0fboa 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 ,encomenda ) values ('aut646392022964639f6a0b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',317,100810,0,'2023-05-16',39,'euro',0,0,2023 ,'20230516','1651',?,?,?,?,?)
20230516@162114.1895 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.1900 bqh10a8gf2o80tq68daev0fboa Query : select st.usalote valor from st where st.ref = '324.5347.00.1'
20230516@162114.1912 bqh10a8gf2o80tq68daev0fboa 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.5347.00.1'
20230516@162114.2062 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162114.2075 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162114.2096 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162114.2108 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162114.2112 bqh10a8gf2o80tq68daev0fboa Query : select sestamp valor from se where ref ='324.5347.00.1' and lote = 'r2200658100a'
20230516@162114.2122 bqh10a8gf2o80tq68daev0fboa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162114.2131 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162114.2142 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162114.2164 bqh10a8gf2o80tq68daev0fboa Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646395671864639f6a34',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut646392022964639f6a0b' ,23.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230516@162114.2406 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162114.2420 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162114.2425 bqh10a8gf2o80tq68daev0fboa Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646395671864639f6a34','aut646392022964639f6a0b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162114.2430 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162114.2442 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162114.2464 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162114.2475 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162114.2479 bqh10a8gf2o80tq68daev0fboa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162114.2488 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162114.2500 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162114.2522 bqh10a8gf2o80tq68daev0fboa Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646398515864639f6a3c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut646392022964639f6a0b' ,0,0 ,2,23.00,20000,?,?,?)
20230516@162114.2791 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162114.2807 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162114.2811 bqh10a8gf2o80tq68daev0fboa Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646398515864639f6a3c','aut646392022964639f6a0b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162114.2815 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.2819 bqh10a8gf2o80tq68daev0fboa Query : select st.usalote valor from st where st.ref = '324.5347.00.1'
20230516@162114.2829 bqh10a8gf2o80tq68daev0fboa 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.5347.00.1'
20230516@162114.2840 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162114.2853 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162114.2875 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162114.2888 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162114.2892 bqh10a8gf2o80tq68daev0fboa Query : select sestamp valor from se where ref ='324.5347.00.1' and lote = 'r2200658100a'
20230516@162114.2902 bqh10a8gf2o80tq68daev0fboa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162114.2912 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162114.2925 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162114.2949 bqh10a8gf2o80tq68daev0fboa Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut646398968764639f6a47',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',78.000 ,'aut646392022964639f6a0b' ,23.000000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230516@162114.3201 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162114.3216 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162114.3220 bqh10a8gf2o80tq68daev0fboa Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646398968764639f6a47','aut646392022964639f6a0b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162114.3225 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162114.3239 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@162114.3262 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162114.3273 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@162114.3277 bqh10a8gf2o80tq68daev0fboa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@162114.3287 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@162114.3299 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@162114.3321 bqh10a8gf2o80tq68daev0fboa Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646396276664639f6a50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut646392022964639f6a0b' ,0,0 ,2,23.00,50000,?,?,?)
20230516@162114.3573 bqh10a8gf2o80tq68daev0fboa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@162114.3589 bqh10a8gf2o80tq68daev0fboa Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@162114.3595 bqh10a8gf2o80tq68daev0fboa Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646396276664639f6a50','aut646392022964639f6a0b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@162114.3600 bqh10a8gf2o80tq68daev0fboa Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut646392022964639f6a0b','119230000276','wait',39,'ari17112337378,753000005')
20230516@162114.3617 bqh10a8gf2o80tq68daev0fboa Query : use flama_phc
20230516@162114.3621 bqh10a8gf2o80tq68daev0fboa Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@162114.3634 bqh10a8gf2o80tq68daev0fboa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='433';
20230516@162114.3653 bqh10a8gf2o80tq68daev0fboa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='433';
20230516@162114.3665 bqh10a8gf2o80tq68daev0fboa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='433';
20230516@162114.3677 bqh10a8gf2o80tq68daev0fboa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='433';
20230516@163009.3472 d4ln9kghca958vv8h14cnd5og7 Query : use flama_phc
20230516@163009.3477 d4ln9kghca958vv8h14cnd5og7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@163009.3676 d4ln9kghca958vv8h14cnd5og7 Query : use flama_phc
20230516@163009.3694 d4ln9kghca958vv8h14cnd5og7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@170730.5861 70hv0dsasjhu6olg9ejdmkf8ji Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230516@170730.5878 70hv0dsasjhu6olg9ejdmkf8ji Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230516@170730.5899 70hv0dsasjhu6olg9ejdmkf8ji Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='434';
20230516@170730.6098 70hv0dsasjhu6olg9ejdmkf8ji Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='434';
20230516@170730.6115 70hv0dsasjhu6olg9ejdmkf8ji Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='434';
20230516@170730.6130 70hv0dsasjhu6olg9ejdmkf8ji Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='434';
20230516@170730.6143 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.6146 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230516@170730.6159 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.6162 70hv0dsasjhu6olg9ejdmkf8ji Query : select no, estab,szadrsdesc from szadrs where u_coddest=2214
20230516@170730.6237 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8152.00.1'
20230516@170730.6382 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000277 and bi.ref ='327.8152.00.1' and bi.lordem =20000
20230516@170730.6707 70hv0dsasjhu6olg9ejdmkf8ji Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051657436,0950000-2 ' 
20230516@170730.7023 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.7027 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230516@170730.7043 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.7046 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 1 valor from td where td.ndoc = 39
20230516@170730.7056 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.7059 70hv0dsasjhu6olg9ejdmkf8ji Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230516@170730.7070 70hv0dsasjhu6olg9ejdmkf8ji 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
20230516@170730.7085 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.7087 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 ~inactivo valor from cl where no = '12406' and estab = 0 order by inactivo desc
20230516@170730.7190 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.7193 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230516@170730.7203 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.7207 70hv0dsasjhu6olg9ejdmkf8ji Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230516@170730.7218 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.7222 70hv0dsasjhu6olg9ejdmkf8ji Query : select szadrsstamp valor from szadrs where szadrsdesc='ferrageira sul ferragens ferramentas cutelarias drogari'
20230516@170730.7235 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.7238 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from td where ndoc = 39
20230516@170730.7248 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230516@170730.7260 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@170730.7275 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230516@170730.7294 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@170730.7310 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230516@170730.7342 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@170730.7355 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230516@170730.7365 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@170730.7408 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230516@170730.7420 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230516@170730.7434 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230516@170730.7446 70hv0dsasjhu6olg9ejdmkf8ji Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6463a943756463aa42b3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230516@170730.7606 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230516@170730.7623 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230516@170730.7655 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='014e2f918debd2201becda '
20230516@170730.7752 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='014e2f918debd2201becda '
20230516@170730.7828 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='014e2f918debd2201becda '
20230516@170730.8809 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='014e2f918debd2201becda '
20230516@170730.8914 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 bo.trab5 valor from bo where bo.bostamp='014e2f918debd2201becda '
20230516@170730.8991 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 bo.serie valor from bo where bo.bostamp='014e2f918debd2201becda '
20230516@170730.9075 70hv0dsasjhu6olg9ejdmkf8ji Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6463a943756463aa42b3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230516@170730.9295 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 fno valor from wsft039data order by fno desc
20230516@170730.9312 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230516@170730.9328 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230516@170730.9351 70hv0dsasjhu6olg9ejdmkf8ji 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 ,encomenda ) values ('aut6463a943756463aa42b3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',318,12406,0,'2023-05-16',39,'euro',0,0,2023 ,'20230516','1737',?,?,?,?,?)
20230516@170730.9662 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170730.9667 70hv0dsasjhu6olg9ejdmkf8ji Query : select st.usalote valor from st where st.ref = '327.8152.00.1'
20230516@170730.9680 70hv0dsasjhu6olg9ejdmkf8ji 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 = '327.8152.00.1'
20230516@170730.9828 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@170730.9842 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@170730.9869 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@170730.9885 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@170730.9890 70hv0dsasjhu6olg9ejdmkf8ji Query : select sestamp valor from se where ref ='327.8152.00.1' and lote = 'r2200712200a'
20230516@170730.9903 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@170730.9915 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@170730.9929 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@170730.9955 70hv0dsasjhu6olg9ejdmkf8ji Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6463a211626463aa42f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6463a943756463aa42b3' ,192.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230516@170731.2070 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@170731.2220 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@170731.2280 70hv0dsasjhu6olg9ejdmkf8ji Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6463a211626463aa42f2','aut6463a943756463aa42b3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@170731.2340 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@170731.2480 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230516@170731.2750 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@170731.2880 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230516@170731.2930 70hv0dsasjhu6olg9ejdmkf8ji Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230516@170731.3050 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230516@170731.3180 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230516@170731.3460 70hv0dsasjhu6olg9ejdmkf8ji Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6463a881496463aa4307',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6463a943756463aa42b3' ,0,0 ,2,23.00,20000,?,?,?)
20230516@170731.5920 70hv0dsasjhu6olg9ejdmkf8ji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230516@170731.6080 70hv0dsasjhu6olg9ejdmkf8ji Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230516@170731.6130 70hv0dsasjhu6olg9ejdmkf8ji Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6463a881496463aa4307','aut6463a943756463aa42b3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230516@170731.6180 70hv0dsasjhu6olg9ejdmkf8ji Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6463a943756463aa42b3','119230000277','wait',39,'ari17112337378,753000005')
20230516@170731.6360 70hv0dsasjhu6olg9ejdmkf8ji Query : use flama_phc
20230516@170731.6390 70hv0dsasjhu6olg9ejdmkf8ji Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@170731.6510 70hv0dsasjhu6olg9ejdmkf8ji Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='434';
20230516@170731.6660 70hv0dsasjhu6olg9ejdmkf8ji Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='434';
20230516@170731.6810 70hv0dsasjhu6olg9ejdmkf8ji Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='434';
20230516@170731.6930 70hv0dsasjhu6olg9ejdmkf8ji Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='434';
20230516@173008.6401 ifofmfe81k9coetehtcmv2p6gt Query : use flama_phc
20230516@173008.6418 ifofmfe81k9coetehtcmv2p6gt Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@173008.6610 ifofmfe81k9coetehtcmv2p6gt Query : use flama_phc
20230516@173008.6832 ifofmfe81k9coetehtcmv2p6gt Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@183007.8257 ap7q2c0m032jb5pob0sf99pk1e Query : use flama_phc
20230516@183007.8261 ap7q2c0m032jb5pob0sf99pk1e Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@183007.8291 ap7q2c0m032jb5pob0sf99pk1e Query : use flama_phc
20230516@183007.8293 ap7q2c0m032jb5pob0sf99pk1e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@193007.3784 map38li4fp34o1b1js4pl3nn3a Query : use flama_phc
20230516@193007.3790 map38li4fp34o1b1js4pl3nn3a Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@193007.3824 map38li4fp34o1b1js4pl3nn3a Query : use flama_phc
20230516@193007.3827 map38li4fp34o1b1js4pl3nn3a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@203007.2128 mds8705iqqshj4a3sta1ctu5qa Query : use flama_phc
20230516@203007.2134 mds8705iqqshj4a3sta1ctu5qa Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@203007.2192 mds8705iqqshj4a3sta1ctu5qa Query : use flama_phc
20230516@203007.2195 mds8705iqqshj4a3sta1ctu5qa Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@213007.5006 khqqn012923a7rneb9jsot739b Query : use flama_phc
20230516@213007.5011 khqqn012923a7rneb9jsot739b Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@213007.5027 khqqn012923a7rneb9jsot739b Query : use flama_phc
20230516@213007.5030 khqqn012923a7rneb9jsot739b Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@223007.3366 6r6e12vpv8s6hu27n2rbgt7glv Query : use flama_phc
20230516@223007.3371 6r6e12vpv8s6hu27n2rbgt7glv Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@223007.3391 6r6e12vpv8s6hu27n2rbgt7glv Query : use flama_phc
20230516@223007.3394 6r6e12vpv8s6hu27n2rbgt7glv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@230011.1860 kbsb5vom3q3ja1d2no4de78vt3 Query : use flama_phc
20230516@230011.1864 kbsb5vom3q3ja1d2no4de78vt3 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@230011.1879 kbsb5vom3q3ja1d2no4de78vt3 Query : use flama_phc
20230516@230011.1882 kbsb5vom3q3ja1d2no4de78vt3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@230013.3319 op9k590v3untsq30kcl6mhnokl Query : use flama_phc
20230516@230013.3324 op9k590v3untsq30kcl6mhnokl Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@230013.3341 op9k590v3untsq30kcl6mhnokl Query : use flama_phc
20230516@230013.3344 op9k590v3untsq30kcl6mhnokl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230516@233008.7888 9pb6fulsoluihvhekil4qrq1lm Query : use flama_phc
20230516@233008.7893 9pb6fulsoluihvhekil4qrq1lm Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230516@233008.7909 9pb6fulsoluihvhekil4qrq1lm Query : use flama_phc
20230516@233008.7911 9pb6fulsoluihvhekil4qrq1lm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230517@070007.7243 0fseb6q31ermnuusm9j49q3okm Query : use flama_phc
20230517@070007.7287 0fseb6q31ermnuusm9j49q3okm Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230517@070007.7575 0fseb6q31ermnuusm9j49q3okm Query : use flama_phc
20230517@070007.7614 0fseb6q31ermnuusm9j49q3okm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230517@073025.1922 6j33uc6ha6t08a5nkrm2pa4l76 Query : use flama_phc
20230517@073025.1927 6j33uc6ha6t08a5nkrm2pa4l76 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230517@073025.2301 6j33uc6ha6t08a5nkrm2pa4l76 Query : use flama_phc
20230517@073025.2340 6j33uc6ha6t08a5nkrm2pa4l76 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230517@080006.3599 24cg24q0gbrvjsakfje4mad0rd Query : use flama_phc
20230517@080006.3606 24cg24q0gbrvjsakfje4mad0rd Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230517@080006.3878 24cg24q0gbrvjsakfje4mad0rd Query : use flama_phc
20230517@080006.3917 24cg24q0gbrvjsakfje4mad0rd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230517@083006.8134 g5g5sfcqgia25fhhsaarb38t35 Query : use flama_phc
20230517@083006.8140 g5g5sfcqgia25fhhsaarb38t35 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230517@083006.8232 g5g5sfcqgia25fhhsaarb38t35 Query : use flama_phc
20230517@083006.8235 g5g5sfcqgia25fhhsaarb38t35 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230517@083224.3936 3d9b359v0fgidnflqgcb1rlnrj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230517@083224.4073 3d9b359v0fgidnflqgcb1rlnrj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230517@083224.4129 3d9b359v0fgidnflqgcb1rlnrj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='435';
20230517@083224.4410 3d9b359v0fgidnflqgcb1rlnrj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='435';
20230517@083224.4443 3d9b359v0fgidnflqgcb1rlnrj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='435';
20230517@083224.4663 3d9b359v0fgidnflqgcb1rlnrj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='435';
