20240904@183849.7368 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183849.7389 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183849.7406 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183849.7482 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183849.7499 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183849.7518 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183849.7539 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d898636266d89b29b4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240904@183849.7813 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183849.7837 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183849.7881 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240904@183849.7903 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240904@183849.7918 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240904@183849.7933 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240904@183849.7946 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240904@183849.7995 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240904@183849.8009 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d898636266d89b29b4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240904@183849.8410 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 fno valor from wsftdata order by fno desc
20240904@183849.8765 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183849.8789 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183849.8825 hhs58ut3618s4jo7gkeg49ulpi Query : select 'normal' from dummy
20240904@183849.8849 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d898636266d89b29b4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',611,100810,0,'2024-09-04',39,'euro',0,0,2024 ,?,?)
20240904@183849.9220 hhs58ut3618s4jo7gkeg49ulpi Query : use flama_phc
20240904@183849.9227 hhs58ut3618s4jo7gkeg49ulpi Query : select st.usalote valor from st where st.ref = '324.1684.00.1'
20240904@183849.9253 hhs58ut3618s4jo7gkeg49ulpi 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.1684.00.1'
20240904@183849.9532 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183849.9552 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183849.9583 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183849.9600 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183849.9611 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183849.9626 hhs58ut3618s4jo7gkeg49ulpi Query : select sestamp valor from se where ref ='324.1684.00.1' and lote = 'r2301217200a'
20240904@183849.9644 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183849.9662 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183849.9675 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d890706466d89b29eb','aut66d898636266d89b29b4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183849.9681 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183849.9697 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183849.9730 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d890706466d89b29eb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d898636266d89b29b4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240904@183850.2210 hhs58ut3618s4jo7gkeg49ulpi Query : use flama_phc
20240904@183850.2250 hhs58ut3618s4jo7gkeg49ulpi Query : select st.usalote valor from st where st.ref = '324.698.00.01'
20240904@183850.2500 hhs58ut3618s4jo7gkeg49ulpi 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.698.00.01'
20240904@183850.4420 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.4680 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.5010 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.5210 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.5330 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183850.5490 hhs58ut3618s4jo7gkeg49ulpi Query : select sestamp valor from se where ref ='324.698.00.01' and lote = 'r2301182200a'
20240904@183850.5790 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.6040 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.6400 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d893395066d89b2a0e','aut66d898636266d89b29b4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183850.6450 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.6640 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.7000 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d893395066d89b2a0e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d898636266d89b29b4' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240904@183850.1042 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.1065 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.1101 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.1120 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.1131 hhs58ut3618s4jo7gkeg49ulpi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183850.1152 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.1172 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.1211 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d895405366d89b2a1c','aut66d898636266d89b29b4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183850.1217 hhs58ut3618s4jo7gkeg49ulpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.1242 hhs58ut3618s4jo7gkeg49ulpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.1277 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d895405366d89b2a1c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d898636266d89b29b4' ,0,0 ,2,23.00,30000,?,?,?)
20240904@183850.1621 hhs58ut3618s4jo7gkeg49ulpi Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d898636266d89b29b4','2405742','wait',39,'adm09112754980.682000002')
20240904@183850.1711 hhs58ut3618s4jo7gkeg49ulpi Query : use flama_phc
20240904@183850.1736 hhs58ut3618s4jo7gkeg49ulpi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240904@183850.1772 hhs58ut3618s4jo7gkeg49ulpi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1836';
20240904@183850.1815 hhs58ut3618s4jo7gkeg49ulpi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1836';
20240904@183850.1858 hhs58ut3618s4jo7gkeg49ulpi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1836';
20240904@183850.1888 hhs58ut3618s4jo7gkeg49ulpi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1836';
20240904@183850.2451 apt7c6g50c8fu6r38g1s8b4pun Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240904@183850.2464 apt7c6g50c8fu6r38g1s8b4pun Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240904@183850.2520 apt7c6g50c8fu6r38g1s8b4pun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1837';
20240904@183850.2650 apt7c6g50c8fu6r38g1s8b4pun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1837';
20240904@183850.2704 apt7c6g50c8fu6r38g1s8b4pun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1837';
20240904@183850.2749 apt7c6g50c8fu6r38g1s8b4pun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1837';
20240904@183850.2796 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.2800 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240904@183850.2863 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.2866 apt7c6g50c8fu6r38g1s8b4pun Query : select no, estab,szadrsdesc from szadrs where u_coddest=1260
20240904@183850.2970 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240904@183850.3155 apt7c6g50c8fu6r38g1s8b4pun 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 = 2405743 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240904@183850.3555 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240904@183850.3953 apt7c6g50c8fu6r38g1s8b4pun 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 = 2405743 and bi.ref ='304.421.00.04' and bi.lordem =2
20240904@183850.4343 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.4347 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240904@183850.4390 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.4403 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 1 valor from td where td.ndoc = 39
20240904@183850.4444 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.4448 apt7c6g50c8fu6r38g1s8b4pun 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')
20240904@183850.4482 apt7c6g50c8fu6r38g1s8b4pun 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
20240904@183850.4549 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.4556 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 ~inactivo valor from cl where no = '101446' and estab = 0 order by inactivo desc
20240904@183850.4715 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.4719 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240904@183850.4790 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.4795 apt7c6g50c8fu6r38g1s8b4pun Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240904@183850.4842 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.4845 apt7c6g50c8fu6r38g1s8b4pun Query : select szadrsstamp valor from szadrs where szadrsdesc='arnaldo martins domingos'
20240904@183850.4897 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.4901 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from td where ndoc = 39
20240904@183850.4916 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240904@183850.4951 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.4974 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183850.4997 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.5016 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183850.5050 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.5068 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183850.5086 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183850.5158 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183850.5174 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.5194 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183850.5212 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d897215566d89b2a7c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240904@183850.5437 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.5458 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183850.5498 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240904@183850.5515 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240904@183850.5529 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240904@183850.5547 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240904@183850.5562 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240904@183850.5578 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240904@183850.5592 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d897215566d89b2a7c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240904@183850.5896 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 fno valor from wsftdata order by fno desc
20240904@183850.5928 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.5946 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183850.5972 apt7c6g50c8fu6r38g1s8b4pun Query : select 'normal' from dummy
20240904@183850.5992 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d897215566d89b2a7c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',612,101446,0,'2024-09-04',39,'euro',0,0,2024 ,?,?)
20240904@183850.6348 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.6352 apt7c6g50c8fu6r38g1s8b4pun Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240904@183850.6381 apt7c6g50c8fu6r38g1s8b4pun 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.4970.00.1'
20240904@183850.6575 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.6594 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.6628 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.6647 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.6658 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183850.6674 apt7c6g50c8fu6r38g1s8b4pun Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240904@183850.6700 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.6717 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.6732 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d896311166d89b2aa3','aut66d897215566d89b2a7c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183850.6737 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.6752 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.6786 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d896311166d89b2aa3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66d897215566d89b2a7c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240904@183850.7143 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.7148 apt7c6g50c8fu6r38g1s8b4pun Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240904@183850.7179 apt7c6g50c8fu6r38g1s8b4pun 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 = '304.421.00.04'
20240904@183850.7386 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.7411 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.7444 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.7464 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.7474 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183850.7488 apt7c6g50c8fu6r38g1s8b4pun Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240904@183850.7506 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.7530 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.7548 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d892829966d89b2ab7','aut66d897215566d89b2a7c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183850.7555 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.7579 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.7617 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d892829966d89b2ab7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66d897215566d89b2a7c' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240904@183850.7976 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.7999 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.8036 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.8056 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.8075 apt7c6g50c8fu6r38g1s8b4pun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183850.8090 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.8114 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183850.8128 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d891578066d89b2ac5','aut66d897215566d89b2a7c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183850.8134 apt7c6g50c8fu6r38g1s8b4pun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183850.8169 apt7c6g50c8fu6r38g1s8b4pun Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183850.8203 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d891578066d89b2ac5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d897215566d89b2a7c' ,0,0 ,2,23.00,30000,?,?,?)
20240904@183850.8538 apt7c6g50c8fu6r38g1s8b4pun Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d897215566d89b2a7c','2405743','wait',39,'adm09112754980.682000002')
20240904@183850.8774 apt7c6g50c8fu6r38g1s8b4pun Query : use flama_phc
20240904@183850.8778 apt7c6g50c8fu6r38g1s8b4pun Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240904@183850.8811 apt7c6g50c8fu6r38g1s8b4pun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1837';
20240904@183850.8849 apt7c6g50c8fu6r38g1s8b4pun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1837';
20240904@183850.8890 apt7c6g50c8fu6r38g1s8b4pun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1837';
20240904@183850.8924 apt7c6g50c8fu6r38g1s8b4pun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1837';
20240904@183850.9486 2r50c6fhqpurkmgp7rci0oct2k Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240904@183850.9498 2r50c6fhqpurkmgp7rci0oct2k Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240904@183850.9557 2r50c6fhqpurkmgp7rci0oct2k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1838';
20240904@183850.9648 2r50c6fhqpurkmgp7rci0oct2k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1838';
20240904@183850.9703 2r50c6fhqpurkmgp7rci0oct2k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1838';
20240904@183850.9735 2r50c6fhqpurkmgp7rci0oct2k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1838';
20240904@183850.9788 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183850.9801 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240904@183850.9943 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183850.9947 2r50c6fhqpurkmgp7rci0oct2k Query : select no, estab,szadrsdesc from szadrs where u_coddest=8817
20240904@183851.5500 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1685.00.1'
20240904@183851.2340 2r50c6fhqpurkmgp7rci0oct2k 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 = 2405744 and bi.ref ='324.1685.00.1' and bi.lordem =1
20240904@183851.5970 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.6010 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240904@183851.6400 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.6440 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 1 valor from td where td.ndoc = 39
20240904@183851.6840 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.6900 2r50c6fhqpurkmgp7rci0oct2k 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')
20240904@183851.7240 2r50c6fhqpurkmgp7rci0oct2k 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
20240904@183851.7650 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.7690 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 ~inactivo valor from cl where no = '102939' and estab = 0 order by inactivo desc
20240904@183851.9430 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.9470 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240904@183851.1069 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.1074 2r50c6fhqpurkmgp7rci0oct2k Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240904@183851.1209 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.1213 2r50c6fhqpurkmgp7rci0oct2k Query : select szadrsstamp valor from szadrs where szadrsdesc='rui manuel dias alves'
20240904@183851.1300 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.1304 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from td where ndoc = 39
20240904@183851.1322 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240904@183851.1344 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.1403 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183851.1552 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.1582 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183851.1629 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.1653 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183851.1671 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183851.1859 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183851.1920 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.1943 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183851.1960 2r50c6fhqpurkmgp7rci0oct2k Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d895136966d89b2b28' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240904@183851.2159 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.2263 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183851.2342 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240904@183851.2361 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240904@183851.2393 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240904@183851.2462 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240904@183851.2537 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240904@183851.2578 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240904@183851.2622 2r50c6fhqpurkmgp7rci0oct2k Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d895136966d89b2b28',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240904@183851.2990 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 fno valor from wsftdata order by fno desc
20240904@183851.3045 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.3123 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183851.3216 2r50c6fhqpurkmgp7rci0oct2k Query : select 'normal' from dummy
20240904@183851.3243 2r50c6fhqpurkmgp7rci0oct2k Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d895136966d89b2b28',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',613,102939,0,'2024-09-04',39,'euro',0,0,2024 ,?,?)
20240904@183851.3686 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.3695 2r50c6fhqpurkmgp7rci0oct2k Query : select st.usalote valor from st where st.ref = '324.1685.00.1'
20240904@183851.3783 2r50c6fhqpurkmgp7rci0oct2k 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.1685.00.1'
20240904@183851.3990 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.4039 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183851.4113 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.4231 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183851.4242 2r50c6fhqpurkmgp7rci0oct2k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183851.4295 2r50c6fhqpurkmgp7rci0oct2k Query : select sestamp valor from se where ref ='324.1685.00.1' and lote = 'r2400173100a'
20240904@183851.4409 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.4571 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183851.5603 2r50c6fhqpurkmgp7rci0oct2k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d893637366d89b2b6b','aut66d895136966d89b2b28' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183851.5609 2r50c6fhqpurkmgp7rci0oct2k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183851.5714 2r50c6fhqpurkmgp7rci0oct2k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183851.6109 2r50c6fhqpurkmgp7rci0oct2k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d893637366d89b2b6b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66d895136966d89b2b28' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240904@183851.6428 2r50c6fhqpurkmgp7rci0oct2k Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d895136966d89b2b28','2405744','wait',39,'adm09112754980.682000002')
20240904@183851.6531 2r50c6fhqpurkmgp7rci0oct2k Query : use flama_phc
20240904@183851.6535 2r50c6fhqpurkmgp7rci0oct2k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240904@183851.6585 2r50c6fhqpurkmgp7rci0oct2k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1838';
20240904@183851.6711 2r50c6fhqpurkmgp7rci0oct2k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1838';
20240904@183851.6794 2r50c6fhqpurkmgp7rci0oct2k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1838';
20240904@183851.6896 2r50c6fhqpurkmgp7rci0oct2k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1838';
20240904@183851.7863 rq58m7v1j4s65themp39hhqa1v Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240904@183851.7875 rq58m7v1j4s65themp39hhqa1v Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240904@183851.7961 rq58m7v1j4s65themp39hhqa1v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1839';
20240904@183851.8061 rq58m7v1j4s65themp39hhqa1v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1839';
20240904@183851.8127 rq58m7v1j4s65themp39hhqa1v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1839';
20240904@183851.8162 rq58m7v1j4s65themp39hhqa1v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1839';
20240904@183851.8213 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.8217 rq58m7v1j4s65themp39hhqa1v Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240904@183851.8437 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.8441 rq58m7v1j4s65themp39hhqa1v Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240904@183851.8490 rq58m7v1j4s65themp39hhqa1v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1690.00.1'
20240904@183851.8747 rq58m7v1j4s65themp39hhqa1v 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 = 2405745 and bi.ref ='324.1690.00.1' and bi.lordem =1
20240904@183851.9273 rq58m7v1j4s65themp39hhqa1v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1690.00.1'
20240904@183851.9329 rq58m7v1j4s65themp39hhqa1v 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 = 2405745 and bi.ref ='324.1690.00.1' and bi.lordem =1
20240904@183851.9352 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.9357 rq58m7v1j4s65themp39hhqa1v Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240904@183851.9396 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.9401 rq58m7v1j4s65themp39hhqa1v Query : select top 1 1 valor from td where td.ndoc = 39
20240904@183851.9479 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.9483 rq58m7v1j4s65themp39hhqa1v 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')
20240904@183851.9621 rq58m7v1j4s65themp39hhqa1v 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
20240904@183851.9662 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.9667 rq58m7v1j4s65themp39hhqa1v Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240904@183851.9704 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.9709 rq58m7v1j4s65themp39hhqa1v Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240904@183851.9796 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.9803 rq58m7v1j4s65themp39hhqa1v Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240904@183851.9909 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.9915 rq58m7v1j4s65themp39hhqa1v Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240904@183851.9984 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183851.9989 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from td where ndoc = 39
20240904@183852.7000 rq58m7v1j4s65themp39hhqa1v Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240904@183852.3600 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.1330 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183852.2190 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.2420 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183852.2880 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.3070 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183852.3290 rq58m7v1j4s65themp39hhqa1v Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183852.4630 rq58m7v1j4s65themp39hhqa1v Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183852.5630 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.6080 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183852.6320 rq58m7v1j4s65themp39hhqa1v Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d896279866d89b2c08' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240904@183852.8840 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.9190 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183852.9690 rq58m7v1j4s65themp39hhqa1v Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240904@183852.1002 rq58m7v1j4s65themp39hhqa1v Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240904@183852.1120 rq58m7v1j4s65themp39hhqa1v Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240904@183852.1187 rq58m7v1j4s65themp39hhqa1v Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240904@183852.1229 rq58m7v1j4s65themp39hhqa1v Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240904@183852.1244 rq58m7v1j4s65themp39hhqa1v Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240904@183852.1263 rq58m7v1j4s65themp39hhqa1v Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d896279866d89b2c08',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240904@183852.1568 rq58m7v1j4s65themp39hhqa1v Query : select top 1 fno valor from wsftdata order by fno desc
20240904@183852.1615 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.1637 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183852.1686 rq58m7v1j4s65themp39hhqa1v Query : select 'normal' from dummy
20240904@183852.1745 rq58m7v1j4s65themp39hhqa1v Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d896279866d89b2c08',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',614,100810,0,'2024-09-04',39,'euro',0,0,2024 ,?,?)
20240904@183852.2128 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183852.2142 rq58m7v1j4s65themp39hhqa1v Query : select st.usalote valor from st where st.ref = '324.1690.00.1'
20240904@183852.2177 rq58m7v1j4s65themp39hhqa1v 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.1690.00.1'
20240904@183852.2351 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.2376 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183852.2543 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.2592 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183852.2605 rq58m7v1j4s65themp39hhqa1v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183852.2622 rq58m7v1j4s65themp39hhqa1v Query : select sestamp valor from se where ref ='324.1690.00.1' and lote = 'r2100755200a'
20240904@183852.2655 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.2685 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183852.2717 rq58m7v1j4s65themp39hhqa1v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d899078766d89b2c40','aut66d896279866d89b2c08' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183852.2722 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.2742 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183852.2780 rq58m7v1j4s65themp39hhqa1v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d899078766d89b2c40',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66d896279866d89b2c08' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240904@183852.3101 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.3124 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183852.3151 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.3177 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183852.3187 rq58m7v1j4s65themp39hhqa1v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183852.3201 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.3224 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183852.3240 rq58m7v1j4s65themp39hhqa1v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d891022266d89b2c4e','aut66d896279866d89b2c08' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183852.3246 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.3265 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183852.3324 rq58m7v1j4s65themp39hhqa1v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d891022266d89b2c4e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d896279866d89b2c08' ,0,0 ,2,23.00,20000,?,?,?)
20240904@183852.3617 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183852.3622 rq58m7v1j4s65themp39hhqa1v Query : select st.usalote valor from st where st.ref = '324.1690.00.1'
20240904@183852.3661 rq58m7v1j4s65themp39hhqa1v 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.1690.00.1'
20240904@183852.3684 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.3708 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183852.3747 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.3803 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183852.3845 rq58m7v1j4s65themp39hhqa1v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183852.3867 rq58m7v1j4s65themp39hhqa1v Query : select sestamp valor from se where ref ='324.1690.00.1' and lote = 'r2100755200a'
20240904@183852.3881 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.3908 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183852.3925 rq58m7v1j4s65themp39hhqa1v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d894700866d89b2c5e','aut66d896279866d89b2c08' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183852.3931 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.3949 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183852.4000 rq58m7v1j4s65themp39hhqa1v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d894700866d89b2c5e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut66d896279866d89b2c08' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240904@183852.4312 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.4336 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183852.4382 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.4400 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183852.4410 rq58m7v1j4s65themp39hhqa1v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183852.4426 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.4447 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183852.4461 rq58m7v1j4s65themp39hhqa1v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d896449966d89b2c6c','aut66d896279866d89b2c08' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183852.4468 rq58m7v1j4s65themp39hhqa1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.4484 rq58m7v1j4s65themp39hhqa1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183852.4542 rq58m7v1j4s65themp39hhqa1v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d896449966d89b2c6c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d896279866d89b2c08' ,0,0 ,2,23.00,50000,?,?,?)
20240904@183852.4854 rq58m7v1j4s65themp39hhqa1v Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d896279866d89b2c08','2405745','wait',39,'adm09112754980.682000002')
20240904@183852.4948 rq58m7v1j4s65themp39hhqa1v Query : use flama_phc
20240904@183852.4955 rq58m7v1j4s65themp39hhqa1v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240904@183852.4990 rq58m7v1j4s65themp39hhqa1v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1839';
20240904@183852.5079 rq58m7v1j4s65themp39hhqa1v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1839';
20240904@183852.5148 rq58m7v1j4s65themp39hhqa1v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1839';
20240904@183852.5196 rq58m7v1j4s65themp39hhqa1v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1839';
20240904@183852.5848 m5sm5ml8an374rpu7gsjqd0aos Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240904@183852.5861 m5sm5ml8an374rpu7gsjqd0aos Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240904@183852.5926 m5sm5ml8an374rpu7gsjqd0aos Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1840';
20240904@183852.6015 m5sm5ml8an374rpu7gsjqd0aos Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1840';
20240904@183852.6160 m5sm5ml8an374rpu7gsjqd0aos Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1840';
20240904@183852.6244 m5sm5ml8an374rpu7gsjqd0aos Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1840';
20240904@183852.6322 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.6326 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240904@183852.6545 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.6556 m5sm5ml8an374rpu7gsjqd0aos Query : select no, estab,szadrsdesc from szadrs where u_coddest=5546
20240904@183852.6693 m5sm5ml8an374rpu7gsjqd0aos 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'
20240904@183852.6910 m5sm5ml8an374rpu7gsjqd0aos 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 = 2405746 and bi.ref ='324.1824.00.1' and bi.lordem =1
20240904@183852.7278 m5sm5ml8an374rpu7gsjqd0aos 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'
20240904@183852.7304 m5sm5ml8an374rpu7gsjqd0aos 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 = 2405746 and bi.ref ='324.1824.00.1' and bi.lordem =1
20240904@183852.7333 m5sm5ml8an374rpu7gsjqd0aos 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'
20240904@183852.7398 m5sm5ml8an374rpu7gsjqd0aos 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 = 2405746 and bi.ref ='324.1824.00.1' and bi.lordem =1
20240904@183852.7437 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.7441 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240904@183852.7493 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.7498 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 1 valor from td where td.ndoc = 39
20240904@183852.7536 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.7539 m5sm5ml8an374rpu7gsjqd0aos 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')
20240904@183852.7601 m5sm5ml8an374rpu7gsjqd0aos 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
20240904@183852.7709 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.7713 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 ~inactivo valor from cl where no = '199506' and estab = 0 order by inactivo desc
20240904@183852.7894 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.7898 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240904@183852.7960 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.7965 m5sm5ml8an374rpu7gsjqd0aos Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240904@183852.8255 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.8263 m5sm5ml8an374rpu7gsjqd0aos Query : select szadrsstamp valor from szadrs where szadrsdesc='199506 - itmp alimentar, s.a.'
20240904@183852.8359 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183852.8364 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from td where ndoc = 39
20240904@183852.8380 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240904@183852.8402 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.8423 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183852.8453 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.8495 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183852.8528 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.8544 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183852.8559 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183852.8858 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183852.8944 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.9049 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183852.9196 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d893323466d89b2cd0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240904@183852.9403 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183852.9462 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183853.8180 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240904@183853.8390 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240904@183853.8550 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240904@183853.8910 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240904@183853.9340 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240904@183853.9920 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240904@183853.1010 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d893323466d89b2cd0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240904@183853.1326 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 fno valor from wsftdata order by fno desc
20240904@183853.1355 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.1376 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183853.1405 m5sm5ml8an374rpu7gsjqd0aos Query : select 'normal' from dummy
20240904@183853.1423 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d893323466d89b2cd0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',615,199506,0,'2024-09-04',39,'euro',0,0,2024 ,?,?)
20240904@183853.1815 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183853.1836 m5sm5ml8an374rpu7gsjqd0aos Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240904@183853.1890 m5sm5ml8an374rpu7gsjqd0aos 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'
20240904@183853.2058 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.2080 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.2112 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.2135 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.2146 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183853.2169 m5sm5ml8an374rpu7gsjqd0aos Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240904@183853.2189 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.2215 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.2230 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d896873566d89b2d35','aut66d893323466d89b2cd0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183853.2234 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.2254 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.2287 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d896873566d89b2d35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut66d893323466d89b2cd0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240904@183853.2632 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.2670 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.2701 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.2718 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.2729 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183853.2744 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.2762 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.2786 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d892972566d89b2d43','aut66d893323466d89b2cd0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183853.2791 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.2809 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.2859 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d892972566d89b2d43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d893323466d89b2cd0' ,0,0 ,2,23.00,20000,?,?,?)
20240904@183853.3208 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183853.3213 m5sm5ml8an374rpu7gsjqd0aos Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240904@183853.3242 m5sm5ml8an374rpu7gsjqd0aos 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'
20240904@183853.3262 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.3298 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.3331 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.3350 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.3361 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183853.3377 m5sm5ml8an374rpu7gsjqd0aos Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240904@183853.3392 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.3424 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.3439 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d899954266d89b2d52','aut66d893323466d89b2cd0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183853.3445 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.3472 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.3505 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d899954266d89b2d52',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66d893323466d89b2cd0' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240904@183853.3824 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.3848 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.3880 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.3922 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.3932 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183853.3948 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.3967 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.3982 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d890495066d89b2d60','aut66d893323466d89b2cd0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183853.3988 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.4005 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.4062 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d890495066d89b2d60',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d893323466d89b2cd0' ,0,0 ,2,23.00,50000,?,?,?)
20240904@183853.4437 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183853.4441 m5sm5ml8an374rpu7gsjqd0aos Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240904@183853.4506 m5sm5ml8an374rpu7gsjqd0aos 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'
20240904@183853.4532 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.4550 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.4579 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.4597 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.4607 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183853.4621 m5sm5ml8an374rpu7gsjqd0aos Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240904@183853.4635 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.4654 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.4685 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d897007966d89b2d71','aut66d893323466d89b2cd0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183853.4690 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.4719 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.4763 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d897007966d89b2d71',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66d893323466d89b2cd0' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240904@183853.5067 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.5107 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.5132 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.5148 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.5156 m5sm5ml8an374rpu7gsjqd0aos Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183853.5167 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.5181 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183853.5192 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d897071066d89b2d7e','aut66d893323466d89b2cd0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183853.5196 m5sm5ml8an374rpu7gsjqd0aos Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.5212 m5sm5ml8an374rpu7gsjqd0aos Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183853.5261 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d897071066d89b2d7e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d893323466d89b2cd0' ,0,0 ,2,23.00,80000,?,?,?)
20240904@183853.5566 m5sm5ml8an374rpu7gsjqd0aos Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d893323466d89b2cd0','2405746','wait',39,'adm09112754980.682000002')
20240904@183853.5674 m5sm5ml8an374rpu7gsjqd0aos Query : use flama_phc
20240904@183853.5677 m5sm5ml8an374rpu7gsjqd0aos Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240904@183853.5711 m5sm5ml8an374rpu7gsjqd0aos Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1840';
20240904@183853.5755 m5sm5ml8an374rpu7gsjqd0aos Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1840';
20240904@183853.5803 m5sm5ml8an374rpu7gsjqd0aos Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1840';
20240904@183853.5858 m5sm5ml8an374rpu7gsjqd0aos Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1840';
20240904@183853.6576 grih04a2i6ci2iacngsc124rfd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240904@183853.6586 grih04a2i6ci2iacngsc124rfd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240904@183853.6643 grih04a2i6ci2iacngsc124rfd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1841';
20240904@183853.6936 grih04a2i6ci2iacngsc124rfd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1841';
20240904@183853.7046 grih04a2i6ci2iacngsc124rfd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1841';
20240904@183853.7100 grih04a2i6ci2iacngsc124rfd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1841';
20240904@183853.7152 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.7157 grih04a2i6ci2iacngsc124rfd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240904@183853.7319 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.7322 grih04a2i6ci2iacngsc124rfd Query : select no, estab,szadrsdesc from szadrs where u_coddest=1498
20240904@183853.7433 grih04a2i6ci2iacngsc124rfd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8253.00.1'
20240904@183853.7630 grih04a2i6ci2iacngsc124rfd 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 = 2405747 and bi.ref ='327.8253.00.1' and bi.lordem =1
20240904@183853.8364 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.8368 grih04a2i6ci2iacngsc124rfd Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240904@183853.8426 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.8434 grih04a2i6ci2iacngsc124rfd Query : select top 1 1 valor from td where td.ndoc = 39
20240904@183853.8468 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.8472 grih04a2i6ci2iacngsc124rfd 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')
20240904@183853.8510 grih04a2i6ci2iacngsc124rfd 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
20240904@183853.8570 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.8574 grih04a2i6ci2iacngsc124rfd Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240904@183853.8789 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.8796 grih04a2i6ci2iacngsc124rfd Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240904@183853.8843 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.8856 grih04a2i6ci2iacngsc124rfd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240904@183853.8898 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.8902 grih04a2i6ci2iacngsc124rfd Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m - viseu'
20240904@183853.8977 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183853.8982 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from td where ndoc = 39
20240904@183853.8995 grih04a2i6ci2iacngsc124rfd Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240904@183853.9010 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.9032 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183853.9056 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.9082 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183853.9119 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.9134 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183853.9160 grih04a2i6ci2iacngsc124rfd Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183853.9375 grih04a2i6ci2iacngsc124rfd Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183853.9390 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.9412 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183853.9444 grih04a2i6ci2iacngsc124rfd Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d897801966d89b2ddf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240904@183853.9658 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183853.9677 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183853.9711 grih04a2i6ci2iacngsc124rfd Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240904@183853.9739 grih04a2i6ci2iacngsc124rfd Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240904@183853.9787 grih04a2i6ci2iacngsc124rfd Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240904@183853.9801 grih04a2i6ci2iacngsc124rfd Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240904@183853.9816 grih04a2i6ci2iacngsc124rfd Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240904@183853.9829 grih04a2i6ci2iacngsc124rfd Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240904@183853.9841 grih04a2i6ci2iacngsc124rfd Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d897801966d89b2ddf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240904@183854.1570 grih04a2i6ci2iacngsc124rfd Query : select top 1 fno valor from wsftdata order by fno desc
20240904@183854.1950 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183854.2130 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183854.2500 grih04a2i6ci2iacngsc124rfd Query : select 'normal' from dummy
20240904@183854.2740 grih04a2i6ci2iacngsc124rfd Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d897801966d89b2ddf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',616,101621,0,'2024-09-04',39,'euro',0,0,2024 ,?,?)
20240904@183854.5930 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183854.5960 grih04a2i6ci2iacngsc124rfd Query : select st.usalote valor from st where st.ref = '327.8253.00.1'
20240904@183854.6220 grih04a2i6ci2iacngsc124rfd 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 = '327.8253.00.1'
20240904@183854.7800 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183854.8120 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183854.8480 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183854.8650 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183854.8750 grih04a2i6ci2iacngsc124rfd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183854.8880 grih04a2i6ci2iacngsc124rfd Query : select sestamp valor from se where ref ='327.8253.00.1' and lote = 'r2400072300a'
20240904@183854.9100 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183854.9260 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183854.9390 grih04a2i6ci2iacngsc124rfd Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d891766666d89b2e16','aut66d897801966d89b2ddf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183854.9440 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183854.9700 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183854.1005 grih04a2i6ci2iacngsc124rfd Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d891766666d89b2e16',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d897801966d89b2ddf' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240904@183854.1317 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183854.1346 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183854.1374 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183854.1390 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183854.1399 grih04a2i6ci2iacngsc124rfd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183854.1415 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183854.1431 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183854.1447 grih04a2i6ci2iacngsc124rfd Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d899417966d89b2e22','aut66d897801966d89b2ddf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183854.1452 grih04a2i6ci2iacngsc124rfd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183854.1469 grih04a2i6ci2iacngsc124rfd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183854.1514 grih04a2i6ci2iacngsc124rfd Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d899417966d89b2e22',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d897801966d89b2ddf' ,0,0 ,2,23.00,20000,?,?,?)
20240904@183854.1805 grih04a2i6ci2iacngsc124rfd Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d897801966d89b2ddf','2405747','wait',39,'adm09112754980.682000002')
20240904@183854.1889 grih04a2i6ci2iacngsc124rfd Query : use flama_phc
20240904@183854.1893 grih04a2i6ci2iacngsc124rfd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240904@183854.1929 grih04a2i6ci2iacngsc124rfd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1841';
20240904@183854.1958 grih04a2i6ci2iacngsc124rfd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1841';
20240904@183854.2008 grih04a2i6ci2iacngsc124rfd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1841';
20240904@183854.2033 grih04a2i6ci2iacngsc124rfd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1841';
20240904@183854.2605 rdvsl2b13eoecncf2an6dd16mm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240904@183854.2618 rdvsl2b13eoecncf2an6dd16mm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240904@183854.2676 rdvsl2b13eoecncf2an6dd16mm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1842';
20240904@183854.2951 rdvsl2b13eoecncf2an6dd16mm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1842';
20240904@183854.3008 rdvsl2b13eoecncf2an6dd16mm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1842';
20240904@183854.3056 rdvsl2b13eoecncf2an6dd16mm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1842';
20240904@183854.3123 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183854.3126 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240904@183854.3209 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183854.3213 rdvsl2b13eoecncf2an6dd16mm Query : select no, estab,szadrsdesc from szadrs where u_coddest=6234
20240904@183854.3316 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1896.00.1'
20240904@183854.3487 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1896.00.1' and bi.lordem =1
20240904@183854.3838 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1896.00.1'
20240904@183854.3863 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1896.00.1' and bi.lordem =1
20240904@183854.3882 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240904@183854.4317 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1831.00.2' and bi.lordem =3
20240904@183854.4744 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240904@183854.4931 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1832.00.2' and bi.lordem =5
20240904@183854.5297 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240904@183854.5505 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1833.00.2' and bi.lordem =7
20240904@183854.5890 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240904@183854.6067 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1879.00.1' and bi.lordem =9
20240904@183854.6483 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1871.00.4'
20240904@183854.6671 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1871.00.4' and bi.lordem =10
20240904@183854.8139 rdvsl2b13eoecncf2an6dd16mm 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'
20240904@183854.8370 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.2066.00.1' and bi.lordem =12
20240904@183854.8769 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240904@183854.8793 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='304.421.00.04' and bi.lordem =13
20240904@183854.9169 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20240904@183854.9552 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='304.422.00.07' and bi.lordem =14
20240904@183854.9933 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20240904@183855.1230 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.497.00.01' and bi.lordem =15
20240904@183855.4770 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240904@183855.5030 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.727.00.01' and bi.lordem =16
20240904@183855.8840 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4906.00.1'
20240904@183855.1075 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.4906.00.1' and bi.lordem =18
20240904@183855.1454 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240904@183855.1648 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.646.00.01' and bi.lordem =20
20240904@183855.2018 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.642.00.01'
20240904@183855.2218 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.642.00.01' and bi.lordem =21
20240904@183855.2618 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1221.00.1'
20240904@183855.2802 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1221.00.1' and bi.lordem =22
20240904@183855.3166 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1256.00.1'
20240904@183855.3365 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1256.00.1' and bi.lordem =24
20240904@183855.3736 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1407.00.1'
20240904@183855.3926 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1407.00.1' and bi.lordem =25
20240904@183855.4341 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1416.00.1'
20240904@183855.4525 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.1416.00.1' and bi.lordem =27
20240904@183855.4910 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2232.00.1'
20240904@183855.4931 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.2232.00.1' and bi.lordem =29
20240904@183855.5298 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5501.00.1'
20240904@183855.5320 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.5501.00.1' and bi.lordem =30
20240904@183855.5693 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240904@183855.5713 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='324.5396.00.1' and bi.lordem =32
20240904@183855.6294 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1670.3015'
20240904@183855.6461 rdvsl2b13eoecncf2an6dd16mm 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 = 2405748 and bi.ref ='325.1670.3015' and bi.lordem =33
20240904@183855.6806 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183855.6809 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240904@183855.6842 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183855.6845 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 1 valor from td where td.ndoc = 39
20240904@183855.6878 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183855.6881 rdvsl2b13eoecncf2an6dd16mm 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')
20240904@183855.6909 rdvsl2b13eoecncf2an6dd16mm 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
20240904@183855.6946 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183855.6949 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 ~inactivo valor from cl where no = '102382' and estab = 0 order by inactivo desc
20240904@183855.7084 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183855.7087 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240904@183855.7118 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183855.7121 rdvsl2b13eoecncf2an6dd16mm Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240904@183855.7202 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183855.7244 rdvsl2b13eoecncf2an6dd16mm Query : select szadrsstamp valor from szadrs where szadrsdesc='ig-electrodomÉsticos, lda-loja euronics'
20240904@183855.7492 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183855.7496 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from td where ndoc = 39
20240904@183855.7516 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240904@183855.7534 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.7551 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183855.7572 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.7602 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183855.7636 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.7652 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183855.7666 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183855.7742 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240904@183855.7759 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.7778 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240904@183855.7798 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d895189866d89b2fbb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240904@183855.8014 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.8033 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240904@183855.8070 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240904@183855.8094 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240904@183855.8106 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240904@183855.8120 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240904@183855.8143 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240904@183855.8156 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240904@183855.8172 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d895189866d89b2fbb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240904@183855.8473 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 fno valor from wsftdata order by fno desc
20240904@183855.8493 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.8523 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240904@183855.8552 rdvsl2b13eoecncf2an6dd16mm Query : select 'normal' from dummy
20240904@183855.8570 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d895189866d89b2fbb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',617,102382,0,'2024-09-04',39,'euro',0,0,2024 ,?,?)
20240904@183855.9076 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183855.9080 rdvsl2b13eoecncf2an6dd16mm Query : select st.usalote valor from st where st.ref = '324.1896.00.1'
20240904@183855.9107 rdvsl2b13eoecncf2an6dd16mm 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.1896.00.1'
20240904@183855.9288 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.9311 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183855.9344 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.9363 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183855.9377 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183855.9394 rdvsl2b13eoecncf2an6dd16mm Query : select sestamp valor from se where ref ='324.1896.00.1' and lote = 'r2101190100a'
20240904@183855.9420 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.9448 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183855.9462 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d894605866d89b2fe6','aut66d895189866d89b2fbb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183855.9466 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183855.9491 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183855.9525 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d894605866d89b2fe6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66d895189866d89b2fbb' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240904@183855.9998 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183856.2000 rdvsl2b13eoecncf2an6dd16mm Query : select st.usalote valor from st where st.ref = '324.1896.00.1'
20240904@183856.3000 rdvsl2b13eoecncf2an6dd16mm 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.1896.00.1'
20240904@183856.4900 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.6900 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183856.1070 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.1260 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183856.1370 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183856.1520 rdvsl2b13eoecncf2an6dd16mm Query : select sestamp valor from se where ref ='324.1896.00.1' and lote = 'r2101190100a'
20240904@183856.1650 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.1880 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183856.2170 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d893761666d89b3004','aut66d895189866d89b2fbb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183856.2230 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.2390 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183856.2730 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d893761666d89b3004',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut66d895189866d89b2fbb' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240904@183856.5890 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183856.5930 rdvsl2b13eoecncf2an6dd16mm Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240904@183856.6180 rdvsl2b13eoecncf2an6dd16mm 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.1831.00.2'
20240904@183856.7900 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.8250 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183856.8630 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.8820 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183856.9070 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183856.9270 rdvsl2b13eoecncf2an6dd16mm Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240904@183856.9490 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.9670 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183856.9830 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d898548866d89b3017','aut66d895189866d89b2fbb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183856.9870 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.1012 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183856.1050 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66d898548866d89b3017',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66d895189866d89b2fbb' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240904@183856.1355 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.1375 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183856.1409 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.1426 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183856.1436 rdvsl2b13eoecncf2an6dd16mm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240904@183856.1468 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.1489 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240904@183856.1504 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d895058066d89b3023','aut66d895189866d89b2fbb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240904@183856.1508 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.1537 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183856.1580 rdvsl2b13eoecncf2an6dd16mm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d895058066d89b3023',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d895189866d89b2fbb' ,0,0 ,2,23.00,40000,?,?,?)
20240904@183856.1907 rdvsl2b13eoecncf2an6dd16mm Query : use flama_phc
20240904@183856.1911 rdvsl2b13eoecncf2an6dd16mm Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240904@183856.1942 rdvsl2b13eoecncf2an6dd16mm 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.1832.00.2'
20240904@183856.2131 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.2153 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240904@183856.2190 rdvsl2b13eoecncf2an6dd16mm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240904@183856.2211 rdvsl2b13eoecncf2an6dd16mm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
