20240923@181047.7569 q23df62ue65b4l8vmt7a4jcmsr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181047.7582 q23df62ue65b4l8vmt7a4jcmsr Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400526200a'
20240923@181047.7596 q23df62ue65b4l8vmt7a4jcmsr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181047.7609 q23df62ue65b4l8vmt7a4jcmsr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181047.7621 q23df62ue65b4l8vmt7a4jcmsr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a0636166f1a117b9','aut66f1a6749366f1a11783' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181047.7625 q23df62ue65b4l8vmt7a4jcmsr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181047.7655 q23df62ue65b4l8vmt7a4jcmsr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181047.7682 q23df62ue65b4l8vmt7a4jcmsr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a0636166f1a117b9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66f1a6749366f1a11783' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240923@181047.7981 q23df62ue65b4l8vmt7a4jcmsr Query : use flama_phc
20240923@181047.7984 q23df62ue65b4l8vmt7a4jcmsr Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20240923@181047.8002 q23df62ue65b4l8vmt7a4jcmsr 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.1642.00.2'
20240923@181047.8015 q23df62ue65b4l8vmt7a4jcmsr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181047.8030 q23df62ue65b4l8vmt7a4jcmsr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181047.8056 q23df62ue65b4l8vmt7a4jcmsr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181047.8069 q23df62ue65b4l8vmt7a4jcmsr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181047.8077 q23df62ue65b4l8vmt7a4jcmsr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181047.8089 q23df62ue65b4l8vmt7a4jcmsr Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400526200a'
20240923@181047.8102 q23df62ue65b4l8vmt7a4jcmsr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181047.8116 q23df62ue65b4l8vmt7a4jcmsr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181047.8127 q23df62ue65b4l8vmt7a4jcmsr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a9995566f1a117c5','aut66f1a6749366f1a11783' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181047.8131 q23df62ue65b4l8vmt7a4jcmsr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181047.8158 q23df62ue65b4l8vmt7a4jcmsr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181047.8186 q23df62ue65b4l8vmt7a4jcmsr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a9995566f1a117c5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66f1a6749366f1a11783' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240923@181047.8515 q23df62ue65b4l8vmt7a4jcmsr Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f1a6749366f1a11783','2406112','wait',39,'adm09112754980.682000002')
20240923@181047.8587 q23df62ue65b4l8vmt7a4jcmsr Query : use flama_phc
20240923@181047.8590 q23df62ue65b4l8vmt7a4jcmsr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@181047.8623 q23df62ue65b4l8vmt7a4jcmsr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2143';
20240923@181047.8654 q23df62ue65b4l8vmt7a4jcmsr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2143';
20240923@181047.8709 q23df62ue65b4l8vmt7a4jcmsr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2143';
20240923@181047.8734 q23df62ue65b4l8vmt7a4jcmsr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2143';
20240923@181048.2500 4uvc4en8usdfq8bspa82cdhlcc Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@181048.3800 4uvc4en8usdfq8bspa82cdhlcc Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@181048.1010 4uvc4en8usdfq8bspa82cdhlcc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2144';
20240923@181048.1550 4uvc4en8usdfq8bspa82cdhlcc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2144';
20240923@181048.2090 4uvc4en8usdfq8bspa82cdhlcc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2144';
20240923@181048.2490 4uvc4en8usdfq8bspa82cdhlcc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2144';
20240923@181048.2990 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.3020 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@181048.3640 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.3670 4uvc4en8usdfq8bspa82cdhlcc Query : select no, estab,szadrsdesc from szadrs where u_coddest=4500
20240923@181048.4730 4uvc4en8usdfq8bspa82cdhlcc 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'
20240923@181048.4960 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406113 and bi.ref ='324.727.00.01' and bi.lordem =1
20240923@181048.8320 4uvc4en8usdfq8bspa82cdhlcc 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'
20240923@181048.8520 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406113 and bi.ref ='324.646.00.01' and bi.lordem =3
20240923@181048.1180 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20240923@181048.1200 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406113 and bi.ref ='324.1642.00.2' and bi.lordem =4
20240923@181048.1504 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.1507 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@181048.1548 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.1551 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 1 valor from td where td.ndoc = 39
20240923@181048.1583 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.1587 4uvc4en8usdfq8bspa82cdhlcc 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')
20240923@181048.1615 4uvc4en8usdfq8bspa82cdhlcc 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
20240923@181048.1658 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.1661 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240923@181048.1817 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.1820 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@181048.1848 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.1851 4uvc4en8usdfq8bspa82cdhlcc Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@181048.1911 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.1914 4uvc4en8usdfq8bspa82cdhlcc Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - portimão'
20240923@181048.1964 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.1967 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from td where ndoc = 39
20240923@181048.1979 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@181048.1992 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.2009 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181048.2033 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.2047 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181048.2077 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.2091 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181048.2103 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181048.2168 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181048.2181 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.2196 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181048.2212 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f1a8642066f1a11833' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@181048.2399 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.2415 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181048.2449 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@181048.2468 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@181048.2495 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@181048.2509 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@181048.2521 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@181048.2534 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@181048.2546 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f1a8642066f1a11833',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@181048.2808 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 fno valor from wsftdata order by fno desc
20240923@181048.2836 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.2852 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181048.2874 4uvc4en8usdfq8bspa82cdhlcc Query : select 'normal' from dummy
20240923@181048.2889 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f1a8642066f1a11833',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',876,101621,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@181048.3200 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.3203 4uvc4en8usdfq8bspa82cdhlcc Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240923@181048.3225 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240923@181048.3238 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.3255 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.3280 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.3295 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.3303 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181048.3315 4uvc4en8usdfq8bspa82cdhlcc Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2400239200a'
20240923@181048.3330 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.3344 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.3356 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a1155266f1a11851','aut66f1a8642066f1a11833' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181048.3360 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.3375 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.3403 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a1155266f1a11851',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f1a8642066f1a11833' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@181048.3667 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.3683 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.3724 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.3740 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.3752 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181048.3766 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.3783 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.3795 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a0871466f1a1185b','aut66f1a8642066f1a11833' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181048.3800 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.3815 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.3844 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a0871466f1a1185b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a8642066f1a11833' ,0,0 ,2,23.00,20000,?,?,?)
20240923@181048.4163 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.4166 4uvc4en8usdfq8bspa82cdhlcc Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240923@181048.4185 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20240923@181048.4200 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.4217 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.4242 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.4256 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.4264 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181048.4275 4uvc4en8usdfq8bspa82cdhlcc Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240923@181048.4287 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.4301 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.4312 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a9174266f1a11868','aut66f1a8642066f1a11833' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181048.4316 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.4330 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.4357 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a9174266f1a11868',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f1a8642066f1a11833' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240923@181048.4627 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.4641 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.4665 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.4696 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.4704 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181048.4717 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.4732 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.4743 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a9407666f1a11873','aut66f1a8642066f1a11833' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181048.4747 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.4761 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.4790 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a9407666f1a11873',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a8642066f1a11833' ,0,0 ,2,23.00,50000,?,?,?)
20240923@181048.5049 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.5052 4uvc4en8usdfq8bspa82cdhlcc Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20240923@181048.5071 4uvc4en8usdfq8bspa82cdhlcc 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.1642.00.2'
20240923@181048.5094 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.5109 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.5136 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.5150 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.5158 4uvc4en8usdfq8bspa82cdhlcc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181048.5185 4uvc4en8usdfq8bspa82cdhlcc Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400526200a'
20240923@181048.5197 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.5211 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181048.5225 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a7416366f1a1187e','aut66f1a8642066f1a11833' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181048.5229 4uvc4en8usdfq8bspa82cdhlcc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.5242 4uvc4en8usdfq8bspa82cdhlcc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181048.5272 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a7416366f1a1187e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut66f1a8642066f1a11833' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240923@181048.5530 4uvc4en8usdfq8bspa82cdhlcc Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f1a8642066f1a11833','2406113','wait',39,'adm09112754980.682000002')
20240923@181048.5602 4uvc4en8usdfq8bspa82cdhlcc Query : use flama_phc
20240923@181048.5605 4uvc4en8usdfq8bspa82cdhlcc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@181048.5634 4uvc4en8usdfq8bspa82cdhlcc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2144';
20240923@181048.5662 4uvc4en8usdfq8bspa82cdhlcc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2144';
20240923@181048.5711 4uvc4en8usdfq8bspa82cdhlcc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2144';
20240923@181048.5736 4uvc4en8usdfq8bspa82cdhlcc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2144';
20240923@181048.6832 j2e9unu3btbihb55s4t1krltem Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@181048.6845 j2e9unu3btbihb55s4t1krltem Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@181048.6899 j2e9unu3btbihb55s4t1krltem Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2145';
20240923@181048.6956 j2e9unu3btbihb55s4t1krltem Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2145';
20240923@181048.7010 j2e9unu3btbihb55s4t1krltem Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2145';
20240923@181048.7033 j2e9unu3btbihb55s4t1krltem Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2145';
20240923@181048.7093 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.7096 j2e9unu3btbihb55s4t1krltem Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@181048.7156 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.7159 j2e9unu3btbihb55s4t1krltem Query : select no, estab,szadrsdesc from szadrs where u_coddest=1498
20240923@181048.7288 j2e9unu3btbihb55s4t1krltem 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'
20240923@181048.7310 j2e9unu3btbihb55s4t1krltem Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406114 and bi.ref ='324.727.00.01' and bi.lordem =1
20240923@181048.7643 j2e9unu3btbihb55s4t1krltem 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'
20240923@181048.7663 j2e9unu3btbihb55s4t1krltem Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406114 and bi.ref ='324.646.00.01' and bi.lordem =3
20240923@181048.7994 j2e9unu3btbihb55s4t1krltem Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20240923@181048.8015 j2e9unu3btbihb55s4t1krltem Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406114 and bi.ref ='324.1642.00.2' and bi.lordem =4
20240923@181048.8322 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.8325 j2e9unu3btbihb55s4t1krltem Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@181048.8357 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.8360 j2e9unu3btbihb55s4t1krltem Query : select top 1 1 valor from td where td.ndoc = 39
20240923@181048.9583 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.9587 j2e9unu3btbihb55s4t1krltem 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')
20240923@181048.9620 j2e9unu3btbihb55s4t1krltem 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
20240923@181048.9659 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.9663 j2e9unu3btbihb55s4t1krltem Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240923@181048.9697 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.9700 j2e9unu3btbihb55s4t1krltem Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@181048.9733 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.9736 j2e9unu3btbihb55s4t1krltem Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@181048.9783 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.9786 j2e9unu3btbihb55s4t1krltem Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m - viseu'
20240923@181048.9832 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181048.9835 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from td where ndoc = 39
20240923@181048.9847 j2e9unu3btbihb55s4t1krltem Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@181048.9860 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.9880 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181048.9899 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.9913 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181048.9940 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181048.9953 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181048.9965 j2e9unu3btbihb55s4t1krltem Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181049.3200 j2e9unu3btbihb55s4t1krltem Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181049.4500 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.6000 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181049.7500 j2e9unu3btbihb55s4t1krltem Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f1a7399766f1a118f3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@181049.2580 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.2730 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181049.3040 j2e9unu3btbihb55s4t1krltem Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@181049.3160 j2e9unu3btbihb55s4t1krltem Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@181049.3280 j2e9unu3btbihb55s4t1krltem Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@181049.3430 j2e9unu3btbihb55s4t1krltem Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@181049.3540 j2e9unu3btbihb55s4t1krltem Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@181049.3660 j2e9unu3btbihb55s4t1krltem Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@181049.3770 j2e9unu3btbihb55s4t1krltem Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f1a7399766f1a118f3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@181049.6180 j2e9unu3btbihb55s4t1krltem Query : select top 1 fno valor from wsftdata order by fno desc
20240923@181049.6380 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.6570 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181049.6840 j2e9unu3btbihb55s4t1krltem Query : select 'normal' from dummy
20240923@181049.7000 j2e9unu3btbihb55s4t1krltem Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f1a7399766f1a118f3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',877,101621,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@181049.1074 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181049.1078 j2e9unu3btbihb55s4t1krltem Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240923@181049.1101 j2e9unu3btbihb55s4t1krltem Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240923@181049.1120 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.1137 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.1163 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.1177 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.1185 j2e9unu3btbihb55s4t1krltem Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181049.1197 j2e9unu3btbihb55s4t1krltem Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2400239200a'
20240923@181049.1210 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.1226 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.1238 j2e9unu3btbihb55s4t1krltem Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3209466f1a1191d','aut66f1a7399766f1a118f3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181049.1242 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.1261 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.1289 j2e9unu3btbihb55s4t1krltem Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a3209466f1a1191d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f1a7399766f1a118f3' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@181049.1553 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.1569 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.1596 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.1610 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.1618 j2e9unu3btbihb55s4t1krltem Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181049.1631 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.1645 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.1656 j2e9unu3btbihb55s4t1krltem Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a4608066f1a11927','aut66f1a7399766f1a118f3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181049.1660 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.1678 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.1707 j2e9unu3btbihb55s4t1krltem Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a4608066f1a11927',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a7399766f1a118f3' ,0,0 ,2,23.00,20000,?,?,?)
20240923@181049.2063 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181049.2083 j2e9unu3btbihb55s4t1krltem Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240923@181049.2106 j2e9unu3btbihb55s4t1krltem Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20240923@181049.2119 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.2137 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.2163 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.2177 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.2186 j2e9unu3btbihb55s4t1krltem Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181049.2197 j2e9unu3btbihb55s4t1krltem Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240923@181049.2210 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.2226 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.2237 j2e9unu3btbihb55s4t1krltem Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3447666f1a11935','aut66f1a7399766f1a118f3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181049.2242 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.2256 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.2283 j2e9unu3btbihb55s4t1krltem Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a3447666f1a11935',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a7399766f1a118f3' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240923@181049.2569 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.2584 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.2610 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.2624 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.2633 j2e9unu3btbihb55s4t1krltem Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181049.2646 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.2662 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.2673 j2e9unu3btbihb55s4t1krltem Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a8296166f1a11940','aut66f1a7399766f1a118f3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181049.2677 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.2691 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.2719 j2e9unu3btbihb55s4t1krltem Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a8296166f1a11940',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a7399766f1a118f3' ,0,0 ,2,23.00,50000,?,?,?)
20240923@181049.2963 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181049.2967 j2e9unu3btbihb55s4t1krltem Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20240923@181049.2987 j2e9unu3btbihb55s4t1krltem 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.1642.00.2'
20240923@181049.3002 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.3017 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.3043 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.3061 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.3069 j2e9unu3btbihb55s4t1krltem Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181049.3082 j2e9unu3btbihb55s4t1krltem Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400526200a'
20240923@181049.3095 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.3111 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.3122 j2e9unu3btbihb55s4t1krltem Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3387866f1a1194b','aut66f1a7399766f1a118f3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181049.3126 j2e9unu3btbihb55s4t1krltem Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.3141 j2e9unu3btbihb55s4t1krltem Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.3168 j2e9unu3btbihb55s4t1krltem Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a3387866f1a1194b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut66f1a7399766f1a118f3' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240923@181049.3427 j2e9unu3btbihb55s4t1krltem Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f1a7399766f1a118f3','2406114','wait',39,'adm09112754980.682000002')
20240923@181049.3495 j2e9unu3btbihb55s4t1krltem Query : use flama_phc
20240923@181049.3498 j2e9unu3btbihb55s4t1krltem Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@181049.3527 j2e9unu3btbihb55s4t1krltem Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2145';
20240923@181049.3559 j2e9unu3btbihb55s4t1krltem Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2145';
20240923@181049.3599 j2e9unu3btbihb55s4t1krltem Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2145';
20240923@181049.3642 j2e9unu3btbihb55s4t1krltem Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2145';
20240923@181049.4173 ci0ogsrgavqg7svapboug59fjj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@181049.4185 ci0ogsrgavqg7svapboug59fjj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@181049.4238 ci0ogsrgavqg7svapboug59fjj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2146';
20240923@181049.4293 ci0ogsrgavqg7svapboug59fjj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2146';
20240923@181049.4347 ci0ogsrgavqg7svapboug59fjj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2146';
20240923@181049.4376 ci0ogsrgavqg7svapboug59fjj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2146';
20240923@181049.4424 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.4427 ci0ogsrgavqg7svapboug59fjj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@181049.4493 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.4496 ci0ogsrgavqg7svapboug59fjj Query : select no, estab,szadrsdesc from szadrs where u_coddest=1452
20240923@181049.4575 ci0ogsrgavqg7svapboug59fjj 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'
20240923@181049.4595 ci0ogsrgavqg7svapboug59fjj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406115 and bi.ref ='324.727.00.01' and bi.lordem =1
20240923@181049.4919 ci0ogsrgavqg7svapboug59fjj 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'
20240923@181049.4938 ci0ogsrgavqg7svapboug59fjj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406115 and bi.ref ='324.646.00.01' and bi.lordem =3
20240923@181049.5256 ci0ogsrgavqg7svapboug59fjj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20240923@181049.5276 ci0ogsrgavqg7svapboug59fjj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406115 and bi.ref ='324.1642.00.2' and bi.lordem =4
20240923@181049.5572 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.5576 ci0ogsrgavqg7svapboug59fjj Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@181049.5611 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.5614 ci0ogsrgavqg7svapboug59fjj Query : select top 1 1 valor from td where td.ndoc = 39
20240923@181049.5643 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.5645 ci0ogsrgavqg7svapboug59fjj 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')
20240923@181049.5672 ci0ogsrgavqg7svapboug59fjj 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
20240923@181049.5705 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.5708 ci0ogsrgavqg7svapboug59fjj Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240923@181049.5737 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.5739 ci0ogsrgavqg7svapboug59fjj Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@181049.5767 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.5770 ci0ogsrgavqg7svapboug59fjj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@181049.5809 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.5812 ci0ogsrgavqg7svapboug59fjj Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m. - castelo branco'
20240923@181049.5858 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.5861 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from td where ndoc = 39
20240923@181049.5872 ci0ogsrgavqg7svapboug59fjj Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@181049.5886 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.5903 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181049.5922 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.5936 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181049.5963 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.5977 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181049.5989 ci0ogsrgavqg7svapboug59fjj Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181049.6055 ci0ogsrgavqg7svapboug59fjj Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181049.6067 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.6085 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181049.6102 ci0ogsrgavqg7svapboug59fjj Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f1a7834966f1a11992' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@181049.6283 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.6301 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181049.6333 ci0ogsrgavqg7svapboug59fjj Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@181049.6344 ci0ogsrgavqg7svapboug59fjj Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@181049.6357 ci0ogsrgavqg7svapboug59fjj Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@181049.6368 ci0ogsrgavqg7svapboug59fjj Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@181049.6381 ci0ogsrgavqg7svapboug59fjj Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@181049.6393 ci0ogsrgavqg7svapboug59fjj Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@181049.6404 ci0ogsrgavqg7svapboug59fjj Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f1a7834966f1a11992',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@181049.6640 ci0ogsrgavqg7svapboug59fjj Query : select top 1 fno valor from wsftdata order by fno desc
20240923@181049.6659 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.6674 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181049.6695 ci0ogsrgavqg7svapboug59fjj Query : select 'normal' from dummy
20240923@181049.6710 ci0ogsrgavqg7svapboug59fjj Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f1a7834966f1a11992',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',878,101621,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@181049.6985 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.6988 ci0ogsrgavqg7svapboug59fjj Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240923@181049.7008 ci0ogsrgavqg7svapboug59fjj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240923@181049.7020 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.7035 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.7059 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.7075 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.7083 ci0ogsrgavqg7svapboug59fjj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181049.7094 ci0ogsrgavqg7svapboug59fjj Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2400239200a'
20240923@181049.7106 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.7119 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.7131 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3376966f1a119ad','aut66f1a7834966f1a11992' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181049.7135 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.7151 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.7246 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a3376966f1a119ad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f1a7834966f1a11992' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@181049.7751 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.7771 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.7798 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.7814 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.7823 ci0ogsrgavqg7svapboug59fjj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181049.7836 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.7851 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.7863 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a5718766f1a119bf','aut66f1a7834966f1a11992' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181049.7868 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.7883 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.8167 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a5718766f1a119bf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a7834966f1a11992' ,0,0 ,2,23.00,20000,?,?,?)
20240923@181049.8430 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181049.8433 ci0ogsrgavqg7svapboug59fjj Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240923@181049.8453 ci0ogsrgavqg7svapboug59fjj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20240923@181049.8466 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.8482 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.8506 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.8519 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.8527 ci0ogsrgavqg7svapboug59fjj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181049.8538 ci0ogsrgavqg7svapboug59fjj Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240923@181049.8550 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.8564 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.8575 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a0298566f1a119d0','aut66f1a7834966f1a11992' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181049.8579 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.8593 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.8620 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a0298566f1a119d0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a7834966f1a11992' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240923@181049.8873 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.8890 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181049.8914 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.8928 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.8936 ci0ogsrgavqg7svapboug59fjj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181049.8948 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181049.8962 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181049.9310 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a0985766f1a119da','aut66f1a7834966f1a11992' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181049.9339 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.1150 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.1460 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a0985766f1a119da',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a7834966f1a11992' ,0,0 ,2,23.00,50000,?,?,?)
20240923@181050.4110 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181050.4140 ci0ogsrgavqg7svapboug59fjj Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20240923@181050.4340 ci0ogsrgavqg7svapboug59fjj 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.1642.00.2'
20240923@181050.4480 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.4640 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.4890 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.5040 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.5120 ci0ogsrgavqg7svapboug59fjj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181050.5230 ci0ogsrgavqg7svapboug59fjj Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400526200a'
20240923@181050.5350 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.5490 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.5600 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a1920966f1a11a0d','aut66f1a7834966f1a11992' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181050.5640 ci0ogsrgavqg7svapboug59fjj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.5780 ci0ogsrgavqg7svapboug59fjj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.6060 ci0ogsrgavqg7svapboug59fjj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a1920966f1a11a0d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66f1a7834966f1a11992' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240923@181050.8490 ci0ogsrgavqg7svapboug59fjj Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f1a7834966f1a11992','2406115','wait',39,'adm09112754980.682000002')
20240923@181050.9220 ci0ogsrgavqg7svapboug59fjj Query : use flama_phc
20240923@181050.9250 ci0ogsrgavqg7svapboug59fjj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@181050.9580 ci0ogsrgavqg7svapboug59fjj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2146';
20240923@181050.9870 ci0ogsrgavqg7svapboug59fjj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2146';
20240923@181050.1031 ci0ogsrgavqg7svapboug59fjj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2146';
20240923@181050.1056 ci0ogsrgavqg7svapboug59fjj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2146';
20240923@181050.2068 lcothp696n48k28937q610aubh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@181050.2126 lcothp696n48k28937q610aubh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@181050.2290 lcothp696n48k28937q610aubh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2147';
20240923@181050.2346 lcothp696n48k28937q610aubh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2147';
20240923@181050.2415 lcothp696n48k28937q610aubh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2147';
20240923@181050.2441 lcothp696n48k28937q610aubh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2147';
20240923@181050.2496 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.2498 lcothp696n48k28937q610aubh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@181050.2564 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.2567 lcothp696n48k28937q610aubh Query : select no, estab,szadrsdesc from szadrs where u_coddest=909
20240923@181050.2649 lcothp696n48k28937q610aubh 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'
20240923@181050.2671 lcothp696n48k28937q610aubh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406116 and bi.ref ='324.727.00.01' and bi.lordem =1
20240923@181050.3003 lcothp696n48k28937q610aubh 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'
20240923@181050.3025 lcothp696n48k28937q610aubh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406116 and bi.ref ='324.727.00.01' and bi.lordem =1
20240923@181050.3041 lcothp696n48k28937q610aubh 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'
20240923@181050.3062 lcothp696n48k28937q610aubh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406116 and bi.ref ='324.646.00.01' and bi.lordem =3
20240923@181050.3389 lcothp696n48k28937q610aubh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20240923@181050.3414 lcothp696n48k28937q610aubh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406116 and bi.ref ='324.1642.00.2' and bi.lordem =4
20240923@181050.3747 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.3750 lcothp696n48k28937q610aubh Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@181050.3851 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.3854 lcothp696n48k28937q610aubh Query : select top 1 1 valor from td where td.ndoc = 39
20240923@181050.3885 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.3889 lcothp696n48k28937q610aubh 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')
20240923@181050.3919 lcothp696n48k28937q610aubh 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
20240923@181050.3956 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.3959 lcothp696n48k28937q610aubh Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240923@181050.3989 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.3992 lcothp696n48k28937q610aubh Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@181050.4022 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.4024 lcothp696n48k28937q610aubh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@181050.4066 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.4068 lcothp696n48k28937q610aubh Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - ovar'
20240923@181050.4215 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.4229 lcothp696n48k28937q610aubh Query : select 1 valor from td where ndoc = 39
20240923@181050.4322 lcothp696n48k28937q610aubh Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@181050.4338 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.4381 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181050.4401 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.4420 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181050.4450 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.4467 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181050.4480 lcothp696n48k28937q610aubh Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181050.4546 lcothp696n48k28937q610aubh Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181050.4559 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.4576 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181050.4592 lcothp696n48k28937q610aubh Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f1a6998866f1a11a6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@181050.4809 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.4829 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181050.4861 lcothp696n48k28937q610aubh Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@181050.4873 lcothp696n48k28937q610aubh Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@181050.4885 lcothp696n48k28937q610aubh Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@181050.4897 lcothp696n48k28937q610aubh Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@181050.4910 lcothp696n48k28937q610aubh Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@181050.4924 lcothp696n48k28937q610aubh Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@181050.4936 lcothp696n48k28937q610aubh Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f1a6998866f1a11a6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@181050.5205 lcothp696n48k28937q610aubh Query : select top 1 fno valor from wsftdata order by fno desc
20240923@181050.5226 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.5247 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181050.5270 lcothp696n48k28937q610aubh Query : select 'normal' from dummy
20240923@181050.5291 lcothp696n48k28937q610aubh Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f1a6998866f1a11a6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',879,101621,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@181050.5581 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.5584 lcothp696n48k28937q610aubh Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240923@181050.5606 lcothp696n48k28937q610aubh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240923@181050.5622 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.5645 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.5670 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.5685 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.5694 lcothp696n48k28937q610aubh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181050.5706 lcothp696n48k28937q610aubh Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2400239200a'
20240923@181050.5718 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.5734 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.5746 lcothp696n48k28937q610aubh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3010666f1a11a8b','aut66f1a6998866f1a11a6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181050.5750 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.5765 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.5796 lcothp696n48k28937q610aubh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a3010666f1a11a8b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a6998866f1a11a6d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@181050.6065 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.6085 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.6111 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.6127 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.6136 lcothp696n48k28937q610aubh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181050.6148 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.6162 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.6174 lcothp696n48k28937q610aubh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a4308466f1a11a96','aut66f1a6998866f1a11a6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181050.6178 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.6193 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.6221 lcothp696n48k28937q610aubh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a4308466f1a11a96',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a6998866f1a11a6d' ,0,0 ,2,23.00,20000,?,?,?)
20240923@181050.6472 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.6475 lcothp696n48k28937q610aubh Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240923@181050.6495 lcothp696n48k28937q610aubh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240923@181050.6511 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.6527 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.6556 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.6571 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.6579 lcothp696n48k28937q610aubh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181050.6592 lcothp696n48k28937q610aubh Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2400239200a'
20240923@181050.6605 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.6619 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.6631 lcothp696n48k28937q610aubh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a7868866f1a11aa1','aut66f1a6998866f1a11a6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181050.6635 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.6650 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.6679 lcothp696n48k28937q610aubh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a7868866f1a11aa1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a6998866f1a11a6d' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240923@181050.6940 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.6955 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.6984 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.7000 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.7009 lcothp696n48k28937q610aubh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181050.7021 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.7036 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.7051 lcothp696n48k28937q610aubh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a1980166f1a11aab','aut66f1a6998866f1a11a6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181050.7055 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.7072 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.7104 lcothp696n48k28937q610aubh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a1980166f1a11aab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a6998866f1a11a6d' ,0,0 ,2,23.00,50000,?,?,?)
20240923@181050.7353 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.7356 lcothp696n48k28937q610aubh Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240923@181050.7377 lcothp696n48k28937q610aubh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20240923@181050.7393 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.7409 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.7440 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.7455 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.7464 lcothp696n48k28937q610aubh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181050.7477 lcothp696n48k28937q610aubh Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240923@181050.7490 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.7506 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.7519 lcothp696n48k28937q610aubh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a4684366f1a11ab6','aut66f1a6998866f1a11a6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181050.7525 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.7540 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.7572 lcothp696n48k28937q610aubh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a4684366f1a11ab6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a6998866f1a11a6d' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240923@181050.7893 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.7929 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.8100 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.8120 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.8129 lcothp696n48k28937q610aubh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181050.8145 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.8167 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.8179 lcothp696n48k28937q610aubh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a1268966f1a11ac6','aut66f1a6998866f1a11a6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181050.8183 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.8198 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.8227 lcothp696n48k28937q610aubh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a1268966f1a11ac6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a6998866f1a11a6d' ,0,0 ,2,23.00,80000,?,?,?)
20240923@181050.8497 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.8500 lcothp696n48k28937q610aubh Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20240923@181050.8519 lcothp696n48k28937q610aubh 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.1642.00.2'
20240923@181050.8533 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.8548 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.8576 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.8591 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.8600 lcothp696n48k28937q610aubh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181050.8611 lcothp696n48k28937q610aubh Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400526200a'
20240923@181050.8625 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.8660 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181050.8671 lcothp696n48k28937q610aubh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a0290366f1a11ad2','aut66f1a6998866f1a11a6d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181050.8676 lcothp696n48k28937q610aubh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181050.8693 lcothp696n48k28937q610aubh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181050.8723 lcothp696n48k28937q610aubh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a0290366f1a11ad2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66f1a6998866f1a11a6d' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240923@181050.8986 lcothp696n48k28937q610aubh Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f1a6998866f1a11a6d','2406116','wait',39,'adm09112754980.682000002')
20240923@181050.9057 lcothp696n48k28937q610aubh Query : use flama_phc
20240923@181050.9062 lcothp696n48k28937q610aubh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@181050.9106 lcothp696n48k28937q610aubh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2147';
20240923@181051.2820 lcothp696n48k28937q610aubh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2147';
20240923@181051.3260 lcothp696n48k28937q610aubh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2147';
20240923@181051.3590 lcothp696n48k28937q610aubh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2147';
20240923@181051.8810 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@181051.8930 jv0qcn88pmne1iva1k7fr5oov0 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@181051.9580 jv0qcn88pmne1iva1k7fr5oov0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2148';
20240923@181051.1024 jv0qcn88pmne1iva1k7fr5oov0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2148';
20240923@181051.1077 jv0qcn88pmne1iva1k7fr5oov0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2148';
20240923@181051.1112 jv0qcn88pmne1iva1k7fr5oov0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2148';
20240923@181051.1163 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.1166 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@181051.1240 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.1243 jv0qcn88pmne1iva1k7fr5oov0 Query : select no, estab,szadrsdesc from szadrs where u_coddest=908
20240923@181051.1340 jv0qcn88pmne1iva1k7fr5oov0 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'
20240923@181051.1364 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406117 and bi.ref ='324.727.00.01' and bi.lordem =1
20240923@181051.1720 jv0qcn88pmne1iva1k7fr5oov0 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'
20240923@181051.1744 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406117 and bi.ref ='324.646.00.01' and bi.lordem =3
20240923@181051.2059 jv0qcn88pmne1iva1k7fr5oov0 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'
20240923@181051.2080 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406117 and bi.ref ='324.646.00.01' and bi.lordem =3
20240923@181051.2113 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.719.00.01'
20240923@181051.2137 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406117 and bi.ref ='324.719.00.01' and bi.lordem =4
20240923@181051.2617 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20240923@181051.2645 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406117 and bi.ref ='324.1642.00.2' and bi.lordem =5
20240923@181051.2977 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.2980 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@181051.3013 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.3016 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 1 valor from td where td.ndoc = 39
20240923@181051.3051 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.3054 jv0qcn88pmne1iva1k7fr5oov0 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')
20240923@181051.3081 jv0qcn88pmne1iva1k7fr5oov0 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
20240923@181051.3114 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.3117 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240923@181051.3162 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.3164 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@181051.3193 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.3196 jv0qcn88pmne1iva1k7fr5oov0 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@181051.3237 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.3240 jv0qcn88pmne1iva1k7fr5oov0 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda-aveiro'
20240923@181051.3286 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.3288 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from td where ndoc = 39
20240923@181051.3300 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@181051.3313 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.3345 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181051.3364 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.3380 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181051.3411 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.3425 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181051.3438 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181051.3503 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181051.3514 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.3541 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181051.3556 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f1a9149066f1a11b53' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@181051.3783 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.3800 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181051.3836 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@181051.3847 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@181051.3859 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@181051.3870 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@181051.3882 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@181051.3893 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@181051.3904 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f1a9149066f1a11b53',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@181051.4143 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 fno valor from wsftdata order by fno desc
20240923@181051.4179 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.4194 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181051.4216 jv0qcn88pmne1iva1k7fr5oov0 Query : select 'normal' from dummy
20240923@181051.4231 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f1a9149066f1a11b53',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',880,101621,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@181051.4577 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.4580 jv0qcn88pmne1iva1k7fr5oov0 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240923@181051.4600 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240923@181051.4613 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.4628 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.4654 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.4669 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.4678 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181051.4690 jv0qcn88pmne1iva1k7fr5oov0 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2400239200a'
20240923@181051.4723 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.4755 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.4766 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a2369466f1a11b73','aut66f1a9149066f1a11b53' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181051.4770 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.4785 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.4815 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a2369466f1a11b73',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a9149066f1a11b53' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@181051.5089 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.5105 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.5149 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.5165 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.5177 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181051.5189 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.5205 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.5217 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a6623966f1a11b7e','aut66f1a9149066f1a11b53' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181051.5221 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.5236 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.5267 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a6623966f1a11b7e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a9149066f1a11b53' ,0,0 ,2,23.00,20000,?,?,?)
20240923@181051.5533 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.5537 jv0qcn88pmne1iva1k7fr5oov0 Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240923@181051.5556 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20240923@181051.5572 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.5587 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.5612 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.5626 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.5635 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181051.5646 jv0qcn88pmne1iva1k7fr5oov0 Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240923@181051.5658 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.5672 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.5684 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a8379966f1a11b8a','aut66f1a9149066f1a11b53' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181051.5688 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.5724 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.5754 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a8379966f1a11b8a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66f1a9149066f1a11b53' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240923@181051.6018 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.6034 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.6081 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.6097 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.6108 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181051.6120 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.6139 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.6151 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a8915066f1a11b95','aut66f1a9149066f1a11b53' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181051.6155 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.6170 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.6198 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a8915066f1a11b95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a9149066f1a11b53' ,0,0 ,2,23.00,50000,?,?,?)
20240923@181051.6460 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.6465 jv0qcn88pmne1iva1k7fr5oov0 Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240923@181051.6484 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20240923@181051.6500 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.6514 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.6544 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.6559 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.6568 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181051.6580 jv0qcn88pmne1iva1k7fr5oov0 Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240923@181051.6592 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.6606 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.6617 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a9865766f1a11ba0','aut66f1a9149066f1a11b53' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181051.6622 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.6636 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.6678 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a9865766f1a11ba0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a9149066f1a11b53' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240923@181051.6952 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.6967 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.6992 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.7007 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.7016 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181051.7028 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.7056 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.7068 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a5524366f1a11bab','aut66f1a9149066f1a11b53' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181051.7075 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.7090 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.7120 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a5524366f1a11bab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a9149066f1a11b53' ,0,0 ,2,23.00,80000,?,?,?)
20240923@181051.7356 jv0qcn88pmne1iva1k7fr5oov0 Query : use flama_phc
20240923@181051.7359 jv0qcn88pmne1iva1k7fr5oov0 Query : select st.usalote valor from st where st.ref = '324.719.00.01'
20240923@181051.7378 jv0qcn88pmne1iva1k7fr5oov0 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.719.00.01'
20240923@181051.7391 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.7419 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.7445 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.7461 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.7469 jv0qcn88pmne1iva1k7fr5oov0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181051.7482 jv0qcn88pmne1iva1k7fr5oov0 Query : select sestamp valor from se where ref ='324.719.00.01' and lote = 'r2300383300a'
20240923@181051.7494 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.7508 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181051.7522 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a8274866f1a11bb6','aut66f1a9149066f1a11b53' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181051.7526 jv0qcn88pmne1iva1k7fr5oov0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181051.7540 jv0qcn88pmne1iva1k7fr5oov0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181051.7567 jv0qcn88pmne1iva1k7fr5oov0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a8274866f1a11bb6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f1a9149066f1a11b53' ,0,0 ,2,23.00,100000,?,?,?,?,?)
