20240903@182533.2709 j2tnk9ljgfknklo8s3q2ds5s7q 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
20240903@182533.2743 j2tnk9ljgfknklo8s3q2ds5s7q Query : use flama_phc
20240903@182533.2746 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 ~inactivo valor from cl where no = '102355' and estab = 0 order by inactivo desc
20240903@182533.2911 j2tnk9ljgfknklo8s3q2ds5s7q Query : use flama_phc
20240903@182533.2914 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240903@182533.2947 j2tnk9ljgfknklo8s3q2ds5s7q Query : use flama_phc
20240903@182533.2951 j2tnk9ljgfknklo8s3q2ds5s7q Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240903@182533.2994 j2tnk9ljgfknklo8s3q2ds5s7q Query : use flama_phc
20240903@182533.2997 j2tnk9ljgfknklo8s3q2ds5s7q Query : select szadrsstamp valor from szadrs where szadrsdesc='caetano venancio gato carriÇo'
20240903@182533.3049 j2tnk9ljgfknklo8s3q2ds5s7q Query : use flama_phc
20240903@182533.3052 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from td where ndoc = 39
20240903@182533.3064 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240903@182533.3079 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.3095 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182533.3114 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.3129 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182533.3186 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.3201 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182533.3214 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182533.3327 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182533.3339 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.3355 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182533.3372 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d742202466d7468d4e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240903@182533.3557 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.3571 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182533.3602 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240903@182533.3614 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240903@182533.3626 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240903@182533.3637 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240903@182533.3648 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240903@182533.3659 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240903@182533.3670 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d742202466d7468d4e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240903@182533.3916 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 fno valor from wsftdata order by fno desc
20240903@182533.3939 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.3954 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182533.3975 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 'normal' from dummy
20240903@182533.3989 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d742202466d7468d4e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',583,102355,0,'2024-09-03',39,'euro',0,0,2024 ,?,?)
20240903@182533.4323 j2tnk9ljgfknklo8s3q2ds5s7q Query : use flama_phc
20240903@182533.4325 j2tnk9ljgfknklo8s3q2ds5s7q Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20240903@182533.4346 j2tnk9ljgfknklo8s3q2ds5s7q 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 = '323.318.09.00'
20240903@182533.4496 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.4511 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182533.4537 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.4552 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182533.4560 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182533.4576 j2tnk9ljgfknklo8s3q2ds5s7q Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2400053200a'
20240903@182533.4589 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.4602 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182533.4613 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d744016366d7468d70','aut66d742202466d7468d4e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182533.4618 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.4632 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182533.5224 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d744016366d7468d70',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d742202466d7468d4e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240903@182533.5880 j2tnk9ljgfknklo8s3q2ds5s7q Query : use flama_phc
20240903@182533.5883 j2tnk9ljgfknklo8s3q2ds5s7q Query : select st.usalote valor from st where st.ref = '324.1705.00.1'
20240903@182533.5905 j2tnk9ljgfknklo8s3q2ds5s7q 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.1705.00.1'
20240903@182533.6060 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.6075 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182533.6099 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.6143 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182533.6151 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182533.6162 j2tnk9ljgfknklo8s3q2ds5s7q Query : select sestamp valor from se where ref ='324.1705.00.1' and lote = 'r2400050500a'
20240903@182533.6176 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.6189 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182533.6201 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d749291766d7468d96','aut66d742202466d7468d4e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182533.6205 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.6218 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182533.6244 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d749291766d7468d96',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66d742202466d7468d4e' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240903@182533.6507 j2tnk9ljgfknklo8s3q2ds5s7q Query : use flama_phc
20240903@182533.6511 j2tnk9ljgfknklo8s3q2ds5s7q Query : select st.usalote valor from st where st.ref = '324.1536.00.1'
20240903@182533.6538 j2tnk9ljgfknklo8s3q2ds5s7q 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.1536.00.1'
20240903@182533.6691 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.6707 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182533.6732 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.6745 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182533.6754 j2tnk9ljgfknklo8s3q2ds5s7q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182533.6766 j2tnk9ljgfknklo8s3q2ds5s7q Query : select sestamp valor from se where ref ='324.1536.00.1' and lote = 'r2100240100a'
20240903@182533.6780 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.6794 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182533.6806 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d747866966d7468da5','aut66d742202466d7468d4e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182533.6810 j2tnk9ljgfknklo8s3q2ds5s7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.6824 j2tnk9ljgfknklo8s3q2ds5s7q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182533.6853 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d747866966d7468da5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d742202466d7468d4e' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240903@182533.7265 j2tnk9ljgfknklo8s3q2ds5s7q Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d742202466d7468d4e','2405705','wait',39,'adm09112754980.682000002')
20240903@182533.7340 j2tnk9ljgfknklo8s3q2ds5s7q Query : use flama_phc
20240903@182533.7343 j2tnk9ljgfknklo8s3q2ds5s7q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240903@182533.7376 j2tnk9ljgfknklo8s3q2ds5s7q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1805';
20240903@182533.7415 j2tnk9ljgfknklo8s3q2ds5s7q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1805';
20240903@182533.7459 j2tnk9ljgfknklo8s3q2ds5s7q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1805';
20240903@182533.7489 j2tnk9ljgfknklo8s3q2ds5s7q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1805';
20240903@182533.8094 hu679usksii87q7400liur31cr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240903@182533.8106 hu679usksii87q7400liur31cr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240903@182533.8231 hu679usksii87q7400liur31cr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1806';
20240903@182533.8291 hu679usksii87q7400liur31cr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1806';
20240903@182533.8344 hu679usksii87q7400liur31cr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1806';
20240903@182533.8370 hu679usksii87q7400liur31cr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1806';
20240903@182533.8421 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.8424 hu679usksii87q7400liur31cr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240903@182533.8491 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.8494 hu679usksii87q7400liur31cr Query : select no, estab,szadrsdesc from szadrs where u_coddest=410
20240903@182533.8577 hu679usksii87q7400liur31cr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.681.00.01'
20240903@182533.8743 hu679usksii87q7400liur31cr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405707 and bi.ref ='324.681.00.01' and bi.lordem =1
20240903@182533.9064 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.9066 hu679usksii87q7400liur31cr Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240903@182533.9101 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.9104 hu679usksii87q7400liur31cr Query : select top 1 1 valor from td where td.ndoc = 39
20240903@182533.9136 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.9139 hu679usksii87q7400liur31cr 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')
20240903@182533.9169 hu679usksii87q7400liur31cr 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
20240903@182533.9204 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.9207 hu679usksii87q7400liur31cr Query : select top 1 ~inactivo valor from cl where no = '102212' and estab = 0 order by inactivo desc
20240903@182533.9344 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.9347 hu679usksii87q7400liur31cr Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240903@182533.9377 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.9380 hu679usksii87q7400liur31cr Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240903@182533.9425 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.9427 hu679usksii87q7400liur31cr Query : select szadrsstamp valor from szadrs where szadrsdesc='tomarel-soc.tecnica electricidade, lda.'
20240903@182533.9476 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182533.9479 hu679usksii87q7400liur31cr Query : select 1 valor from td where ndoc = 39
20240903@182533.9491 hu679usksii87q7400liur31cr Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240903@182533.9505 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.9521 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182533.9540 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.9557 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182533.9585 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.9598 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182533.9611 hu679usksii87q7400liur31cr Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182533.9688 hu679usksii87q7400liur31cr Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182533.9701 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.9716 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182533.9731 hu679usksii87q7400liur31cr Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d742168366d7468dea' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240903@182533.9918 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182533.9933 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182533.9965 hu679usksii87q7400liur31cr Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240903@182533.9977 hu679usksii87q7400liur31cr Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240903@182533.9988 hu679usksii87q7400liur31cr Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240903@182534.0000 hu679usksii87q7400liur31cr Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240903@182534.1200 hu679usksii87q7400liur31cr Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240903@182534.2400 hu679usksii87q7400liur31cr Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240903@182534.3700 hu679usksii87q7400liur31cr Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d742168366d7468dea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240903@182534.3730 hu679usksii87q7400liur31cr Query : select top 1 fno valor from wsftdata order by fno desc
20240903@182534.3970 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.4190 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182534.4420 hu679usksii87q7400liur31cr Query : select 'normal' from dummy
20240903@182534.4590 hu679usksii87q7400liur31cr Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d742168366d7468dea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',584,102212,0,'2024-09-03',39,'euro',0,0,2024 ,?,?)
20240903@182534.8090 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182534.8120 hu679usksii87q7400liur31cr Query : select st.usalote valor from st where st.ref = '324.681.00.01'
20240903@182534.8350 hu679usksii87q7400liur31cr 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.681.00.01'
20240903@182534.9910 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.1007 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.1035 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.1050 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.1059 hu679usksii87q7400liur31cr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182534.1071 hu679usksii87q7400liur31cr Query : select sestamp valor from se where ref ='324.681.00.01' and lote = 'r2400058200a'
20240903@182534.1086 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.1104 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.1117 hu679usksii87q7400liur31cr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d744635766d7468e1a','aut66d742168366d7468dea' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182534.1121 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.1136 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.1166 hu679usksii87q7400liur31cr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d744635766d7468e1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66d742168366d7468dea' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240903@182534.1758 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.1778 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.1804 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.1819 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.1828 hu679usksii87q7400liur31cr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182534.1841 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.1857 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.1869 hu679usksii87q7400liur31cr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d745999366d7468e2c','aut66d742168366d7468dea' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182534.1874 hu679usksii87q7400liur31cr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.1888 hu679usksii87q7400liur31cr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.1919 hu679usksii87q7400liur31cr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d745999366d7468e2c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d742168366d7468dea' ,0,0 ,2,23.00,20000,?,?,?)
20240903@182534.2185 hu679usksii87q7400liur31cr Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d742168366d7468dea','2405707','wait',39,'adm09112754980.682000002')
20240903@182534.2261 hu679usksii87q7400liur31cr Query : use flama_phc
20240903@182534.2265 hu679usksii87q7400liur31cr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240903@182534.2300 hu679usksii87q7400liur31cr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1806';
20240903@182534.2336 hu679usksii87q7400liur31cr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1806';
20240903@182534.2377 hu679usksii87q7400liur31cr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1806';
20240903@182534.2404 hu679usksii87q7400liur31cr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1806';
20240903@182534.2984 d805h2smbhtqrm8e8igmvoba28 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240903@182534.2995 d805h2smbhtqrm8e8igmvoba28 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240903@182534.3055 d805h2smbhtqrm8e8igmvoba28 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1807';
20240903@182534.3110 d805h2smbhtqrm8e8igmvoba28 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1807';
20240903@182534.3163 d805h2smbhtqrm8e8igmvoba28 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1807';
20240903@182534.3193 d805h2smbhtqrm8e8igmvoba28 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1807';
20240903@182534.3244 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.3247 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240903@182534.3342 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.3345 d805h2smbhtqrm8e8igmvoba28 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2288
20240903@182534.3437 d805h2smbhtqrm8e8igmvoba28 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'
20240903@182534.3610 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405708 and bi.ref ='324.1676.00.1' and bi.lordem =1
20240903@182534.3957 d805h2smbhtqrm8e8igmvoba28 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'
20240903@182534.3980 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405708 and bi.ref ='324.1676.00.1' and bi.lordem =2
20240903@182534.4288 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240903@182534.4448 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405708 and bi.ref ='324.1824.00.1' and bi.lordem =3
20240903@182534.4763 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.4767 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240903@182534.4818 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.4822 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 1 valor from td where td.ndoc = 39
20240903@182534.4855 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.4858 d805h2smbhtqrm8e8igmvoba28 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')
20240903@182534.4889 d805h2smbhtqrm8e8igmvoba28 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
20240903@182534.4926 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.4930 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 ~inactivo valor from cl where no = '102541' and estab = 0 order by inactivo desc
20240903@182534.6263 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.6268 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240903@182534.6303 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.6306 d805h2smbhtqrm8e8igmvoba28 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240903@182534.6353 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.6356 d805h2smbhtqrm8e8igmvoba28 Query : select szadrsstamp valor from szadrs where szadrsdesc='nelson miguel dias alves'
20240903@182534.6413 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.6416 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from td where ndoc = 39
20240903@182534.6455 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240903@182534.6471 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.6490 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182534.6512 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.6528 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182534.6561 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.6578 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182534.6592 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182534.6661 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182534.6677 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.6693 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182534.6710 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d743635566d7468ea0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240903@182534.6897 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.6916 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182534.6949 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240903@182534.6961 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240903@182534.6974 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240903@182534.6986 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240903@182534.6998 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240903@182534.7010 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240903@182534.7022 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d743635566d7468ea0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240903@182534.7438 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 fno valor from wsftdata order by fno desc
20240903@182534.7462 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.7479 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182534.7500 d805h2smbhtqrm8e8igmvoba28 Query : select 'normal' from dummy
20240903@182534.7514 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d743635566d7468ea0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',585,102541,0,'2024-09-03',39,'euro',0,0,2024 ,?,?)
20240903@182534.7841 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.7844 d805h2smbhtqrm8e8igmvoba28 Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20240903@182534.7867 d805h2smbhtqrm8e8igmvoba28 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'
20240903@182534.8048 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.8064 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.8088 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.8102 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.8110 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182534.8123 d805h2smbhtqrm8e8igmvoba28 Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20240903@182534.8138 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.8153 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.8165 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d748715866d7468ec6','aut66d743635566d7468ea0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182534.8169 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.8184 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.8211 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d748715866d7468ec6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66d743635566d7468ea0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240903@182534.8471 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.8474 d805h2smbhtqrm8e8igmvoba28 Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20240903@182534.8493 d805h2smbhtqrm8e8igmvoba28 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'
20240903@182534.8507 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.8523 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.8548 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.8564 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.8573 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182534.8585 d805h2smbhtqrm8e8igmvoba28 Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20240903@182534.8598 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.8613 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.8624 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d742638066d7468ed1','aut66d743635566d7468ea0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182534.8628 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.8643 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.8671 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d742638066d7468ed1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d743635566d7468ea0' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240903@182534.8913 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182534.8916 d805h2smbhtqrm8e8igmvoba28 Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240903@182534.8938 d805h2smbhtqrm8e8igmvoba28 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.1824.00.1'
20240903@182534.9088 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.9104 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.9128 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.9147 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.9155 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182534.9168 d805h2smbhtqrm8e8igmvoba28 Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240903@182534.9182 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.9197 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.9209 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d740499066d7468ee0','aut66d743635566d7468ea0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182534.9213 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.9228 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.9327 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d740499066d7468ee0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d743635566d7468ea0' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240903@182534.9761 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.9779 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.9805 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.9820 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.9829 d805h2smbhtqrm8e8igmvoba28 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182534.9841 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.9856 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182534.9868 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d747890666d7468ef0','aut66d743635566d7468ea0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182534.9872 d805h2smbhtqrm8e8igmvoba28 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182534.9887 d805h2smbhtqrm8e8igmvoba28 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182534.9914 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d747890666d7468ef0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d743635566d7468ea0' ,0,0 ,2,23.00,40000,?,?,?)
20240903@182535.1800 d805h2smbhtqrm8e8igmvoba28 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d743635566d7468ea0','2405708','wait',39,'adm09112754980.682000002')
20240903@182535.2600 d805h2smbhtqrm8e8igmvoba28 Query : use flama_phc
20240903@182535.2630 d805h2smbhtqrm8e8igmvoba28 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240903@182535.2970 d805h2smbhtqrm8e8igmvoba28 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1807';
20240903@182535.3330 d805h2smbhtqrm8e8igmvoba28 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1807';
20240903@182535.3730 d805h2smbhtqrm8e8igmvoba28 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1807';
20240903@182535.3990 d805h2smbhtqrm8e8igmvoba28 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1807';
20240903@182535.2177 4q8h3at2970o7ics6njl15lbqf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240903@182535.2188 4q8h3at2970o7ics6njl15lbqf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240903@182535.2276 4q8h3at2970o7ics6njl15lbqf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1808';
20240903@182535.2334 4q8h3at2970o7ics6njl15lbqf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1808';
20240903@182535.2385 4q8h3at2970o7ics6njl15lbqf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1808';
20240903@182535.2413 4q8h3at2970o7ics6njl15lbqf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1808';
20240903@182535.2470 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.2473 4q8h3at2970o7ics6njl15lbqf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240903@182535.2545 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.2548 4q8h3at2970o7ics6njl15lbqf Query : select no, estab,szadrsdesc from szadrs where u_coddest=1596
20240903@182535.2635 4q8h3at2970o7ics6njl15lbqf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240903@182535.2797 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405710 and bi.ref ='324.2066.00.1' and bi.lordem =1
20240903@182535.3141 4q8h3at2970o7ics6njl15lbqf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240903@182535.3162 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405710 and bi.ref ='324.2066.00.1' and bi.lordem =1
20240903@182535.3180 4q8h3at2970o7ics6njl15lbqf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240903@182535.3201 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405710 and bi.ref ='324.2066.00.1' and bi.lordem =2
20240903@182535.3519 4q8h3at2970o7ics6njl15lbqf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20240903@182535.3539 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405710 and bi.ref ='323.318.09.00' and bi.lordem =3
20240903@182535.3854 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.3857 4q8h3at2970o7ics6njl15lbqf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240903@182535.3890 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.3893 4q8h3at2970o7ics6njl15lbqf Query : select top 1 1 valor from td where td.ndoc = 39
20240903@182535.3925 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.3928 4q8h3at2970o7ics6njl15lbqf 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')
20240903@182535.3956 4q8h3at2970o7ics6njl15lbqf 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
20240903@182535.3991 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.3994 4q8h3at2970o7ics6njl15lbqf Query : select top 1 ~inactivo valor from cl where no = '102155' and estab = 0 order by inactivo desc
20240903@182535.4179 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.4181 4q8h3at2970o7ics6njl15lbqf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240903@182535.4216 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.4219 4q8h3at2970o7ics6njl15lbqf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240903@182535.4263 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.4266 4q8h3at2970o7ics6njl15lbqf Query : select szadrsstamp valor from szadrs where szadrsdesc='eternobom-electrodomÉsticos, lda. - crainha'
20240903@182535.4315 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.4318 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from td where ndoc = 39
20240903@182535.4329 4q8h3at2970o7ics6njl15lbqf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240903@182535.4342 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.4379 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182535.4396 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.4410 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182535.4439 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.4453 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182535.4465 4q8h3at2970o7ics6njl15lbqf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182535.4532 4q8h3at2970o7ics6njl15lbqf Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182535.4545 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.4558 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182535.4573 4q8h3at2970o7ics6njl15lbqf Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d746956566d7468f6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240903@182535.4750 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.4764 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182535.4793 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240903@182535.4804 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240903@182535.4817 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240903@182535.4827 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240903@182535.4838 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240903@182535.4849 4q8h3at2970o7ics6njl15lbqf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240903@182535.4860 4q8h3at2970o7ics6njl15lbqf Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d746956566d7468f6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240903@182535.5104 4q8h3at2970o7ics6njl15lbqf Query : select top 1 fno valor from wsftdata order by fno desc
20240903@182535.5126 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.5140 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182535.5161 4q8h3at2970o7ics6njl15lbqf Query : select 'normal' from dummy
20240903@182535.5175 4q8h3at2970o7ics6njl15lbqf Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d746956566d7468f6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',586,102155,0,'2024-09-03',39,'euro',0,0,2024 ,?,?)
20240903@182535.5536 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.5540 4q8h3at2970o7ics6njl15lbqf Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20240903@182535.5561 4q8h3at2970o7ics6njl15lbqf 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.2066.00.1'
20240903@182535.5711 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.5726 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.5749 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.5763 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.5771 4q8h3at2970o7ics6njl15lbqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182535.5793 4q8h3at2970o7ics6njl15lbqf Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20240903@182535.5806 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.5820 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.5831 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d743282166d7468f8d','aut66d746956566d7468f6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182535.5835 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.5848 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.5874 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d743282166d7468f8d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66d746956566d7468f6d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240903@182535.6146 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.6161 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.6184 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.6197 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.6205 4q8h3at2970o7ics6njl15lbqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182535.6217 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.6231 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.6242 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d742100266d7468f97','aut66d746956566d7468f6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182535.6246 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.6261 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.6290 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d742100266d7468f97',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d746956566d7468f6d' ,0,0 ,2,23.00,20000,?,?,?)
20240903@182535.6565 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.6572 4q8h3at2970o7ics6njl15lbqf Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20240903@182535.6591 4q8h3at2970o7ics6njl15lbqf 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.2066.00.1'
20240903@182535.6604 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.6620 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.6643 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.6657 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.6666 4q8h3at2970o7ics6njl15lbqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182535.6678 4q8h3at2970o7ics6njl15lbqf Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20240903@182535.6690 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.6704 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.6716 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d741956566d7468fa3','aut66d746956566d7468f6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182535.6720 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.6734 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.6760 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d741956566d7468fa3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66d746956566d7468f6d' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240903@182535.7049 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.7069 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.7098 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.7119 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.7130 4q8h3at2970o7ics6njl15lbqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182535.7146 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.7163 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.7176 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d742093066d7468fae','aut66d746956566d7468f6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182535.7181 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.7197 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.7227 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d742093066d7468fae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d746956566d7468f6d' ,0,0 ,2,23.00,50000,?,?,?)
20240903@182535.7535 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.7539 4q8h3at2970o7ics6njl15lbqf Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20240903@182535.7558 4q8h3at2970o7ics6njl15lbqf 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.2066.00.1'
20240903@182535.7571 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.7588 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.7616 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.7631 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.7639 4q8h3at2970o7ics6njl15lbqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182535.7651 4q8h3at2970o7ics6njl15lbqf Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20240903@182535.7663 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.7676 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.7687 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d745454266d7468fbb','aut66d746956566d7468f6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182535.7692 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.7705 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.7733 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d745454266d7468fbb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66d746956566d7468f6d' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240903@182535.8023 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.8040 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.8065 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.8079 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.8088 4q8h3at2970o7ics6njl15lbqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182535.8100 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.8114 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.8126 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d742553366d7468fc5','aut66d746956566d7468f6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182535.8130 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.8144 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.8172 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d742553366d7468fc5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d746956566d7468f6d' ,0,0 ,2,23.00,80000,?,?,?)
20240903@182535.8421 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.8424 4q8h3at2970o7ics6njl15lbqf Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20240903@182535.8443 4q8h3at2970o7ics6njl15lbqf 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 = '323.318.09.00'
20240903@182535.8457 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.8472 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.8497 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.8510 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.8519 4q8h3at2970o7ics6njl15lbqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182535.8530 4q8h3at2970o7ics6njl15lbqf Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2400053200a'
20240903@182535.8542 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.8556 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182535.8567 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d743141166d7468fd0','aut66d746956566d7468f6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182535.8572 4q8h3at2970o7ics6njl15lbqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182535.8587 4q8h3at2970o7ics6njl15lbqf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182535.8614 4q8h3at2970o7ics6njl15lbqf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d743141166d7468fd0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66d746956566d7468f6d' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240903@182535.8899 4q8h3at2970o7ics6njl15lbqf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d746956566d7468f6d','2405710','wait',39,'adm09112754980.682000002')
20240903@182535.8977 4q8h3at2970o7ics6njl15lbqf Query : use flama_phc
20240903@182535.8980 4q8h3at2970o7ics6njl15lbqf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240903@182535.9013 4q8h3at2970o7ics6njl15lbqf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1808';
20240903@182535.9048 4q8h3at2970o7ics6njl15lbqf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1808';
20240903@182535.9092 4q8h3at2970o7ics6njl15lbqf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1808';
20240903@182535.9119 4q8h3at2970o7ics6njl15lbqf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1808';
20240903@182535.9794 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240903@182535.9806 vp25c1jrrk1ghi6m5fctg08jrv Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240903@182535.9866 vp25c1jrrk1ghi6m5fctg08jrv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1809';
20240903@182535.9930 vp25c1jrrk1ghi6m5fctg08jrv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1809';
20240903@182535.9986 vp25c1jrrk1ghi6m5fctg08jrv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1809';
20240903@182536.1500 vp25c1jrrk1ghi6m5fctg08jrv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1809';
20240903@182536.6400 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.6700 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240903@182536.1370 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.1390 vp25c1jrrk1ghi6m5fctg08jrv Query : select no, estab,szadrsdesc from szadrs where u_coddest=7117
20240903@182536.2570 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240903@182536.2780 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405711 and bi.ref ='324.2066.00.1' and bi.lordem =1
20240903@182536.6300 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240903@182536.6520 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405711 and bi.ref ='324.2066.00.1' and bi.lordem =1
20240903@182536.6700 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240903@182536.6890 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405711 and bi.ref ='324.2066.00.1' and bi.lordem =2
20240903@182536.1008 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20240903@182536.1028 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405711 and bi.ref ='323.318.09.00' and bi.lordem =3
20240903@182536.1708 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.1711 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240903@182536.1745 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.1748 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 1 valor from td where td.ndoc = 39
20240903@182536.1781 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.1784 vp25c1jrrk1ghi6m5fctg08jrv 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')
20240903@182536.1813 vp25c1jrrk1ghi6m5fctg08jrv 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
20240903@182536.1848 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.1850 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 ~inactivo valor from cl where no = '102155' and estab = 0 order by inactivo desc
20240903@182536.1882 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.1885 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240903@182536.1914 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.1916 vp25c1jrrk1ghi6m5fctg08jrv Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240903@182536.1955 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.1958 vp25c1jrrk1ghi6m5fctg08jrv Query : select szadrsstamp valor from szadrs where szadrsdesc='eternobom - loja leiria'
20240903@182536.2004 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.2007 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from td where ndoc = 39
20240903@182536.2019 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240903@182536.2042 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.2057 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182536.2076 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.2089 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182536.2116 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.2129 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182536.2141 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182536.2207 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182536.2219 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.2232 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182536.2247 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d747220866d7469034' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240903@182536.2432 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.2448 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182536.2481 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240903@182536.2492 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240903@182536.2505 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240903@182536.2517 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240903@182536.2530 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240903@182536.2542 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240903@182536.2554 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d747220866d7469034',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240903@182536.2854 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 fno valor from wsftdata order by fno desc
20240903@182536.2879 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.2895 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182536.2918 vp25c1jrrk1ghi6m5fctg08jrv Query : select 'normal' from dummy
20240903@182536.2932 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d747220866d7469034',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',587,102155,0,'2024-09-03',39,'euro',0,0,2024 ,?,?)
20240903@182536.3227 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.3230 vp25c1jrrk1ghi6m5fctg08jrv Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20240903@182536.3251 vp25c1jrrk1ghi6m5fctg08jrv 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.2066.00.1'
20240903@182536.3265 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.3281 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.3305 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.3319 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.3327 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182536.3338 vp25c1jrrk1ghi6m5fctg08jrv Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20240903@182536.3350 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.3363 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.3374 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d744084566d7469051','aut66d747220866d7469034' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182536.3378 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.3391 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.3420 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d744084566d7469051',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66d747220866d7469034' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240903@182536.3684 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.3700 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.3724 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.3738 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.3747 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182536.3759 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.3773 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.3786 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d741729466d746905b','aut66d747220866d7469034' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182536.3790 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.3805 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.3832 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d741729466d746905b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d747220866d7469034' ,0,0 ,2,23.00,20000,?,?,?)
20240903@182536.4078 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.4122 vp25c1jrrk1ghi6m5fctg08jrv Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20240903@182536.4438 vp25c1jrrk1ghi6m5fctg08jrv 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.2066.00.1'
20240903@182536.4454 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.4475 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.4499 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.4515 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.4524 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182536.4536 vp25c1jrrk1ghi6m5fctg08jrv Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20240903@182536.4548 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.4562 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.4573 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d743476266d746906f','aut66d747220866d7469034' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182536.4578 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.4592 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.4618 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d743476266d746906f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66d747220866d7469034' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240903@182536.4977 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.4993 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.5018 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.5033 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.5041 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182536.5053 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.5067 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.5078 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d747379366d746907b','aut66d747220866d7469034' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182536.5082 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.5095 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.5122 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d747379366d746907b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d747220866d7469034' ,0,0 ,2,23.00,50000,?,?,?)
20240903@182536.5393 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.5396 vp25c1jrrk1ghi6m5fctg08jrv Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20240903@182536.5416 vp25c1jrrk1ghi6m5fctg08jrv 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.2066.00.1'
20240903@182536.5429 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.5443 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.5468 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.5482 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.5490 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182536.5502 vp25c1jrrk1ghi6m5fctg08jrv Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20240903@182536.5514 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.5527 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.5538 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d748157066d7469086','aut66d747220866d7469034' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182536.5542 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.5556 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.5582 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d748157066d7469086',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66d747220866d7469034' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240903@182536.6832 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.6868 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.6892 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.6906 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.6914 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182536.6926 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.6940 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.6952 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d745788166d74690a9','aut66d747220866d7469034' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182536.6957 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.6971 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.6996 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d745788166d74690a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d747220866d7469034' ,0,0 ,2,23.00,80000,?,?,?)
20240903@182536.7263 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.7266 vp25c1jrrk1ghi6m5fctg08jrv Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20240903@182536.7286 vp25c1jrrk1ghi6m5fctg08jrv 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 = '323.318.09.00'
20240903@182536.7302 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.7318 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.7343 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.7358 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.7370 vp25c1jrrk1ghi6m5fctg08jrv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240903@182536.7405 vp25c1jrrk1ghi6m5fctg08jrv Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2400053200a'
20240903@182536.7420 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.7436 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240903@182536.7448 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d744534966d74690b5','aut66d747220866d7469034' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240903@182536.7453 vp25c1jrrk1ghi6m5fctg08jrv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182536.7467 vp25c1jrrk1ghi6m5fctg08jrv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240903@182536.7496 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d744534966d74690b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66d747220866d7469034' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240903@182536.7788 vp25c1jrrk1ghi6m5fctg08jrv Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d747220866d7469034','2405711','wait',39,'adm09112754980.682000002')
20240903@182536.7860 vp25c1jrrk1ghi6m5fctg08jrv Query : use flama_phc
20240903@182536.7863 vp25c1jrrk1ghi6m5fctg08jrv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240903@182536.7894 vp25c1jrrk1ghi6m5fctg08jrv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1809';
20240903@182536.7934 vp25c1jrrk1ghi6m5fctg08jrv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1809';
20240903@182536.7978 vp25c1jrrk1ghi6m5fctg08jrv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1809';
20240903@182536.8010 vp25c1jrrk1ghi6m5fctg08jrv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1809';
20240903@182536.8649 32on249tqjn9rknbb5m29tdstf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240903@182536.8662 32on249tqjn9rknbb5m29tdstf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240903@182536.8718 32on249tqjn9rknbb5m29tdstf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1810';
20240903@182536.8816 32on249tqjn9rknbb5m29tdstf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1810';
20240903@182536.8867 32on249tqjn9rknbb5m29tdstf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1810';
20240903@182536.8894 32on249tqjn9rknbb5m29tdstf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1810';
20240903@182536.8944 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182536.8948 32on249tqjn9rknbb5m29tdstf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240903@182536.9019 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182536.9022 32on249tqjn9rknbb5m29tdstf Query : select no, estab,szadrsdesc from szadrs where u_coddest=5084
20240903@182536.9131 32on249tqjn9rknbb5m29tdstf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240903@182536.9156 32on249tqjn9rknbb5m29tdstf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405712 and bi.ref ='324.2066.00.1' and bi.lordem =1
20240903@182536.9516 32on249tqjn9rknbb5m29tdstf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240903@182536.9541 32on249tqjn9rknbb5m29tdstf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405712 and bi.ref ='324.2066.00.1' and bi.lordem =2
20240903@182536.9882 32on249tqjn9rknbb5m29tdstf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20240903@182536.9906 32on249tqjn9rknbb5m29tdstf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405712 and bi.ref ='323.318.09.00' and bi.lordem =3
20240903@182537.2400 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182537.2430 32on249tqjn9rknbb5m29tdstf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240903@182537.2780 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182537.2810 32on249tqjn9rknbb5m29tdstf Query : select top 1 1 valor from td where td.ndoc = 39
20240903@182537.3130 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182537.3160 32on249tqjn9rknbb5m29tdstf 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')
20240903@182537.3440 32on249tqjn9rknbb5m29tdstf 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
20240903@182537.3770 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182537.3800 32on249tqjn9rknbb5m29tdstf Query : select top 1 ~inactivo valor from cl where no = '102155' and estab = 0 order by inactivo desc
20240903@182537.4160 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182537.4200 32on249tqjn9rknbb5m29tdstf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240903@182537.4560 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182537.4580 32on249tqjn9rknbb5m29tdstf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240903@182537.4970 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182537.5000 32on249tqjn9rknbb5m29tdstf Query : select szadrsstamp valor from szadrs where szadrsdesc='eternobom-electrodomÉsticos, lda.- ourem( novo)'
20240903@182537.5450 32on249tqjn9rknbb5m29tdstf Query : use flama_phc
20240903@182537.5480 32on249tqjn9rknbb5m29tdstf Query : select 1 valor from td where ndoc = 39
20240903@182537.5600 32on249tqjn9rknbb5m29tdstf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240903@182537.5730 32on249tqjn9rknbb5m29tdstf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182537.5900 32on249tqjn9rknbb5m29tdstf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240903@182537.6090 32on249tqjn9rknbb5m29tdstf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182537.6230 32on249tqjn9rknbb5m29tdstf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182537.6500 32on249tqjn9rknbb5m29tdstf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182537.6640 32on249tqjn9rknbb5m29tdstf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182537.6760 32on249tqjn9rknbb5m29tdstf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182537.7440 32on249tqjn9rknbb5m29tdstf Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240903@182537.7570 32on249tqjn9rknbb5m29tdstf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182537.7710 32on249tqjn9rknbb5m29tdstf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240903@182537.7860 32on249tqjn9rknbb5m29tdstf Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d745434066d7469110' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240903@182537.9760 32on249tqjn9rknbb5m29tdstf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240903@182537.9930 32on249tqjn9rknbb5m29tdstf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240903@182537.1030 32on249tqjn9rknbb5m29tdstf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240903@182537.1044 32on249tqjn9rknbb5m29tdstf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240903@182537.1058 32on249tqjn9rknbb5m29tdstf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
