20241115@154511.4618 luitco5fnvt3l93j1gj08ggooq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.4638 luitco5fnvt3l93j1gj08ggooq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154511.4769 luitco5fnvt3l93j1gj08ggooq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.4789 luitco5fnvt3l93j1gj08ggooq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154511.4800 luitco5fnvt3l93j1gj08ggooq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154511.4814 luitco5fnvt3l93j1gj08ggooq Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2400228200a'
20241115@154511.4828 luitco5fnvt3l93j1gj08ggooq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.4846 luitco5fnvt3l93j1gj08ggooq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154511.4860 luitco5fnvt3l93j1gj08ggooq Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673766880267376c8775','aut673766189467376c868c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154511.4865 luitco5fnvt3l93j1gj08ggooq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.4881 luitco5fnvt3l93j1gj08ggooq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154511.4914 luitco5fnvt3l93j1gj08ggooq Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673766880267376c8775',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut673766189467376c868c' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241115@154511.5339 luitco5fnvt3l93j1gj08ggooq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.5360 luitco5fnvt3l93j1gj08ggooq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154511.5389 luitco5fnvt3l93j1gj08ggooq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.5405 luitco5fnvt3l93j1gj08ggooq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154511.5415 luitco5fnvt3l93j1gj08ggooq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154511.5429 luitco5fnvt3l93j1gj08ggooq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.5445 luitco5fnvt3l93j1gj08ggooq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154511.5459 luitco5fnvt3l93j1gj08ggooq Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673764630467376c8784','aut673766189467376c868c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154511.5463 luitco5fnvt3l93j1gj08ggooq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.5479 luitco5fnvt3l93j1gj08ggooq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154511.5510 luitco5fnvt3l93j1gj08ggooq Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673764630467376c8784',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673766189467376c868c' ,0,0 ,2,23.00,140000,?,?,?)
20241115@154511.5889 luitco5fnvt3l93j1gj08ggooq Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673766189467376c868c','2407632','wait',39,'adm09112754980.682000002')
20241115@154511.5970 luitco5fnvt3l93j1gj08ggooq Query : use flama_phc
20241115@154511.5974 luitco5fnvt3l93j1gj08ggooq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241115@154511.6005 luitco5fnvt3l93j1gj08ggooq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3347';
20241115@154511.6047 luitco5fnvt3l93j1gj08ggooq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3347';
20241115@154511.6097 luitco5fnvt3l93j1gj08ggooq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3347';
20241115@154511.6137 luitco5fnvt3l93j1gj08ggooq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3347';
20241115@154511.6768 kc1lv2g93is1bf0euqh1f850nv Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241115@154511.6779 kc1lv2g93is1bf0euqh1f850nv Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241115@154511.6877 kc1lv2g93is1bf0euqh1f850nv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3348';
20241115@154511.6981 kc1lv2g93is1bf0euqh1f850nv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3348';
20241115@154511.7059 kc1lv2g93is1bf0euqh1f850nv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3348';
20241115@154511.7133 kc1lv2g93is1bf0euqh1f850nv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3348';
20241115@154511.7222 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.7226 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241115@154511.7290 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.7296 kc1lv2g93is1bf0euqh1f850nv Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241115@154511.7376 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241115@154511.7592 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407633 and bi.ref ='324.646.00.01' and bi.lordem =1
20241115@154511.7991 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241115@154511.8015 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407633 and bi.ref ='324.646.00.01' and bi.lordem =1
20241115@154511.8033 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241115@154511.8055 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407633 and bi.ref ='324.646.00.01' and bi.lordem =1
20241115@154511.8075 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241115@154511.8096 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407633 and bi.ref ='324.646.00.01' and bi.lordem =1
20241115@154511.8113 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241115@154511.8134 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407633 and bi.ref ='324.646.00.01' and bi.lordem =1
20241115@154511.8152 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.8156 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241115@154511.8200 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.8204 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 1 valor from td where td.ndoc = 39
20241115@154511.8237 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.8240 kc1lv2g93is1bf0euqh1f850nv Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241115@154511.8271 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241115@154511.8324 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.8328 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241115@154511.8359 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.8363 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241115@154511.8421 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.8424 kc1lv2g93is1bf0euqh1f850nv Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241115@154511.8474 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.8490 kc1lv2g93is1bf0euqh1f850nv Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241115@154511.8541 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154511.8546 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from td where ndoc = 39
20241115@154511.8565 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241115@154511.8586 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.8635 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241115@154511.8658 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.8673 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241115@154511.8798 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.8830 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241115@154511.8845 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241115@154511.8942 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241115@154511.8960 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.8980 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241115@154511.9003 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241115@154511.9288 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154511.9313 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241115@154511.9354 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241115@154511.9367 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241115@154511.9380 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241115@154511.9392 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241115@154511.9405 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241115@154511.9422 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241115@154511.9434 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673766670867376c87d7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241115@154511.9837 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 fno valor from wsftdata order by fno desc
20241115@154512.1191 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.1523 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241115@154512.1554 kc1lv2g93is1bf0euqh1f850nv Query : select 'normal' from dummy
20241115@154512.1573 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673766670867376c87d7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1899,100810,0,'2024-11-15',39,'euro',0,0,2024 ,?,?)
20241115@154512.2243 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154512.2409 kc1lv2g93is1bf0euqh1f850nv Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241115@154512.2834 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20241115@154512.3806 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.5227 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.5261 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.5281 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.5290 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154512.5303 kc1lv2g93is1bf0euqh1f850nv Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241115@154512.5319 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.5337 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.5352 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673767683167376c8881','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154512.5358 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.5375 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.5409 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673767683167376c8881',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241115@154512.5749 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.5768 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.5801 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.5822 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.5833 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154512.5850 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.5929 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.5946 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673766453367376c888e','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154512.5952 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.5971 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.6007 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673766453367376c888e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,20000,?,?,?)
20241115@154512.6361 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154512.6365 kc1lv2g93is1bf0euqh1f850nv Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241115@154512.6389 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20241115@154512.6410 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.6431 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.6468 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.6490 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.6504 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154512.6518 kc1lv2g93is1bf0euqh1f850nv Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241115@154512.6642 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.6663 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.6764 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673760364567376c88a2','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154512.6771 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.6794 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.6936 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673760364567376c88a2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241115@154512.7408 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.7428 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.7472 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.7491 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.7615 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154512.7630 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.7698 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.7714 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673761266267376c88ba','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154512.7719 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.7764 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.7839 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673761266267376c88ba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,50000,?,?,?)
20241115@154512.8230 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154512.8233 kc1lv2g93is1bf0euqh1f850nv Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241115@154512.8255 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20241115@154512.8272 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.8291 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.8334 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.8356 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.8369 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154512.8387 kc1lv2g93is1bf0euqh1f850nv Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241115@154512.8403 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.8425 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.8439 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673766051567376c88cd','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154512.8446 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.8466 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.8503 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673766051567376c88cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241115@154512.8872 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.8891 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.8921 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.8938 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.8949 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154512.8964 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.8981 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.8997 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673762469567376c88da','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154512.9004 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.9021 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.9053 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673762469567376c88da',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,80000,?,?,?)
20241115@154512.9433 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154512.9437 kc1lv2g93is1bf0euqh1f850nv Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241115@154512.9460 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20241115@154512.9477 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.9498 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.9525 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.9541 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.9551 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154512.9565 kc1lv2g93is1bf0euqh1f850nv Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241115@154512.9581 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.9599 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154512.9612 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673763209067376c88e9','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154512.9617 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154512.9632 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154512.9662 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673763209067376c88e9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241115@154513.1120 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.1320 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154513.1630 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.1910 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.2030 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154513.2190 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.2380 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.2530 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673769806367376c8905','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154513.2580 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.2750 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154513.3080 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673769806367376c8905',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,110000,?,?,?)
20241115@154513.7430 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154513.7470 kc1lv2g93is1bf0euqh1f850nv Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241115@154513.7730 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20241115@154513.7890 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.8090 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154513.8360 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.8510 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.8600 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154513.8730 kc1lv2g93is1bf0euqh1f850nv Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241115@154513.8860 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.9020 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.9170 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673760100967376c8915','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154513.9210 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.9360 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154513.9680 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673760100967376c8915',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241115@154513.1397 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.1430 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154513.1456 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.1471 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.1479 kc1lv2g93is1bf0euqh1f850nv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154513.1492 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.1508 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.1546 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673769366867376c8924','aut673766670867376c87d7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154513.1551 kc1lv2g93is1bf0euqh1f850nv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.1570 kc1lv2g93is1bf0euqh1f850nv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154513.1604 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673769366867376c8924',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673766670867376c87d7' ,0,0 ,2,23.00,140000,?,?,?)
20241115@154513.1947 kc1lv2g93is1bf0euqh1f850nv Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673766670867376c87d7','2407633','wait',39,'adm09112754980.682000002')
20241115@154513.2029 kc1lv2g93is1bf0euqh1f850nv Query : use flama_phc
20241115@154513.2033 kc1lv2g93is1bf0euqh1f850nv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241115@154513.2083 kc1lv2g93is1bf0euqh1f850nv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3348';
20241115@154513.2131 kc1lv2g93is1bf0euqh1f850nv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3348';
20241115@154513.2208 kc1lv2g93is1bf0euqh1f850nv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3348';
20241115@154513.2249 kc1lv2g93is1bf0euqh1f850nv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3348';
20241115@154513.2810 acv22ls9c4trkj1ortavc2j6ki Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241115@154513.2827 acv22ls9c4trkj1ortavc2j6ki Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241115@154513.3021 acv22ls9c4trkj1ortavc2j6ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3349';
20241115@154513.3089 acv22ls9c4trkj1ortavc2j6ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3349';
20241115@154513.3147 acv22ls9c4trkj1ortavc2j6ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3349';
20241115@154513.3188 acv22ls9c4trkj1ortavc2j6ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3349';
20241115@154513.3253 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.3257 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241115@154513.3321 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.3324 acv22ls9c4trkj1ortavc2j6ki Query : select no, estab,szadrsdesc from szadrs where u_coddest=170
20241115@154513.3429 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1332.00.1'
20241115@154513.3641 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407634 and bi.ref ='324.1332.00.1' and bi.lordem =1
20241115@154513.4275 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1332.00.1'
20241115@154513.4299 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407634 and bi.ref ='324.1332.00.1' and bi.lordem =1
20241115@154513.4320 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1321.00.1'
20241115@154513.4344 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407634 and bi.ref ='324.1321.00.1' and bi.lordem =2
20241115@154513.4753 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1321.00.1'
20241115@154513.4780 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407634 and bi.ref ='324.1321.00.1' and bi.lordem =2
20241115@154513.4803 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1321.00.1'
20241115@154513.4830 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407634 and bi.ref ='324.1321.00.1' and bi.lordem =3
20241115@154513.5207 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20241115@154513.5411 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407634 and bi.ref ='324.1676.00.1' and bi.lordem =4
20241115@154513.5819 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20241115@154513.5841 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407634 and bi.ref ='324.1676.00.1' and bi.lordem =4
20241115@154513.5861 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20241115@154513.5880 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407634 and bi.ref ='324.1676.00.1' and bi.lordem =5
20241115@154513.6260 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.6264 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241115@154513.6327 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.6331 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 1 valor from td where td.ndoc = 39
20241115@154513.6409 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.6413 acv22ls9c4trkj1ortavc2j6ki Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241115@154513.6447 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241115@154513.6485 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.6489 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 ~inactivo valor from cl where no = '102068' and estab = 0 order by inactivo desc
20241115@154513.6639 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.6644 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241115@154513.6680 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.6683 acv22ls9c4trkj1ortavc2j6ki Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241115@154513.6733 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.6777 acv22ls9c4trkj1ortavc2j6ki Query : select szadrsstamp valor from szadrs where szadrsdesc='magalhÃes & vinha, lda.'
20241115@154513.6864 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.6868 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from td where ndoc = 39
20241115@154513.6882 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241115@154513.6901 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.6943 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241115@154513.6964 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.6990 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241115@154513.7020 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.7036 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241115@154513.7050 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241115@154513.7125 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241115@154513.7141 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.7170 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241115@154513.7188 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673766716867376c89ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241115@154513.7457 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.7482 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241115@154513.7526 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241115@154513.7539 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241115@154513.7617 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241115@154513.7632 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241115@154513.7646 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241115@154513.7661 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241115@154513.7680 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673766716867376c89ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241115@154513.8145 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 fno valor from wsftdata order by fno desc
20241115@154513.8181 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.8205 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241115@154513.8233 acv22ls9c4trkj1ortavc2j6ki Query : select 'normal' from dummy
20241115@154513.8258 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673766716867376c89ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1900,102068,0,'2024-11-15',39,'euro',0,0,2024 ,?,?)
20241115@154513.8731 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.8735 acv22ls9c4trkj1ortavc2j6ki Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241115@154513.8778 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1332.00.1'
20241115@154513.8974 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.8993 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154513.9020 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.9037 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.9046 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154513.9060 acv22ls9c4trkj1ortavc2j6ki Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241115@154513.9087 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.9103 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.9122 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673765308567376c89dd','aut673766716867376c89ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154513.9126 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.9142 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154513.9194 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673765308567376c89dd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut673766716867376c89ac' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241115@154513.9554 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154513.9558 acv22ls9c4trkj1ortavc2j6ki Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241115@154513.9596 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1332.00.1'
20241115@154513.9613 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.9714 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154513.9750 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.9813 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.9824 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154513.9839 acv22ls9c4trkj1ortavc2j6ki Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241115@154513.9942 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154513.9963 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154513.9979 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673761215667376c89f2','aut673766716867376c89ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154513.9985 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.2000 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.3800 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673761215667376c89f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',17.000 ,'aut673766716867376c89ac' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241115@154514.3810 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154514.3850 acv22ls9c4trkj1ortavc2j6ki Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20241115@154514.4110 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1321.00.1'
20241115@154514.4280 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.4480 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.4880 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.5070 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.5180 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154514.5330 acv22ls9c4trkj1ortavc2j6ki Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20241115@154514.5500 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.5680 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.5820 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673763030467376c8a0d','aut673766716867376c89ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154514.5870 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.6070 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.6380 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673763030467376c8a0d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut673766716867376c89ac' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241115@154514.9820 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154514.9860 acv22ls9c4trkj1ortavc2j6ki Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20241115@154514.1009 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1321.00.1'
20241115@154514.1026 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.1045 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.1074 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.1093 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.1104 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154514.1119 acv22ls9c4trkj1ortavc2j6ki Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20241115@154514.1134 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.1153 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.1168 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673769564367376c8a1b','aut673766716867376c89ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154514.1175 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.1194 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.1226 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673769564367376c8a1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',21.000 ,'aut673766716867376c89ac' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241115@154514.1619 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154514.1622 acv22ls9c4trkj1ortavc2j6ki Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20241115@154514.1645 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1321.00.1'
20241115@154514.1662 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.1682 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.1713 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.1730 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.1740 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154514.1755 acv22ls9c4trkj1ortavc2j6ki Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20241115@154514.1769 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.1786 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.1799 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673762723067376c8a2b','aut673766716867376c89ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154514.1804 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.1823 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.1857 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673762723067376c8a2b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673766716867376c89ac' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241115@154514.2247 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154514.2252 acv22ls9c4trkj1ortavc2j6ki Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20241115@154514.2275 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1676.00.1'
20241115@154514.2445 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.2463 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.2488 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.2506 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.2515 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154514.2528 acv22ls9c4trkj1ortavc2j6ki Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20241115@154514.2546 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.2563 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.2576 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673761845567376c8a3e','aut673766716867376c89ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154514.2580 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.2595 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.2627 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673761845567376c8a3e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673766716867376c89ac' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241115@154514.3039 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154514.3042 acv22ls9c4trkj1ortavc2j6ki Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20241115@154514.3068 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1676.00.1'
20241115@154514.3087 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.3108 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.3142 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.3164 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.3179 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154514.3197 acv22ls9c4trkj1ortavc2j6ki Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20241115@154514.3213 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.3232 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.3248 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673765077667376c8a4e','aut673766716867376c89ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154514.3253 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.3270 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.3304 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673765077667376c8a4e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut673766716867376c89ac' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241115@154514.3608 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154514.3612 acv22ls9c4trkj1ortavc2j6ki Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20241115@154514.3640 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1676.00.1'
20241115@154514.3659 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.3678 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.3709 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.3730 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.3741 acv22ls9c4trkj1ortavc2j6ki Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154514.3759 acv22ls9c4trkj1ortavc2j6ki Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20241115@154514.3773 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.3790 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154514.3804 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673763319167376c8a5c','aut673766716867376c89ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154514.3810 acv22ls9c4trkj1ortavc2j6ki Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.3830 acv22ls9c4trkj1ortavc2j6ki Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154514.3865 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673763319167376c8a5c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673766716867376c89ac' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241115@154514.4287 acv22ls9c4trkj1ortavc2j6ki Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673766716867376c89ac','2407634','wait',39,'adm09112754980.682000002')
20241115@154514.4367 acv22ls9c4trkj1ortavc2j6ki Query : use flama_phc
20241115@154514.4371 acv22ls9c4trkj1ortavc2j6ki Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241115@154514.4404 acv22ls9c4trkj1ortavc2j6ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3349';
20241115@154514.4458 acv22ls9c4trkj1ortavc2j6ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3349';
20241115@154514.4511 acv22ls9c4trkj1ortavc2j6ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3349';
20241115@154514.4547 acv22ls9c4trkj1ortavc2j6ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3349';
20241115@154514.5673 9123t9boph89irpgrbvhvpl6t1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241115@154514.5685 9123t9boph89irpgrbvhvpl6t1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241115@154514.5918 9123t9boph89irpgrbvhvpl6t1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3350';
20241115@154514.6002 9123t9boph89irpgrbvhvpl6t1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3350';
20241115@154514.6065 9123t9boph89irpgrbvhvpl6t1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3350';
20241115@154514.6107 9123t9boph89irpgrbvhvpl6t1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3350';
20241115@154514.6174 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.6178 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241115@154514.6257 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.6261 9123t9boph89irpgrbvhvpl6t1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=692
20241115@154514.6377 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1290.1003'
20241115@154514.6406 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407635 and bi.ref ='325.1290.1003' and bi.lordem =1
20241115@154514.6885 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.6892 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241115@154514.6946 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.6950 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 1 valor from td where td.ndoc = 39
20241115@154514.6984 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.6988 9123t9boph89irpgrbvhvpl6t1 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241115@154514.7020 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241115@154514.7058 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.7062 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 ~inactivo valor from cl where no = '199530' and estab = 0 order by inactivo desc
20241115@154514.7209 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.7212 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241115@154514.7243 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.7246 9123t9boph89irpgrbvhvpl6t1 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241115@154514.7288 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.7291 9123t9boph89irpgrbvhvpl6t1 Query : select szadrsstamp valor from szadrs where szadrsdesc='pingo doce-distribuiÇÃo alimentar, s.a.- alcochete'
20241115@154514.7345 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154514.7349 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from td where ndoc = 39
20241115@154514.7361 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241115@154514.7377 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.7396 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241115@154514.7436 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.7457 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241115@154514.7494 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.7513 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241115@154514.7559 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241115@154514.7636 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241115@154514.7674 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.7774 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241115@154514.7793 9123t9boph89irpgrbvhvpl6t1 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673767126367376c8ab8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241115@154514.8043 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154514.8093 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241115@154514.8133 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241115@154514.8189 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241115@154514.8217 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241115@154514.8291 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241115@154514.9726 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241115@154514.9742 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241115@154514.9756 9123t9boph89irpgrbvhvpl6t1 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673767126367376c8ab8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241115@154515.1390 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 fno valor from wsftdata order by fno desc
20241115@154515.3730 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154515.4050 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241115@154515.4350 9123t9boph89irpgrbvhvpl6t1 Query : select 'normal' from dummy
20241115@154515.4540 9123t9boph89irpgrbvhvpl6t1 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673767126367376c8ab8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1901,199530,0,'2024-11-15',39,'euro',0,0,2024 ,?,?)
20241115@154515.8850 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154515.8890 9123t9boph89irpgrbvhvpl6t1 Query : select st.usalote valor from st where st.ref = '325.1290.1003'
20241115@154515.9170 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '325.1290.1003'
20241115@154515.1120 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154515.1140 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154515.1174 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154515.1192 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154515.1203 9123t9boph89irpgrbvhvpl6t1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154515.1219 9123t9boph89irpgrbvhvpl6t1 Query : select sestamp valor from se where ref ='325.1290.1003' and lote = 'r2400796200a'
20241115@154515.1236 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154515.1255 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154515.1268 9123t9boph89irpgrbvhvpl6t1 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673765369767376c8b1e','aut673767126367376c8ab8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154515.1273 9123t9boph89irpgrbvhvpl6t1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154515.1289 9123t9boph89irpgrbvhvpl6t1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154515.1336 9123t9boph89irpgrbvhvpl6t1 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673765369767376c8b1e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',612.000 ,'aut673767126367376c8ab8' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241115@154515.1635 9123t9boph89irpgrbvhvpl6t1 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673767126367376c8ab8','2407635','wait',39,'adm09112754980.682000002')
20241115@154515.1782 9123t9boph89irpgrbvhvpl6t1 Query : use flama_phc
20241115@154515.1786 9123t9boph89irpgrbvhvpl6t1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241115@154515.1820 9123t9boph89irpgrbvhvpl6t1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3350';
20241115@154515.1871 9123t9boph89irpgrbvhvpl6t1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3350';
20241115@154515.1927 9123t9boph89irpgrbvhvpl6t1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3350';
20241115@154515.2028 9123t9boph89irpgrbvhvpl6t1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3350';
20241115@154515.3410 4gink92ottems3sekm6902rpv2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241115@154515.3494 4gink92ottems3sekm6902rpv2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241115@154515.3987 4gink92ottems3sekm6902rpv2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3351';
20241115@154515.4378 4gink92ottems3sekm6902rpv2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3351';
20241115@154515.4740 4gink92ottems3sekm6902rpv2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3351';
20241115@154515.5056 4gink92ottems3sekm6902rpv2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3351';
20241115@154515.5722 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154515.5764 4gink92ottems3sekm6902rpv2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241115@154515.6397 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154515.6438 4gink92ottems3sekm6902rpv2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6258
20241115@154515.6866 4gink92ottems3sekm6902rpv2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4962.00.1'
20241115@154515.7458 4gink92ottems3sekm6902rpv2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407636 and bi.ref ='324.4962.00.1' and bi.lordem =1
20241115@154515.8640 4gink92ottems3sekm6902rpv2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4930.00.1'
20241115@154515.8932 4gink92ottems3sekm6902rpv2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407636 and bi.ref ='324.4930.00.1' and bi.lordem =2
20241115@154516.2000 4gink92ottems3sekm6902rpv2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20241115@154516.3150 4gink92ottems3sekm6902rpv2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407636 and bi.ref ='324.727.00.01' and bi.lordem =3
20241115@154516.1536 4gink92ottems3sekm6902rpv2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.711.00.01'
20241115@154516.2075 4gink92ottems3sekm6902rpv2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407636 and bi.ref ='324.711.00.01' and bi.lordem =4
20241115@154516.3687 4gink92ottems3sekm6902rpv2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.939.00.01'
20241115@154516.4282 4gink92ottems3sekm6902rpv2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407636 and bi.ref ='324.939.00.01' and bi.lordem =5
20241115@154516.7402 4gink92ottems3sekm6902rpv2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1462.00.1'
20241115@154516.7697 4gink92ottems3sekm6902rpv2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407636 and bi.ref ='324.1462.00.1' and bi.lordem =6
20241115@154516.8610 4gink92ottems3sekm6902rpv2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20241115@154516.8903 4gink92ottems3sekm6902rpv2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407636 and bi.ref ='324.1608.00.1' and bi.lordem =7
20241115@154516.9840 4gink92ottems3sekm6902rpv2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20241115@154517.5130 4gink92ottems3sekm6902rpv2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407636 and bi.ref ='324.5365.00.1' and bi.lordem =8
20241115@154517.1621 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154517.1703 4gink92ottems3sekm6902rpv2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241115@154517.2192 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154517.2234 4gink92ottems3sekm6902rpv2 Query : select top 1 1 valor from td where td.ndoc = 39
20241115@154517.2610 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154517.2652 4gink92ottems3sekm6902rpv2 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241115@154517.3273 4gink92ottems3sekm6902rpv2 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241115@154517.3731 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154517.3774 4gink92ottems3sekm6902rpv2 Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20241115@154517.4151 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154517.4193 4gink92ottems3sekm6902rpv2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241115@154517.4571 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154517.4614 4gink92ottems3sekm6902rpv2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241115@154517.5070 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154517.5113 4gink92ottems3sekm6902rpv2 Query : select szadrsstamp valor from szadrs where szadrsdesc='iiruñadis sl'
20241115@154517.5660 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154517.5703 4gink92ottems3sekm6902rpv2 Query : select 1 valor from td where ndoc = 39
20241115@154517.5954 4gink92ottems3sekm6902rpv2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241115@154517.6249 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154517.6506 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241115@154517.7967 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154517.8707 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241115@154518.4260 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154518.6810 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241115@154518.9350 4gink92ottems3sekm6902rpv2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241115@154518.1282 4gink92ottems3sekm6902rpv2 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241115@154518.1539 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154518.1793 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241115@154518.2252 4gink92ottems3sekm6902rpv2 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673767266367376c8e16' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241115@154518.2853 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154518.3232 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241115@154518.3939 4gink92ottems3sekm6902rpv2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241115@154518.4148 4gink92ottems3sekm6902rpv2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241115@154518.4498 4gink92ottems3sekm6902rpv2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241115@154518.4861 4gink92ottems3sekm6902rpv2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241115@154518.5071 4gink92ottems3sekm6902rpv2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241115@154518.5285 4gink92ottems3sekm6902rpv2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241115@154518.5497 4gink92ottems3sekm6902rpv2 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673767266367376c8e16',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241115@154518.6219 4gink92ottems3sekm6902rpv2 Query : select top 1 fno valor from wsftdata order by fno desc
20241115@154518.6480 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154518.6734 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241115@154518.7193 4gink92ottems3sekm6902rpv2 Query : select 'normal' from dummy
20241115@154518.7488 4gink92ottems3sekm6902rpv2 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673767266367376c8e16',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1902,200500,0,'2024-11-15',39,'euro',0,0,2024 ,?,?)
20241115@154518.8465 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154518.8507 4gink92ottems3sekm6902rpv2 Query : select st.usalote valor from st where st.ref = '324.4962.00.1'
20241115@154518.8848 4gink92ottems3sekm6902rpv2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4962.00.1'
20241115@154518.9471 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154518.9727 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154519.3110 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154519.5710 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154519.7390 4gink92ottems3sekm6902rpv2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154519.1087 4gink92ottems3sekm6902rpv2 Query : select sestamp valor from se where ref ='324.4962.00.1' and lote = 'r2101092100a'
20241115@154519.3024 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154519.3337 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154519.3550 4gink92ottems3sekm6902rpv2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673766658367376c8f49','aut673767266367376c8e16' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154519.3597 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154519.4264 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154519.6240 4gink92ottems3sekm6902rpv2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673766658367376c8f49',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut673767266367376c8e16' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241115@154519.7082 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154519.7124 4gink92ottems3sekm6902rpv2 Query : select st.usalote valor from st where st.ref = '324.4930.00.1'
20241115@154519.7459 4gink92ottems3sekm6902rpv2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4930.00.1'
20241115@154519.8015 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154519.8270 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154519.8858 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154519.9117 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154519.9284 4gink92ottems3sekm6902rpv2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154519.9534 4gink92ottems3sekm6902rpv2 Query : select sestamp valor from se where ref ='324.4930.00.1' and lote = 'r2400066200a'
20241115@154519.9617 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154519.9839 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154520.6900 4gink92ottems3sekm6902rpv2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673766796467376c8fea','aut673767266367376c8e16' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154520.1130 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154520.3730 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154520.1308 4gink92ottems3sekm6902rpv2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673766796467376c8fea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut673767266367376c8e16' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241115@154520.1988 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154520.2031 4gink92ottems3sekm6902rpv2 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20241115@154520.2338 4gink92ottems3sekm6902rpv2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20241115@154520.3177 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154520.3639 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154520.4225 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154520.4493 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154520.4660 4gink92ottems3sekm6902rpv2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154520.4913 4gink92ottems3sekm6902rpv2 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20241115@154520.5167 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154520.5424 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154520.5633 4gink92ottems3sekm6902rpv2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673761486367376c907e','aut673767266367376c8e16' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154520.5679 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154520.5938 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154520.8358 4gink92ottems3sekm6902rpv2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673761486367376c907e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut673767266367376c8e16' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241115@154520.9193 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154520.9449 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154521.3700 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154521.2970 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154521.4650 4gink92ottems3sekm6902rpv2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154521.7180 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154521.9730 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154521.1181 4gink92ottems3sekm6902rpv2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673769625267376c9111','aut673767266367376c8e16' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154521.1225 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154521.1482 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154521.2127 4gink92ottems3sekm6902rpv2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673769625267376c9111',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673767266367376c8e16' ,0,0 ,2,23.00,40000,?,?,?)
20241115@154521.3097 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154521.3141 4gink92ottems3sekm6902rpv2 Query : select st.usalote valor from st where st.ref = '324.711.00.01'
20241115@154521.3480 4gink92ottems3sekm6902rpv2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.711.00.01'
20241115@154521.3859 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154521.4213 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154521.4799 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154521.5058 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154521.5226 4gink92ottems3sekm6902rpv2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154521.5476 4gink92ottems3sekm6902rpv2 Query : select sestamp valor from se where ref ='324.711.00.01' and lote = 'r2301222100a'
20241115@154521.5727 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154521.5986 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154521.6209 4gink92ottems3sekm6902rpv2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673767182867376c918b','aut673767266367376c8e16' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154521.6256 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154521.6512 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154521.7161 4gink92ottems3sekm6902rpv2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673767182867376c918b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut673767266367376c8e16' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241115@154521.8012 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154521.8266 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154521.8848 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154521.9114 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154522.9780 4gink92ottems3sekm6902rpv2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154522.1231 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154522.1490 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154522.1750 4gink92ottems3sekm6902rpv2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673765983167376c921e','aut673767266367376c8e16' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241115@154522.1798 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154522.2059 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154522.2682 4gink92ottems3sekm6902rpv2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673765983167376c921e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673767266367376c8e16' ,0,0 ,2,23.00,70000,?,?,?)
20241115@154522.3674 4gink92ottems3sekm6902rpv2 Query : use flama_phc
20241115@154522.3716 4gink92ottems3sekm6902rpv2 Query : select st.usalote valor from st where st.ref = '324.939.00.01'
20241115@154522.4053 4gink92ottems3sekm6902rpv2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.939.00.01'
20241115@154522.4915 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154522.5280 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241115@154522.5866 4gink92ottems3sekm6902rpv2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241115@154522.6126 4gink92ottems3sekm6902rpv2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241115@154522.6292 4gink92ottems3sekm6902rpv2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241115@154522.6544 4gink92ottems3sekm6902rpv2 Query : select sestamp valor from se where ref ='324.939.00.01' and lote = 'r2301371200a'
