20230510@122836.3783 fa77mbcerb7kt51snntm46t7ai Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='268';
20230510@122836.3795 fa77mbcerb7kt51snntm46t7ai Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='268';
20230510@122836.4156 om0l2thbgoaueotu44f7r5f0rg Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230510@122836.4169 om0l2thbgoaueotu44f7r5f0rg Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230510@122836.4185 om0l2thbgoaueotu44f7r5f0rg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='269';
20230510@122836.4229 om0l2thbgoaueotu44f7r5f0rg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='269';
20230510@122836.4243 om0l2thbgoaueotu44f7r5f0rg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='269';
20230510@122836.4254 om0l2thbgoaueotu44f7r5f0rg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='269';
20230510@122836.4265 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.4268 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230510@122836.4281 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.4288 om0l2thbgoaueotu44f7r5f0rg Query : select no, estab,szadrsdesc from szadrs where u_coddest=3674
20230510@122836.4359 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20230510@122836.4501 om0l2thbgoaueotu44f7r5f0rg 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 = 0000133 and bi.ref ='324.5343.00.1' and bi.lordem =20000
20230510@122836.4822 om0l2thbgoaueotu44f7r5f0rg Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043147,4130000-2 ' 
20230510@122836.5143 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20230510@122836.5155 om0l2thbgoaueotu44f7r5f0rg 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 = 0000133 and bi.ref ='324.5343.00.1' and bi.lordem =20000
20230510@122836.5167 om0l2thbgoaueotu44f7r5f0rg Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043147,4130000-2 ' 
20230510@122836.5178 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.5181 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230510@122836.5198 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.5201 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 1 valor from td where td.ndoc = 39
20230510@122836.5210 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.5213 om0l2thbgoaueotu44f7r5f0rg Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230510@122836.5224 om0l2thbgoaueotu44f7r5f0rg 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
20230510@122836.5241 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.5245 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 ~inactivo valor from cl where no = '199524' and estab = 0 order by inactivo desc
20230510@122836.5350 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.5354 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230510@122836.5364 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.5367 om0l2thbgoaueotu44f7r5f0rg Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230510@122836.5381 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.5384 om0l2thbgoaueotu44f7r5f0rg Query : select szadrsstamp valor from szadrs where szadrsdesc='worten-equipamentos para o lar,sa.- az'
20230510@122836.5396 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.5399 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from td where ndoc = 39
20230510@122836.5408 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230510@122836.5419 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122836.5433 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230510@122836.5450 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122836.5463 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230510@122836.5467 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122836.5480 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230510@122836.5491 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122836.5534 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122836.5545 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122836.5558 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230510@122836.5570 om0l2thbgoaueotu44f7r5f0rg Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645b746518645b7fe486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230510@122836.5911 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122836.6781 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230510@122836.6787 om0l2thbgoaueotu44f7r5f0rg Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b746518645b7fe486',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122836.6794 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 fno valor from wsft039data order by fno desc
20230510@122836.6808 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122836.6823 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230510@122836.6844 om0l2thbgoaueotu44f7r5f0rg 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 ('aut645b746518645b7fe486',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',169,199524,0,'2023-05-10',39,'euro',0,0,2023 ,'20230510','1258',?,?,?,?,?)
20230510@122836.7139 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.7146 om0l2thbgoaueotu44f7r5f0rg Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20230510@122836.7160 om0l2thbgoaueotu44f7r5f0rg 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.5343.00.1'
20230510@122836.7301 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122836.7315 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122836.7341 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122836.7354 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122836.7358 om0l2thbgoaueotu44f7r5f0rg Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2100244100a'
20230510@122836.7376 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122836.7387 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122836.7400 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122836.7424 om0l2thbgoaueotu44f7r5f0rg 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 ('aut645b709635645b7fe4b4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut645b746518645b7fe486' ,19.600000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230510@122836.7670 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122836.7687 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122836.7692 om0l2thbgoaueotu44f7r5f0rg Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b709635645b7fe4b4','aut645b746518645b7fe486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122836.7697 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122836.7711 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122836.7737 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122836.7750 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122836.7755 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122836.7765 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122836.7777 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122836.7802 om0l2thbgoaueotu44f7r5f0rg Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645b792632645b7fe4bd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645b746518645b7fe486' ,0,0 ,2,23.00,20000,?,?,?)
20230510@122836.8071 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122836.8089 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122836.8095 om0l2thbgoaueotu44f7r5f0rg Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b792632645b7fe4bd','aut645b746518645b7fe486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122836.8143 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.8160 om0l2thbgoaueotu44f7r5f0rg Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20230510@122836.8398 om0l2thbgoaueotu44f7r5f0rg 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.5343.00.1'
20230510@122836.8411 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122836.8427 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122836.8451 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122836.8465 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122836.8470 om0l2thbgoaueotu44f7r5f0rg Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2100244100a'
20230510@122836.8481 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122836.8493 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122836.8508 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122836.8534 om0l2thbgoaueotu44f7r5f0rg 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 ('aut645b734540645b7fe4cf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',78.000 ,'aut645b746518645b7fe486' ,19.600000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230510@122836.8786 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122836.8803 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122836.8808 om0l2thbgoaueotu44f7r5f0rg Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b734540645b7fe4cf','aut645b746518645b7fe486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122836.8814 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122836.8827 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122836.8853 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122836.8865 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122836.8869 om0l2thbgoaueotu44f7r5f0rg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122836.8880 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122836.8892 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122836.8919 om0l2thbgoaueotu44f7r5f0rg Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645b742828645b7fe4d8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645b746518645b7fe486' ,0,0 ,2,23.00,50000,?,?,?)
20230510@122836.9377 om0l2thbgoaueotu44f7r5f0rg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122836.9393 om0l2thbgoaueotu44f7r5f0rg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122836.9399 om0l2thbgoaueotu44f7r5f0rg Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b742828645b7fe4d8','aut645b746518645b7fe486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122836.9404 om0l2thbgoaueotu44f7r5f0rg Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645b746518645b7fe486','119230000133','wait',39,'ari17112337378,753000005')
20230510@122836.9421 om0l2thbgoaueotu44f7r5f0rg Query : use flama_phc
20230510@122836.9425 om0l2thbgoaueotu44f7r5f0rg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230510@122836.9436 om0l2thbgoaueotu44f7r5f0rg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='269';
20230510@122836.9450 om0l2thbgoaueotu44f7r5f0rg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='269';
20230510@122836.9462 om0l2thbgoaueotu44f7r5f0rg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='269';
20230510@122836.9473 om0l2thbgoaueotu44f7r5f0rg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='269';
20230510@122836.9794 nqubkrtv7c4t6jck74t88q0h4u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230510@122836.9876 nqubkrtv7c4t6jck74t88q0h4u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230510@122837.8800 nqubkrtv7c4t6jck74t88q0h4u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='270';
20230510@122837.1750 nqubkrtv7c4t6jck74t88q0h4u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='270';
20230510@122837.1890 nqubkrtv7c4t6jck74t88q0h4u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='270';
20230510@122837.2010 nqubkrtv7c4t6jck74t88q0h4u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='270';
20230510@122837.2130 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.2170 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230510@122837.2320 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.2350 nqubkrtv7c4t6jck74t88q0h4u Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20230510@122837.3080 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1221.00.1'
20230510@122837.3190 nqubkrtv7c4t6jck74t88q0h4u 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 = 0000134 and bi.ref ='324.1221.00.1' and bi.lordem =20000
20230510@122837.6760 nqubkrtv7c4t6jck74t88q0h4u Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043197,3130000-2 ' 
20230510@122837.1001 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.1006 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230510@122837.1024 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.1028 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 1 valor from td where td.ndoc = 39
20230510@122837.1041 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.1044 nqubkrtv7c4t6jck74t88q0h4u Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230510@122837.1056 nqubkrtv7c4t6jck74t88q0h4u 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
20230510@122837.1071 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.1074 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20230510@122837.1181 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.1184 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230510@122837.1195 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.1199 nqubkrtv7c4t6jck74t88q0h4u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230510@122837.1210 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.1213 nqubkrtv7c4t6jck74t88q0h4u Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20230510@122837.1226 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.1230 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from td where ndoc = 39
20230510@122837.1240 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230510@122837.1251 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122837.1265 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230510@122837.1283 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122837.1296 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230510@122837.1300 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122837.1312 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230510@122837.1322 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122837.1362 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122837.1373 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122837.1386 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230510@122837.1396 nqubkrtv7c4t6jck74t88q0h4u Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645b726532645b7fe520' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230510@122837.1552 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122837.1566 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230510@122837.1571 nqubkrtv7c4t6jck74t88q0h4u Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b726532645b7fe520',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122837.1583 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 fno valor from wsft039data order by fno desc
20230510@122837.1595 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122837.1610 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230510@122837.1630 nqubkrtv7c4t6jck74t88q0h4u 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 ('aut645b726532645b7fe520',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',170,100810,0,'2023-05-10',39,'euro',0,0,2023 ,'20230510','1258',?,?,?,?,?)
20230510@122837.1893 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.1898 nqubkrtv7c4t6jck74t88q0h4u Query : select st.usalote valor from st where st.ref = '324.1221.00.1'
20230510@122837.1910 nqubkrtv7c4t6jck74t88q0h4u 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.1221.00.1'
20230510@122837.1921 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.1939 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122837.2233 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.2254 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122837.2260 nqubkrtv7c4t6jck74t88q0h4u Query : select sestamp valor from se where ref ='324.1221.00.1' and lote = 'r2101229200a'
20230510@122837.2271 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122837.2284 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.2299 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122837.2329 nqubkrtv7c4t6jck74t88q0h4u 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 ('aut645b716099645b7fe537',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut645b726532645b7fe520' ,91.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230510@122837.2716 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.2747 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122837.2751 nqubkrtv7c4t6jck74t88q0h4u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b716099645b7fe537','aut645b726532645b7fe520' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122837.2757 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.2770 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122837.2816 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.2829 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122837.2834 nqubkrtv7c4t6jck74t88q0h4u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122837.2847 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.2862 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122837.2887 nqubkrtv7c4t6jck74t88q0h4u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645b755020645b7fe545',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645b726532645b7fe520' ,0,0 ,2,23.00,20000,?,?,?)
20230510@122837.3160 nqubkrtv7c4t6jck74t88q0h4u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.3176 nqubkrtv7c4t6jck74t88q0h4u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122837.3181 nqubkrtv7c4t6jck74t88q0h4u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b755020645b7fe545','aut645b726532645b7fe520' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122837.3186 nqubkrtv7c4t6jck74t88q0h4u Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645b726532645b7fe520','119230000134','wait',39,'ari17112337378,753000005')
20230510@122837.3203 nqubkrtv7c4t6jck74t88q0h4u Query : use flama_phc
20230510@122837.3206 nqubkrtv7c4t6jck74t88q0h4u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230510@122837.3218 nqubkrtv7c4t6jck74t88q0h4u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='270';
20230510@122837.3231 nqubkrtv7c4t6jck74t88q0h4u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='270';
20230510@122837.3243 nqubkrtv7c4t6jck74t88q0h4u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='270';
20230510@122837.3254 nqubkrtv7c4t6jck74t88q0h4u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='270';
20230510@122837.3573 bkupamd523v73cd2hnn3lhs3s9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230510@122837.3590 bkupamd523v73cd2hnn3lhs3s9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230510@122837.3605 bkupamd523v73cd2hnn3lhs3s9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='271';
20230510@122837.3645 bkupamd523v73cd2hnn3lhs3s9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='271';
20230510@122837.3657 bkupamd523v73cd2hnn3lhs3s9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='271';
20230510@122837.3669 bkupamd523v73cd2hnn3lhs3s9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='271';
20230510@122837.3680 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.3684 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230510@122837.3702 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.3706 bkupamd523v73cd2hnn3lhs3s9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=5546
20230510@122837.3963 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4020.00.1'
20230510@122837.3975 bkupamd523v73cd2hnn3lhs3s9 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 = 0000135 and bi.ref ='304.4020.00.1' and bi.lordem =20000
20230510@122837.4315 bkupamd523v73cd2hnn3lhs3s9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043198,7330000-2 ' 
20230510@122837.4639 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4020.00.1'
20230510@122837.4651 bkupamd523v73cd2hnn3lhs3s9 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 = 0000135 and bi.ref ='304.4020.00.1' and bi.lordem =20000
20230510@122837.4664 bkupamd523v73cd2hnn3lhs3s9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043198,7330000-2 ' 
20230510@122837.4675 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4020.00.1'
20230510@122837.4687 bkupamd523v73cd2hnn3lhs3s9 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 = 0000135 and bi.ref ='304.4020.00.1' and bi.lordem =20000
20230510@122837.4700 bkupamd523v73cd2hnn3lhs3s9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043198,7330000-2 ' 
20230510@122837.4711 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4020.00.1'
20230510@122837.4721 bkupamd523v73cd2hnn3lhs3s9 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 = 0000135 and bi.ref ='304.4020.00.1' and bi.lordem =20000
20230510@122837.4734 bkupamd523v73cd2hnn3lhs3s9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043198,7330000-2 ' 
20230510@122837.4745 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4020.00.1'
20230510@122837.4756 bkupamd523v73cd2hnn3lhs3s9 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 = 0000135 and bi.ref ='304.4020.00.1' and bi.lordem =20000
20230510@122837.4767 bkupamd523v73cd2hnn3lhs3s9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043198,7330000-2 ' 
20230510@122837.4779 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.4782 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230510@122837.4798 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.4801 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 1 valor from td where td.ndoc = 39
20230510@122837.4812 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.4815 bkupamd523v73cd2hnn3lhs3s9 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230510@122837.4826 bkupamd523v73cd2hnn3lhs3s9 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
20230510@122837.4857 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.4860 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 ~inactivo valor from cl where no = '199506' and estab = 0 order by inactivo desc
20230510@122837.4870 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.4873 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230510@122837.4885 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.4888 bkupamd523v73cd2hnn3lhs3s9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230510@122837.4899 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.4902 bkupamd523v73cd2hnn3lhs3s9 Query : select szadrsstamp valor from szadrs where szadrsdesc='199506 - itmp alimentar, s.a.'
20230510@122837.4917 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.4920 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from td where ndoc = 39
20230510@122837.4931 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230510@122837.4943 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122837.4958 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230510@122837.4976 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122837.4990 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230510@122837.4995 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122837.5008 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230510@122837.5040 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122837.5096 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122837.5106 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122837.5120 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230510@122837.5131 bkupamd523v73cd2hnn3lhs3s9 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645b753042645b7fe57b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230510@122837.5315 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122837.5332 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230510@122837.5337 bkupamd523v73cd2hnn3lhs3s9 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b753042645b7fe57b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122837.5342 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 fno valor from wsft039data order by fno desc
20230510@122837.5359 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122837.5373 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230510@122837.5392 bkupamd523v73cd2hnn3lhs3s9 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 ('aut645b753042645b7fe57b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',171,199506,0,'2023-05-10',39,'euro',0,0,2023 ,'20230510','1258',?,?,?,?,?)
20230510@122837.5655 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.5673 bkupamd523v73cd2hnn3lhs3s9 Query : select st.usalote valor from st where st.ref = '304.4020.00.1'
20230510@122837.5685 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4020.00.1'
20230510@122837.5698 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.5711 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122837.5735 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.5748 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122837.5753 bkupamd523v73cd2hnn3lhs3s9 Query : select sestamp valor from se where ref ='304.4020.00.1' and lote = '221640'
20230510@122837.5763 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122837.5773 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.5787 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122837.5812 bkupamd523v73cd2hnn3lhs3s9 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 ('aut645b774328645b7fe58c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut645b753042645b7fe57b' ,21.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230510@122837.6096 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.7007 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122837.7013 bkupamd523v73cd2hnn3lhs3s9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b774328645b7fe58c','aut645b753042645b7fe57b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122837.7018 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.7022 bkupamd523v73cd2hnn3lhs3s9 Query : select st.usalote valor from st where st.ref = '304.4020.00.1'
20230510@122837.7035 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4020.00.1'
20230510@122837.7047 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.7080 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122837.7106 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.7119 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122837.7125 bkupamd523v73cd2hnn3lhs3s9 Query : select sestamp valor from se where ref ='304.4020.00.1' and lote = '230335'
20230510@122837.7137 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122837.7151 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.7166 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122837.7194 bkupamd523v73cd2hnn3lhs3s9 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 ('aut645b788775645b7fe5ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',120.000 ,'aut645b753042645b7fe57b' ,21.000000,0 ,2,23.00,20000,?,?,?,?,?,?,?,?,?)
20230510@122837.7435 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.7451 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122837.7455 bkupamd523v73cd2hnn3lhs3s9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b788775645b7fe5ae','aut645b753042645b7fe57b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122837.7459 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.7462 bkupamd523v73cd2hnn3lhs3s9 Query : select st.usalote valor from st where st.ref = '304.4020.00.1'
20230510@122837.7473 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4020.00.1'
20230510@122837.7484 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.7497 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122837.7520 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.7532 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122837.7537 bkupamd523v73cd2hnn3lhs3s9 Query : select sestamp valor from se where ref ='304.4020.00.1' and lote = '230335'
20230510@122837.7547 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122837.7557 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.7568 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122837.7615 bkupamd523v73cd2hnn3lhs3s9 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 ('aut645b799781645b7fe5b8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',120.000 ,'aut645b753042645b7fe57b' ,21.000000,0 ,2,23.00,30000,?,?,?,?,?,?,?,?,?)
20230510@122837.7860 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.7875 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122837.7879 bkupamd523v73cd2hnn3lhs3s9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b799781645b7fe5b8','aut645b753042645b7fe57b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122837.7884 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.7887 bkupamd523v73cd2hnn3lhs3s9 Query : select st.usalote valor from st where st.ref = '304.4020.00.1'
20230510@122837.7899 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4020.00.1'
20230510@122837.7910 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.7923 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122837.7947 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.7960 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122837.7965 bkupamd523v73cd2hnn3lhs3s9 Query : select sestamp valor from se where ref ='304.4020.00.1' and lote = '230335'
20230510@122837.7974 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122837.7984 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.7996 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122837.8019 bkupamd523v73cd2hnn3lhs3s9 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 ('aut645b793606645b7fe5c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',120.000 ,'aut645b753042645b7fe57b' ,21.000000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230510@122837.8273 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.8301 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122837.8306 bkupamd523v73cd2hnn3lhs3s9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b793606645b7fe5c2','aut645b753042645b7fe57b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122837.8310 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.8313 bkupamd523v73cd2hnn3lhs3s9 Query : select st.usalote valor from st where st.ref = '304.4020.00.1'
20230510@122837.8325 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4020.00.1'
20230510@122837.8336 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.8349 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122837.8374 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.8386 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122837.8390 bkupamd523v73cd2hnn3lhs3s9 Query : select sestamp valor from se where ref ='304.4020.00.1' and lote = '221640'
20230510@122837.8399 bkupamd523v73cd2hnn3lhs3s9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122837.8409 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122837.8420 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122837.8444 bkupamd523v73cd2hnn3lhs3s9 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 ('aut645b745412645b7fe5cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',120.000 ,'aut645b753042645b7fe57b' ,21.000000,0 ,2,23.00,50000,?,?,?,?,?,?,?,?,?)
20230510@122837.8681 bkupamd523v73cd2hnn3lhs3s9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122837.8698 bkupamd523v73cd2hnn3lhs3s9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122837.8703 bkupamd523v73cd2hnn3lhs3s9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b745412645b7fe5cd','aut645b753042645b7fe57b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122837.8708 bkupamd523v73cd2hnn3lhs3s9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645b753042645b7fe57b','119230000135','wait',39,'ari17112337378,753000005')
20230510@122837.8725 bkupamd523v73cd2hnn3lhs3s9 Query : use flama_phc
20230510@122837.8728 bkupamd523v73cd2hnn3lhs3s9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230510@122837.8755 bkupamd523v73cd2hnn3lhs3s9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='271';
20230510@122837.8767 bkupamd523v73cd2hnn3lhs3s9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='271';
20230510@122837.8778 bkupamd523v73cd2hnn3lhs3s9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='271';
20230510@122837.8790 bkupamd523v73cd2hnn3lhs3s9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='271';
20230510@122837.9146 4pqqs8butcd54pi84bn97sbiph Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230510@122837.9160 4pqqs8butcd54pi84bn97sbiph Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230510@122837.9173 4pqqs8butcd54pi84bn97sbiph Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='272';
20230510@122837.9212 4pqqs8butcd54pi84bn97sbiph Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='272';
20230510@122837.9225 4pqqs8butcd54pi84bn97sbiph Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='272';
20230510@122837.9236 4pqqs8butcd54pi84bn97sbiph Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='272';
20230510@122837.9247 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122837.9250 4pqqs8butcd54pi84bn97sbiph Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230510@122837.9264 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122837.9267 4pqqs8butcd54pi84bn97sbiph Query : select no, estab,szadrsdesc from szadrs where u_coddest=3674
20230510@122837.9303 4pqqs8butcd54pi84bn97sbiph Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20230510@122837.9444 4pqqs8butcd54pi84bn97sbiph 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 = 0000136 and bi.ref ='324.4960.00.1' and bi.lordem =20000
20230510@122837.9766 4pqqs8butcd54pi84bn97sbiph Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043199,7000000-2 ' 
20230510@122838.1200 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.1250 4pqqs8butcd54pi84bn97sbiph Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230510@122838.1420 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.1450 4pqqs8butcd54pi84bn97sbiph Query : select top 1 1 valor from td where td.ndoc = 39
20230510@122838.1550 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.1580 4pqqs8butcd54pi84bn97sbiph Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230510@122838.1690 4pqqs8butcd54pi84bn97sbiph 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
20230510@122838.2320 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.2370 4pqqs8butcd54pi84bn97sbiph Query : select top 1 ~inactivo valor from cl where no = '199524' and estab = 0 order by inactivo desc
20230510@122838.2480 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.2510 4pqqs8butcd54pi84bn97sbiph Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230510@122838.2630 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.2660 4pqqs8butcd54pi84bn97sbiph Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230510@122838.2770 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.2800 4pqqs8butcd54pi84bn97sbiph Query : select szadrsstamp valor from szadrs where szadrsdesc='worten-equipamentos para o lar,sa.- az'
20230510@122838.2930 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.2960 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from td where ndoc = 39
20230510@122838.3060 4pqqs8butcd54pi84bn97sbiph Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230510@122838.3190 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122838.3340 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230510@122838.3570 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122838.3700 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230510@122838.3750 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122838.3890 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230510@122838.4020 4pqqs8butcd54pi84bn97sbiph Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122838.4640 4pqqs8butcd54pi84bn97sbiph Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122838.4740 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122838.4900 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230510@122838.5070 4pqqs8butcd54pi84bn97sbiph Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645b788059645b7fe609' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230510@122838.6830 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122838.6990 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230510@122838.7040 4pqqs8butcd54pi84bn97sbiph Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b788059645b7fe609',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122838.7090 4pqqs8butcd54pi84bn97sbiph Query : select top 1 fno valor from wsft039data order by fno desc
20230510@122838.8810 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122838.9710 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230510@122838.9890 4pqqs8butcd54pi84bn97sbiph 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 ('aut645b788059645b7fe609',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',172,199524,0,'2023-05-10',39,'euro',0,0,2023 ,'20230510','1258',?,?,?,?,?)
20230510@122838.1302 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.1306 4pqqs8butcd54pi84bn97sbiph Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20230510@122838.1321 4pqqs8butcd54pi84bn97sbiph 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.4960.00.1'
20230510@122838.2406 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122838.2421 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122838.2462 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122838.2475 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122838.2481 4pqqs8butcd54pi84bn97sbiph Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20230510@122838.2492 4pqqs8butcd54pi84bn97sbiph Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122838.2503 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122838.2515 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122838.2540 4pqqs8butcd54pi84bn97sbiph 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 ('aut645b771563645b7fe63d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',30.000 ,'aut645b788059645b7fe609' ,21.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230510@122838.2821 4pqqs8butcd54pi84bn97sbiph Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122838.2837 4pqqs8butcd54pi84bn97sbiph Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122838.2841 4pqqs8butcd54pi84bn97sbiph Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b771563645b7fe63d','aut645b788059645b7fe609' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122838.2845 4pqqs8butcd54pi84bn97sbiph Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645b788059645b7fe609','119230000136','wait',39,'ari17112337378,753000005')
20230510@122838.2864 4pqqs8butcd54pi84bn97sbiph Query : use flama_phc
20230510@122838.2867 4pqqs8butcd54pi84bn97sbiph Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230510@122838.2879 4pqqs8butcd54pi84bn97sbiph Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='272';
20230510@122838.2891 4pqqs8butcd54pi84bn97sbiph Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='272';
20230510@122838.2902 4pqqs8butcd54pi84bn97sbiph Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='272';
20230510@122838.2912 4pqqs8butcd54pi84bn97sbiph Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='272';
20230510@122838.3274 ksahk1opfbommkahcnlrjlomvf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230510@122838.3288 ksahk1opfbommkahcnlrjlomvf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230510@122838.3303 ksahk1opfbommkahcnlrjlomvf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='273';
20230510@122838.3343 ksahk1opfbommkahcnlrjlomvf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='273';
20230510@122838.3357 ksahk1opfbommkahcnlrjlomvf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='273';
20230510@122838.3369 ksahk1opfbommkahcnlrjlomvf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='273';
20230510@122838.3382 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.3385 ksahk1opfbommkahcnlrjlomvf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230510@122838.3399 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.3402 ksahk1opfbommkahcnlrjlomvf Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20230510@122838.3436 ksahk1opfbommkahcnlrjlomvf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9225.00.1'
20230510@122838.3790 ksahk1opfbommkahcnlrjlomvf 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 = 0000137 and bi.ref ='328.9225.00.1' and bi.lordem =20000
20230510@122838.4133 ksahk1opfbommkahcnlrjlomvf Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043248,6690000-2 ' 
20230510@122838.4463 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.4467 ksahk1opfbommkahcnlrjlomvf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230510@122838.4485 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.4487 ksahk1opfbommkahcnlrjlomvf Query : select top 1 1 valor from td where td.ndoc = 39
20230510@122838.4498 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.4583 ksahk1opfbommkahcnlrjlomvf Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230510@122838.4729 ksahk1opfbommkahcnlrjlomvf 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
20230510@122838.4817 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.4821 ksahk1opfbommkahcnlrjlomvf Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20230510@122838.4832 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.4836 ksahk1opfbommkahcnlrjlomvf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230510@122838.4847 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.4892 ksahk1opfbommkahcnlrjlomvf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230510@122838.5074 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.5078 ksahk1opfbommkahcnlrjlomvf Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20230510@122838.5126 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.5128 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from td where ndoc = 39
20230510@122838.5140 ksahk1opfbommkahcnlrjlomvf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230510@122838.5151 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122838.5166 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230510@122838.5183 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122838.5195 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230510@122838.5199 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122838.5212 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230510@122838.5221 ksahk1opfbommkahcnlrjlomvf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122838.5261 ksahk1opfbommkahcnlrjlomvf Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122838.5270 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122838.5283 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230510@122838.5293 ksahk1opfbommkahcnlrjlomvf Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645b762815645b7fe67f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230510@122838.5462 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122838.5476 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230510@122838.5481 ksahk1opfbommkahcnlrjlomvf Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b762815645b7fe67f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122838.5485 ksahk1opfbommkahcnlrjlomvf Query : select top 1 fno valor from wsft039data order by fno desc
20230510@122838.5496 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122838.5509 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230510@122838.5525 ksahk1opfbommkahcnlrjlomvf 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 ('aut645b762815645b7fe67f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',173,100810,0,'2023-05-10',39,'euro',0,0,2023 ,'20230510','1258',?,?,?,?,?)
20230510@122838.5940 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.5948 ksahk1opfbommkahcnlrjlomvf Query : select st.usalote valor from st where st.ref = '328.9225.00.1'
20230510@122838.5961 ksahk1opfbommkahcnlrjlomvf 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 = '328.9225.00.1'
20230510@122838.6132 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122838.6158 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122838.6264 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122838.6296 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122838.6301 ksahk1opfbommkahcnlrjlomvf Query : select sestamp valor from se where ref ='328.9225.00.1' and lote = 'r2101191100a'
20230510@122838.6316 ksahk1opfbommkahcnlrjlomvf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122838.6455 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122838.6468 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122838.6494 ksahk1opfbommkahcnlrjlomvf 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 ('aut645b747374645b7fe69d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut645b762815645b7fe67f' ,161.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230510@122838.6829 ksahk1opfbommkahcnlrjlomvf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122838.6959 ksahk1opfbommkahcnlrjlomvf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122838.6964 ksahk1opfbommkahcnlrjlomvf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b747374645b7fe69d','aut645b762815645b7fe67f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122838.6969 ksahk1opfbommkahcnlrjlomvf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645b762815645b7fe67f','119230000137','wait',39,'ari17112337378,753000005')
20230510@122838.6985 ksahk1opfbommkahcnlrjlomvf Query : use flama_phc
20230510@122838.6988 ksahk1opfbommkahcnlrjlomvf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230510@122838.7000 ksahk1opfbommkahcnlrjlomvf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='273';
20230510@122838.7012 ksahk1opfbommkahcnlrjlomvf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='273';
20230510@122838.7023 ksahk1opfbommkahcnlrjlomvf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='273';
20230510@122838.7035 ksahk1opfbommkahcnlrjlomvf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='273';
20230510@122838.7967 kre8kc233oiil01gp3g1ufjvjp Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230510@122838.7980 kre8kc233oiil01gp3g1ufjvjp Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230510@122838.7994 kre8kc233oiil01gp3g1ufjvjp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='274';
20230510@122838.8036 kre8kc233oiil01gp3g1ufjvjp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='274';
20230510@122838.8048 kre8kc233oiil01gp3g1ufjvjp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='274';
20230510@122838.8058 kre8kc233oiil01gp3g1ufjvjp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='274';
20230510@122838.8069 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.8072 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230510@122838.8086 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.8089 kre8kc233oiil01gp3g1ufjvjp Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20230510@122838.8203 kre8kc233oiil01gp3g1ufjvjp 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'
20230510@122838.8350 kre8kc233oiil01gp3g1ufjvjp 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 = 0000138 and bi.ref ='324.670.00.01' and bi.lordem =20000
20230510@122838.8677 kre8kc233oiil01gp3g1ufjvjp Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051043260,0900000-2 ' 
20230510@122838.9004 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.9008 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230510@122838.9024 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.9027 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 1 valor from td where td.ndoc = 39
20230510@122838.9036 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.9040 kre8kc233oiil01gp3g1ufjvjp Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230510@122838.9050 kre8kc233oiil01gp3g1ufjvjp 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
20230510@122838.9104 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.9146 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20230510@122838.9280 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.9283 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230510@122838.9295 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.9297 kre8kc233oiil01gp3g1ufjvjp Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230510@122838.9309 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.9312 kre8kc233oiil01gp3g1ufjvjp Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20230510@122838.9323 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.9326 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from td where ndoc = 39
20230510@122838.9336 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230510@122838.9347 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122838.9360 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230510@122838.9376 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122838.9389 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230510@122838.9393 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122838.9406 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230510@122838.9415 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122838.9455 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@122838.9466 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@122838.9479 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230510@122838.9489 kre8kc233oiil01gp3g1ufjvjp Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645b709790645b7fe6e5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230510@122838.9647 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@122838.9660 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230510@122838.9664 kre8kc233oiil01gp3g1ufjvjp Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b709790645b7fe6e5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122838.9669 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 fno valor from wsft039data order by fno desc
20230510@122838.9682 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@122838.9696 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230510@122838.9713 kre8kc233oiil01gp3g1ufjvjp 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 ('aut645b709790645b7fe6e5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',174,100810,0,'2023-05-10',39,'euro',0,0,2023 ,'20230510','1258',?,?,?,?,?)
20230510@122838.9976 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122838.9980 kre8kc233oiil01gp3g1ufjvjp Query : select st.usalote valor from st where st.ref = '324.670.00.01'
20230510@122839.7900 kre8kc233oiil01gp3g1ufjvjp 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'
20230510@122839.2770 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122839.2920 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@122839.3140 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122839.3270 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@122839.3310 kre8kc233oiil01gp3g1ufjvjp Query : select sestamp valor from se where ref ='324.670.00.01' and lote = 'r2200755200a'
20230510@122839.3420 kre8kc233oiil01gp3g1ufjvjp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@122839.3550 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@122839.3670 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@122839.3900 kre8kc233oiil01gp3g1ufjvjp 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 ('aut645b706314645b7fe708',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut645b709790645b7fe6e5' ,91.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230510@122839.6350 kre8kc233oiil01gp3g1ufjvjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@122839.6500 kre8kc233oiil01gp3g1ufjvjp Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@122839.6550 kre8kc233oiil01gp3g1ufjvjp Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645b706314645b7fe708','aut645b709790645b7fe6e5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@122839.6590 kre8kc233oiil01gp3g1ufjvjp Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645b709790645b7fe6e5','119230000138','wait',39,'ari17112337378,753000005')
20230510@122839.6750 kre8kc233oiil01gp3g1ufjvjp Query : use flama_phc
20230510@122839.6780 kre8kc233oiil01gp3g1ufjvjp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230510@122839.6890 kre8kc233oiil01gp3g1ufjvjp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='274';
20230510@122839.7020 kre8kc233oiil01gp3g1ufjvjp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='274';
20230510@122839.7130 kre8kc233oiil01gp3g1ufjvjp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='274';
20230510@122839.7230 kre8kc233oiil01gp3g1ufjvjp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='274';

20230510@154755.8742 6naa2tg73olaa6etunv3gq82ao Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='275';
20230510@154755.8755 6naa2tg73olaa6etunv3gq82ao Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='275';
20230510@154755.8768 6naa2tg73olaa6etunv3gq82ao Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='275';
20230510@154755.8779 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.8783 6naa2tg73olaa6etunv3gq82ao Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230510@154755.8798 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.8802 6naa2tg73olaa6etunv3gq82ao Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20230510@154755.8841 6naa2tg73olaa6etunv3gq82ao 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'
20230510@154755.8994 6naa2tg73olaa6etunv3gq82ao 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 = 0000139 and bi.ref ='324.5347.00.1' and bi.lordem =20000
20230510@154755.9343 6naa2tg73olaa6etunv3gq82ao Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051048526,1630000-2 ' 
20230510@154755.9692 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.9696 6naa2tg73olaa6etunv3gq82ao Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230510@154755.9713 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.9720 6naa2tg73olaa6etunv3gq82ao Query : select top 1 1 valor from td where td.ndoc = 39
20230510@154755.9732 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.9736 6naa2tg73olaa6etunv3gq82ao Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230510@154755.9749 6naa2tg73olaa6etunv3gq82ao 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
20230510@154755.9768 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.9771 6naa2tg73olaa6etunv3gq82ao Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20230510@154755.9785 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.9789 6naa2tg73olaa6etunv3gq82ao Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230510@154755.9801 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.9804 6naa2tg73olaa6etunv3gq82ao Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230510@154755.9816 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.9819 6naa2tg73olaa6etunv3gq82ao Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20230510@154755.9834 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154755.9837 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from td where ndoc = 39
20230510@154755.9848 6naa2tg73olaa6etunv3gq82ao Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230510@154755.9863 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@154755.9881 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230510@154755.9909 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@154755.9925 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230510@154755.9931 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@154755.9946 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230510@154755.9957 6naa2tg73olaa6etunv3gq82ao Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@154755.9999 6naa2tg73olaa6etunv3gq82ao Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230510@154756.2300 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230510@154756.3800 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230510@154756.5000 6naa2tg73olaa6etunv3gq82ao Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645ba66677645bae9bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230510@154756.2310 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230510@154756.2470 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230510@154756.2530 6naa2tg73olaa6etunv3gq82ao Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645ba66677645bae9bf3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@154756.2760 6naa2tg73olaa6etunv3gq82ao Query : select top 1 fno valor from wsft039data order by fno desc
20230510@154756.2890 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230510@154756.3040 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230510@154756.3270 6naa2tg73olaa6etunv3gq82ao 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 ('aut645ba66677645bae9bf3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',175,100810,0,'2023-05-10',39,'euro',0,0,2023 ,'20230510','1617',?,?,?,?,?)
20230510@154756.6350 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154756.6400 6naa2tg73olaa6etunv3gq82ao Query : select st.usalote valor from st where st.ref = '324.5347.00.1'
20230510@154756.6560 6naa2tg73olaa6etunv3gq82ao 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'
20230510@154756.8010 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@154756.8180 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@154756.8430 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@154756.8570 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@154756.8620 6naa2tg73olaa6etunv3gq82ao Query : select sestamp valor from se where ref ='324.5347.00.1' and lote = 'r2200658100a'
20230510@154756.8750 6naa2tg73olaa6etunv3gq82ao Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@154756.8910 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@154756.9040 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@154756.9300 6naa2tg73olaa6etunv3gq82ao 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 ('aut645ba86522645bae9c15',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',150.000 ,'aut645ba66677645bae9bf3' ,23.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230510@154756.1202 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@154756.1219 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@154756.1224 6naa2tg73olaa6etunv3gq82ao Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645ba86522645bae9c15','aut645ba66677645bae9bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@154756.1230 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@154756.1246 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230510@154756.1277 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@154756.1293 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230510@154756.1299 6naa2tg73olaa6etunv3gq82ao Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230510@154756.1315 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230510@154756.1330 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230510@154756.1359 6naa2tg73olaa6etunv3gq82ao Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645ba55723645bae9c20',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645ba66677645bae9bf3' ,0,0 ,2,23.00,20000,?,?,?)
20230510@154756.1624 6naa2tg73olaa6etunv3gq82ao Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230510@154756.1649 6naa2tg73olaa6etunv3gq82ao Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230510@154756.1654 6naa2tg73olaa6etunv3gq82ao Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645ba55723645bae9c20','aut645ba66677645bae9bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230510@154756.1660 6naa2tg73olaa6etunv3gq82ao Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645ba66677645bae9bf3','119230000139','wait',39,'ari17112337378,753000005')
20230510@154756.1681 6naa2tg73olaa6etunv3gq82ao Query : use flama_phc
20230510@154756.1684 6naa2tg73olaa6etunv3gq82ao Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230510@154756.1712 6naa2tg73olaa6etunv3gq82ao Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='275';
20230510@154756.1727 6naa2tg73olaa6etunv3gq82ao Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='275';
20230510@154756.1740 6naa2tg73olaa6etunv3gq82ao Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='275';
20230510@154756.1753 6naa2tg73olaa6etunv3gq82ao Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='275';
20230510@154756.2086 ueoac649ohh8lnt026fthm4pf9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230510@154756.2104 ueoac649ohh8lnt026fthm4pf9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230510@154756.2125 ueoac649ohh8lnt026fthm4pf9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='276';
20230510@154756.2165 ueoac649ohh8lnt026fthm4pf9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='276';
20230510@154756.2188 ueoac649ohh8lnt026fthm4pf9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='276';
20230510@154756.2201 ueoac649ohh8lnt026fthm4pf9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='276';
20230510@154756.2221 ueoac649ohh8lnt026fthm4pf9 Query : use flama_phc
20230510@154756.2225 ueoac649ohh8lnt026fthm4pf9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230510@154756.2239 ueoac649ohh8lnt026fthm4pf9 Query : use flama_phc
20230510@154756.2243 ueoac649ohh8lnt026fthm4pf9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=416
20230510@154756.2334 ueoac649ohh8lnt026fthm4pf9 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'
20230510@154756.2348 ueoac649ohh8lnt026fthm4pf9 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 = 0000140 and bi.ref ='324.5347.00.1' and bi.lordem =20000
20230510@154756.2694 ueoac649ohh8lnt026fthm4pf9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051048927,6030000-2 ' 
20230510@154756.3035 ueoac649ohh8lnt026fthm4pf9 Query : use flama_phc
