20241119@180745.4969 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd40704673cd3f153','aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180745.5014 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.5266 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180745.5886 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd40704673cd3f153',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',108.000 ,'aut673cd11354673cd3ec87' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241119@180745.6479 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180745.6521 vuna1gb6e318v11qf3vrb43i0k Query : select st.usalote valor from st where st.ref = '324.2308.00.1'
20241119@180745.6854 vuna1gb6e318v11qf3vrb43i0k 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.2308.00.1'
20241119@180745.7356 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.7609 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180745.8334 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.8584 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180745.8749 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180745.8998 vuna1gb6e318v11qf3vrb43i0k Query : select sestamp valor from se where ref ='324.2308.00.1' and lote = 'r2400475700a'
20241119@180745.9251 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.9504 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180745.9711 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd32436673cd3f1e1','aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180745.9754 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.6000 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180746.9620 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd32436673cd3f1e1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',126.000 ,'aut673cd11354673cd3ec87' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241119@180746.1576 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673cd11354673cd3ec87','2407683','wait',39,'adm09112754980.682000002')
20241119@180746.2256 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180746.2298 vuna1gb6e318v11qf3vrb43i0k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@180746.2546 vuna1gb6e318v11qf3vrb43i0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3374';
20241119@180746.2851 vuna1gb6e318v11qf3vrb43i0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3374';
20241119@180746.3116 vuna1gb6e318v11qf3vrb43i0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3374';
20241119@180746.3420 vuna1gb6e318v11qf3vrb43i0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3374';
20241119@180746.5921 ndmf8qp9ndu45do1dls3v936sb Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241119@180746.5935 ndmf8qp9ndu45do1dls3v936sb Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241119@180746.6002 ndmf8qp9ndu45do1dls3v936sb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3375';
20241119@180746.6061 ndmf8qp9ndu45do1dls3v936sb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3375';
20241119@180746.6121 ndmf8qp9ndu45do1dls3v936sb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3375';
20241119@180746.6156 ndmf8qp9ndu45do1dls3v936sb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3375';
20241119@180746.6216 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6219 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241119@180746.6293 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6297 ndmf8qp9ndu45do1dls3v936sb Query : select no, estab,szadrsdesc from szadrs where u_coddest=805
20241119@180746.6381 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241119@180746.6540 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407684 and bi.ref ='324.692.00.01' and bi.lordem =1
20241119@180746.6852 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6856 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241119@180746.6894 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6897 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 1 valor from td where td.ndoc = 39
20241119@180746.6929 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6933 ndmf8qp9ndu45do1dls3v936sb 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')
20241119@180746.6966 ndmf8qp9ndu45do1dls3v936sb 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
20241119@180746.7003 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7007 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 ~inactivo valor from cl where no = '100247' and estab = 0 order by inactivo desc
20241119@180746.7136 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7139 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241119@180746.7174 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7177 ndmf8qp9ndu45do1dls3v936sb Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241119@180746.7221 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7224 ndmf8qp9ndu45do1dls3v936sb Query : select szadrsstamp valor from szadrs where szadrsdesc='acacio domingues afonso'
20241119@180746.7279 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7282 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from td where ndoc = 39
20241119@180746.7296 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241119@180746.7351 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.7503 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180746.7840 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.7866 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180746.7927 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.7950 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180746.7977 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180746.8052 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180746.8095 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.8125 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180746.8173 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673cd02974673cd3f2c2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241119@180746.8399 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.8424 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180746.8518 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241119@180746.8536 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241119@180746.8555 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241119@180746.8574 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241119@180746.8592 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241119@180746.8627 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241119@180746.8653 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673cd02974673cd3f2c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241119@180746.8980 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 fno valor from wsftdata order by fno desc
20241119@180746.9026 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.9054 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180746.9349 ndmf8qp9ndu45do1dls3v936sb Query : select 'normal' from dummy
20241119@180746.9641 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673cd02974673cd3f2c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1926,100247,0,'2024-11-19',39,'euro',0,0,2024 ,?,?)
20241119@180747.3450 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180747.3490 ndmf8qp9ndu45do1dls3v936sb Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241119@180747.3780 ndmf8qp9ndu45do1dls3v936sb 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.692.00.01'
20241119@180747.6050 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.6250 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180747.6680 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.6880 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180747.6990 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180747.7150 ndmf8qp9ndu45do1dls3v936sb Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400210100a'
20241119@180747.7320 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.7510 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180747.7650 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd75921673cd3f311','aut673cd02974673cd3f2c2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180747.7760 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.7910 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180747.8200 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd75921673cd3f311',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut673cd02974673cd3f2c2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241119@180747.1294 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.1311 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180747.1346 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.1558 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180747.1709 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180747.1734 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.1757 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180747.1774 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd36334673cd3f32a','aut673cd02974673cd3f2c2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180747.1784 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.1816 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180747.1871 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673cd36334673cd3f32a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673cd02974673cd3f2c2' ,0,0 ,2,23.00,20000,?,?,?)
20241119@180747.2162 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673cd02974673cd3f2c2','2407684','wait',39,'adm09112754980.682000002')
20241119@180747.2286 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180747.2292 ndmf8qp9ndu45do1dls3v936sb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@180747.2344 ndmf8qp9ndu45do1dls3v936sb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3375';
20241119@180747.2415 ndmf8qp9ndu45do1dls3v936sb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3375';
20241119@180747.2470 ndmf8qp9ndu45do1dls3v936sb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3375';
20241119@180747.2518 ndmf8qp9ndu45do1dls3v936sb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3375';
20241119@180747.5151 okouukai4cbof6bsqi6dnir2t6 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241119@180747.5162 okouukai4cbof6bsqi6dnir2t6 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241119@180747.5233 okouukai4cbof6bsqi6dnir2t6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3376';
20241119@180747.5291 okouukai4cbof6bsqi6dnir2t6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3376';
20241119@180747.5348 okouukai4cbof6bsqi6dnir2t6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3376';
20241119@180747.5377 okouukai4cbof6bsqi6dnir2t6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3376';
20241119@180747.5438 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.5442 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241119@180747.5517 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.5521 okouukai4cbof6bsqi6dnir2t6 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2117
20241119@180747.5604 okouukai4cbof6bsqi6dnir2t6 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'
20241119@180747.5760 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407685 and bi.ref ='324.1832.00.2' and bi.lordem =1
20241119@180747.7281 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20241119@180747.7452 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407685 and bi.ref ='324.4980.00.1' and bi.lordem =2
20241119@180747.7787 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.969.00.01'
20241119@180747.7948 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407685 and bi.ref ='324.969.00.01' and bi.lordem =3
20241119@180747.8491 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8495 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241119@180747.8533 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8536 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 1 valor from td where td.ndoc = 39
20241119@180747.8590 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8594 okouukai4cbof6bsqi6dnir2t6 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')
20241119@180747.8642 okouukai4cbof6bsqi6dnir2t6 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
20241119@180747.8698 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8701 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 ~inactivo valor from cl where no = '102420' and estab = 0 order by inactivo desc
20241119@180747.8846 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8849 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241119@180747.8895 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8898 okouukai4cbof6bsqi6dnir2t6 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241119@180747.8969 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8973 okouukai4cbof6bsqi6dnir2t6 Query : select szadrsstamp valor from szadrs where szadrsdesc='ri - eletrodomesticos lda'
20241119@180747.9047 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.9050 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from td where ndoc = 39
20241119@180747.9064 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241119@180747.9079 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9096 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180747.9117 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9132 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180747.9163 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9178 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180747.9191 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180747.9251 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180747.9265 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9282 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180747.9299 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241119@180747.9482 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9502 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180747.9543 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241119@180747.9557 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241119@180747.9569 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241119@180747.9582 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241119@180747.9594 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241119@180747.9647 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241119@180747.9660 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673cd20900673cd3f3e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241119@180747.9933 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 fno valor from wsftdata order by fno desc
20241119@180747.9960 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9978 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180748.1000 okouukai4cbof6bsqi6dnir2t6 Query : select 'normal' from dummy
20241119@180748.1900 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673cd20900673cd3f3e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1927,102420,0,'2024-11-19',39,'euro',0,0,2024 ,?,?)
20241119@180748.3650 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180748.3810 okouukai4cbof6bsqi6dnir2t6 Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241119@180748.4030 okouukai4cbof6bsqi6dnir2t6 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'
20241119@180748.5520 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.5690 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.5960 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.6110 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.6200 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180748.6320 okouukai4cbof6bsqi6dnir2t6 Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241119@180748.6550 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.6700 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.6820 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd66763673cd3f40f','aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180748.6860 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.7000 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.7290 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd66763673cd3f40f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut673cd20900673cd3f3e0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241119@180748.1026 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1043 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.1068 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1084 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.1092 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180748.1104 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1119 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.1131 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd75526673cd3f41a','aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180748.1135 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1149 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.1179 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673cd75526673cd3f41a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673cd20900673cd3f3e0' ,0,0 ,2,23.00,20000,?,?,?)
20241119@180748.1445 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180748.1448 okouukai4cbof6bsqi6dnir2t6 Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20241119@180748.1469 okouukai4cbof6bsqi6dnir2t6 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.4980.00.1'
20241119@180748.1627 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1644 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.1670 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1685 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.1693 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180748.1704 okouukai4cbof6bsqi6dnir2t6 Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r2400145100a'
20241119@180748.1727 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1742 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.1754 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd95345673cd3f42a','aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180748.1758 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1773 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.1803 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd95345673cd3f42a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut673cd20900673cd3f3e0' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241119@180748.2098 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180748.2102 okouukai4cbof6bsqi6dnir2t6 Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20241119@180748.2145 okouukai4cbof6bsqi6dnir2t6 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.969.00.01'
20241119@180748.2324 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.2341 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.2367 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.2382 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.2391 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180748.2403 okouukai4cbof6bsqi6dnir2t6 Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20241119@180748.2426 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.2441 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.2454 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd06841673cd3f43b','aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180748.2459 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.2474 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.2503 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd06841673cd3f43b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673cd20900673cd3f3e0' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241119@180748.2773 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673cd20900673cd3f3e0','2407685','wait',39,'adm09112754980.682000002')
20241119@180748.2854 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180748.2857 okouukai4cbof6bsqi6dnir2t6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@180748.2894 okouukai4cbof6bsqi6dnir2t6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3376';
20241119@180748.2932 okouukai4cbof6bsqi6dnir2t6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3376';
20241119@180748.2987 okouukai4cbof6bsqi6dnir2t6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3376';
20241119@180748.3019 okouukai4cbof6bsqi6dnir2t6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3376';
20241119@180748.3905 unhobca0ioavusr5t6ttmgrjon Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241119@180748.3989 unhobca0ioavusr5t6ttmgrjon Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241119@180748.4472 unhobca0ioavusr5t6ttmgrjon Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3377';
20241119@180748.4846 unhobca0ioavusr5t6ttmgrjon Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3377';
20241119@180748.5202 unhobca0ioavusr5t6ttmgrjon Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3377';
20241119@180748.5507 unhobca0ioavusr5t6ttmgrjon Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3377';
20241119@180748.5896 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180748.5939 unhobca0ioavusr5t6ttmgrjon Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241119@180748.6560 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180748.6601 unhobca0ioavusr5t6ttmgrjon Query : select no, estab,szadrsdesc from szadrs where u_coddest=6917
20241119@180748.6997 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.600.94.01'
20241119@180748.7517 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.600.94.01' and bi.lordem =1
20241119@180748.8331 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.600.94.01'
20241119@180748.8622 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.600.94.01' and bi.lordem =1
20241119@180748.8834 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2000.94.1'
20241119@180749.3710 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.2000.94.1' and bi.lordem =2
20241119@180749.1173 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.900.94.01'
20241119@180749.1969 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.900.94.01' and bi.lordem =3
20241119@180749.2766 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.700.94.01'
20241119@180749.3276 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.700.94.01' and bi.lordem =4
20241119@180749.4100 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2200.94.1'
20241119@180749.4817 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.2200.94.1' and bi.lordem =5
20241119@180749.5918 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.5959 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241119@180749.6334 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.6376 unhobca0ioavusr5t6ttmgrjon Query : select top 1 1 valor from td where td.ndoc = 39
20241119@180749.6749 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.6790 unhobca0ioavusr5t6ttmgrjon 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')
20241119@180749.7270 unhobca0ioavusr5t6ttmgrjon 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
20241119@180749.7724 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.7766 unhobca0ioavusr5t6ttmgrjon Query : select top 1 ~inactivo valor from cl where no = '199800' and estab = 0 order by inactivo desc
20241119@180749.9590 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.9631 unhobca0ioavusr5t6ttmgrjon Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241119@180750.5000 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180750.4700 unhobca0ioavusr5t6ttmgrjon Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241119@180750.5200 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180750.6040 unhobca0ioavusr5t6ttmgrjon Query : select szadrsstamp valor from szadrs where szadrsdesc='740 ent vnr bligeiro'
20241119@180750.1427 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180750.1472 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from td where ndoc = 39
20241119@180750.1722 unhobca0ioavusr5t6ttmgrjon Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241119@180750.2134 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.2405 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180750.2888 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.3336 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180750.3999 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.4251 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180750.4500 unhobca0ioavusr5t6ttmgrjon Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180750.4836 unhobca0ioavusr5t6ttmgrjon Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180750.5085 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.5335 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180750.5626 unhobca0ioavusr5t6ttmgrjon Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241119@180750.6024 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.6276 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180750.6989 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241119@180750.7302 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241119@180750.7577 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241119@180750.7816 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241119@180750.8045 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241119@180750.8254 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241119@180750.8460 unhobca0ioavusr5t6ttmgrjon Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673cd18787673cd3f66d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241119@180750.9248 unhobca0ioavusr5t6ttmgrjon Query : select top 1 fno valor from wsftdata order by fno desc
20241119@180751.5700 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.4000 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180751.8560 unhobca0ioavusr5t6ttmgrjon Query : select 'normal' from dummy
20241119@180751.1145 unhobca0ioavusr5t6ttmgrjon Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673cd18787673cd3f66d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1928,199800,0,'2024-11-19',39,'euro',0,0,2024 ,?,?)
20241119@180751.1877 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180751.1919 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20241119@180751.2291 unhobca0ioavusr5t6ttmgrjon 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.600.94.01'
20241119@180751.2977 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.3361 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180751.3940 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.4192 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180751.4360 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180751.4609 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20241119@180751.4900 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.5152 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180751.5360 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd85387673cd3f777','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180751.5403 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.5665 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180751.7492 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd85387673cd3f777',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241119@180751.8183 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.8435 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180751.9015 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.9268 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180751.9435 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180751.9683 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.1735 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180752.2217 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd85235673cd3f7ec','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180752.2261 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.2513 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180752.3279 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673cd85235673cd3f7ec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,20000,?,?,?)
20241119@180752.4037 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180752.4079 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20241119@180752.4413 unhobca0ioavusr5t6ttmgrjon 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.600.94.01'
20241119@180752.4662 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.4939 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180752.5517 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.5770 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180752.5937 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180752.6186 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20241119@180752.6604 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.7991 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180752.8206 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd06430673cd3f8a1','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180752.8250 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.8502 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180752.9123 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd06430673cd3f8a1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241119@180752.9838 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.9300 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180753.6710 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.9230 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180753.1089 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180753.1337 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.1592 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180753.1803 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd35572673cd3f920','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180753.1846 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.2102 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180753.2721 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673cd35572673cd3f920',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,50000,?,?,?)
20241119@180753.3512 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180753.3560 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.2000.94.1'
20241119@180753.3893 unhobca0ioavusr5t6ttmgrjon 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.2000.94.1'
20241119@180753.5273 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.5702 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180753.6286 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.6549 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180753.6716 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180753.6969 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.2000.94.1' and lote = 'r2300916200a'
20241119@180753.7260 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.7512 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180753.7719 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd37437673cd3f9b1','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180753.7763 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.8034 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180753.8669 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd37437673cd3f9b1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241119@180753.9362 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180753.9403 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.900.94.01'
20241119@180753.9783 unhobca0ioavusr5t6ttmgrjon 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.900.94.01'
20241119@180754.3180 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.5750 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180754.1153 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.1407 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180754.1573 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180754.1820 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.900.94.01' and lote = 'r2300952200a'
20241119@180754.2111 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.2363 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180754.2574 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd71736673cd3fa33','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180754.2617 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.2870 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180754.3533 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd71736673cd3fa33',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241119@180754.4976 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180754.5020 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.700.94.01'
20241119@180754.5353 unhobca0ioavusr5t6ttmgrjon 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.700.94.01'
20241119@180754.5879 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.6133 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180754.6715 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.6967 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180754.7133 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180754.7381 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.700.94.01' and lote = 'r2300913100a'
20241119@180754.7632 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.7885 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180754.8092 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd25747673cd3faba','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180754.8135 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.8389 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180754.9008 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd25747673cd3faba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241119@180754.9616 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180754.9657 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.2200.94.1'
20241119@180754.9992 unhobca0ioavusr5t6ttmgrjon 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.2200.94.1'
20241119@180755.5190 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180755.7710 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
