20240728@233850.9694 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233850.9713 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233850.9747 vlopomjgstnbkvb3qur98j0b2p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c4578866a6c87aeb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66a6c9300766a6c879e7' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20240728@233851.4700 vlopomjgstnbkvb3qur98j0b2p Query : use flama_phc
20240728@233851.5100 vlopomjgstnbkvb3qur98j0b2p Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240728@233851.8100 vlopomjgstnbkvb3qur98j0b2p Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240728@233851.1000 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.1180 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233851.1520 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.1710 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233851.1810 vlopomjgstnbkvb3qur98j0b2p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233851.1980 vlopomjgstnbkvb3qur98j0b2p Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240728@233851.2130 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.3340 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233851.3490 vlopomjgstnbkvb3qur98j0b2p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c0800066a6c87b05','aut66a6c9300766a6c879e7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233851.3540 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.4160 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233851.1022 vlopomjgstnbkvb3qur98j0b2p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c0800066a6c87b05',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66a6c9300766a6c879e7' ,0,0 ,2,23.00,170000,?,?,?,?,?)
20240728@233851.1398 vlopomjgstnbkvb3qur98j0b2p Query : use flama_phc
20240728@233851.1403 vlopomjgstnbkvb3qur98j0b2p Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20240728@233851.1427 vlopomjgstnbkvb3qur98j0b2p Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2066.00.1'
20240728@233851.1636 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.1657 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233851.1690 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.1714 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233851.1726 vlopomjgstnbkvb3qur98j0b2p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233851.1740 vlopomjgstnbkvb3qur98j0b2p Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20240728@233851.1766 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.1784 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233851.1798 vlopomjgstnbkvb3qur98j0b2p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c0013366a6c87b2b','aut66a6c9300766a6c879e7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233851.1803 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.1824 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233851.1863 vlopomjgstnbkvb3qur98j0b2p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c0013366a6c87b2b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a6c9300766a6c879e7' ,0,0 ,2,23.00,180000,?,?,?,?,?)
20240728@233851.2168 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.2189 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233851.2221 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.2238 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233851.2254 vlopomjgstnbkvb3qur98j0b2p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233851.2270 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.2288 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233851.2302 vlopomjgstnbkvb3qur98j0b2p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c2753066a6c87b37','aut66a6c9300766a6c879e7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233851.2308 vlopomjgstnbkvb3qur98j0b2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233851.2326 vlopomjgstnbkvb3qur98j0b2p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233851.2363 vlopomjgstnbkvb3qur98j0b2p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c2753066a6c87b37',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c9300766a6c879e7' ,0,0 ,2,23.00,190000,?,?,?)
20240728@233851.2656 vlopomjgstnbkvb3qur98j0b2p Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a6c9300766a6c879e7','2404973','wait',39,'adm09112754980.682000002')
20240728@233851.2750 vlopomjgstnbkvb3qur98j0b2p Query : use flama_phc
20240728@233851.2753 vlopomjgstnbkvb3qur98j0b2p Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240728@233851.2796 vlopomjgstnbkvb3qur98j0b2p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1192';
20240728@233851.2831 vlopomjgstnbkvb3qur98j0b2p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1192';
20240728@233851.2871 vlopomjgstnbkvb3qur98j0b2p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1192';
20240728@233851.2894 vlopomjgstnbkvb3qur98j0b2p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1192';
20240728@233851.3418 q1t70g6blm3gmatgpar55qt296 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240728@233851.3429 q1t70g6blm3gmatgpar55qt296 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240728@233851.3481 q1t70g6blm3gmatgpar55qt296 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1193';
20240728@233851.3533 q1t70g6blm3gmatgpar55qt296 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1193';
20240728@233851.3585 q1t70g6blm3gmatgpar55qt296 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1193';
20240728@233851.3611 q1t70g6blm3gmatgpar55qt296 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1193';
20240728@233851.3656 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233851.3660 q1t70g6blm3gmatgpar55qt296 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240728@233851.3740 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233851.3743 q1t70g6blm3gmatgpar55qt296 Query : select no, estab,szadrsdesc from szadrs where u_coddest=201
20240728@233851.3783 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1675.3015'
20240728@233851.3805 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='325.1675.3015' and bi.lordem =1
20240728@233851.4153 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1536.00.1'
20240728@233851.4327 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.1536.00.1' and bi.lordem =2
20240728@233851.4667 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240728@233851.4838 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.645.00.01' and bi.lordem =3
20240728@233851.5182 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240728@233851.5206 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.645.00.01' and bi.lordem =3
20240728@233851.5224 q1t70g6blm3gmatgpar55qt296 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'
20240728@233851.5399 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.646.00.01' and bi.lordem =4
20240728@233851.5833 q1t70g6blm3gmatgpar55qt296 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'
20240728@233851.5896 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.646.00.01' and bi.lordem =4
20240728@233851.5918 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5500.00.1'
20240728@233851.6314 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.5500.00.1' and bi.lordem =5
20240728@233851.6737 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4020.00.1'
20240728@233851.6914 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='304.4020.00.1' and bi.lordem =6
20240728@233851.7377 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4521.00.1'
20240728@233851.7567 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.4521.00.1' and bi.lordem =7
20240728@233851.7926 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240728@233851.7947 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='304.4320.00.1' and bi.lordem =8
20240728@233851.8295 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240728@233851.8316 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='304.421.00.04' and bi.lordem =9
20240728@233851.8654 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4906.00.1'
20240728@233851.8817 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.4906.00.1' and bi.lordem =10
20240728@233851.9149 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1461.00.1'
20240728@233851.9322 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.1461.00.1' and bi.lordem =11
20240728@233851.9666 q1t70g6blm3gmatgpar55qt296 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240728@233851.9841 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404974 and bi.ref ='324.958.00.01' and bi.lordem =12
20240728@233852.1810 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.1840 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240728@233852.2590 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.9160 q1t70g6blm3gmatgpar55qt296 Query : select top 1 1 valor from td where td.ndoc = 39
20240728@233852.9830 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.9940 q1t70g6blm3gmatgpar55qt296 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')
20240728@233852.2200 q1t70g6blm3gmatgpar55qt296 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
20240728@233852.2242 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.2247 q1t70g6blm3gmatgpar55qt296 Query : select top 1 ~inactivo valor from cl where no = '100080' and estab = 0 order by inactivo desc
20240728@233852.2282 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.2286 q1t70g6blm3gmatgpar55qt296 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240728@233852.2324 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.2329 q1t70g6blm3gmatgpar55qt296 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240728@233852.2375 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.2380 q1t70g6blm3gmatgpar55qt296 Query : select szadrsstamp valor from szadrs where szadrsdesc='sorefoz - electrod. e equipamentos, s.a.'
20240728@233852.2439 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.2442 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from td where ndoc = 39
20240728@233852.2459 q1t70g6blm3gmatgpar55qt296 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240728@233852.2478 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.2501 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233852.2527 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.2546 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233852.2581 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.2599 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233852.2616 q1t70g6blm3gmatgpar55qt296 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233852.2734 q1t70g6blm3gmatgpar55qt296 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233852.2749 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.2768 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233852.2790 q1t70g6blm3gmatgpar55qt296 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240728@233852.3037 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.3059 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233852.3103 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240728@233852.3169 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240728@233852.3220 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240728@233852.3267 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240728@233852.3346 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240728@233852.3362 q1t70g6blm3gmatgpar55qt296 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240728@233852.3376 q1t70g6blm3gmatgpar55qt296 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a6c4347166a6c87c3f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240728@233852.3704 q1t70g6blm3gmatgpar55qt296 Query : select top 1 fno valor from wsftdata order by fno desc
20240728@233852.3720 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.3740 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233852.3767 q1t70g6blm3gmatgpar55qt296 Query : select 'normal' from dummy
20240728@233852.3792 q1t70g6blm3gmatgpar55qt296 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a6c4347166a6c87c3f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42,100080,0,'2024-07-28',39,'euro',0,0,2024 ,?,?)
20240728@233852.4115 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.4118 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '325.1675.3015'
20240728@233852.4142 q1t70g6blm3gmatgpar55qt296 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '325.1675.3015'
20240728@233852.4159 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.4178 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.4207 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.4224 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.4234 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.4247 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='325.1675.3015' and lote = '801'
20240728@233852.4261 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.4277 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.4290 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1338566a6c87c68','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.4295 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.4312 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.4343 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c1338566a6c87c68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240728@233852.4624 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.4627 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.1536.00.1'
20240728@233852.4650 q1t70g6blm3gmatgpar55qt296 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1536.00.1'
20240728@233852.4817 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.4835 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.4867 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.4882 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.4896 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.4912 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.1536.00.1' and lote = 'r2100240100a'
20240728@233852.4955 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.4972 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.4986 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c2741966a6c87c78','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.4990 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.5008 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.5042 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c2741966a6c87c78',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240728@233852.5317 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.5321 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.645.00.01'
20240728@233852.5346 q1t70g6blm3gmatgpar55qt296 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.645.00.01'
20240728@233852.5506 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.5526 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.5555 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.5571 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.5581 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.5596 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2400055200a'
20240728@233852.5620 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.5638 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.5652 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c7546866a6c87c89','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.5656 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.5674 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.5706 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c7546866a6c87c89',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240728@233852.5996 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.6016 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.6049 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.6066 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.6082 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.6099 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.6117 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.6130 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c6172166a6c87c94','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.6136 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.6153 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.6192 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c6172166a6c87c94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,40000,?,?,?)
20240728@233852.6474 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.6478 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.645.00.01'
20240728@233852.6501 q1t70g6blm3gmatgpar55qt296 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.645.00.01'
20240728@233852.6523 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.6542 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.6573 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.6591 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.6601 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.6618 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2400055200a'
20240728@233852.6636 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.6652 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.6667 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c4762566a6c87ca2','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.6672 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.6688 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.6720 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c4762566a6c87ca2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240728@233852.7017 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.7037 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.7070 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.7086 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.7096 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.7126 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.7145 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.7160 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1491466a6c87cad','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.7165 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.7181 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.7215 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c1491466a6c87cad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,70000,?,?,?)
20240728@233852.7519 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.7522 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240728@233852.7546 q1t70g6blm3gmatgpar55qt296 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'
20240728@233852.7802 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.7821 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.7850 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.7866 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.7876 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.7889 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240728@233852.7906 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.7922 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.7937 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c6294266a6c87cc1','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.7941 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.7958 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.7995 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c6294266a6c87cc1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20240728@233852.8268 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.8285 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.8312 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.8331 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.8341 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.8354 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.8369 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.8381 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c2386466a6c87ccb','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.8386 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.8401 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.8433 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c2386466a6c87ccb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,100000,?,?,?)
20240728@233852.8705 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233852.8708 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240728@233852.8728 q1t70g6blm3gmatgpar55qt296 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'
20240728@233852.8742 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.8759 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.8785 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.8803 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.8813 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.8828 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240728@233852.8840 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.8855 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.8868 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c7702566a6c87cd7','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.8879 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.8895 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.8924 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c7702566a6c87cd7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20240728@233852.9206 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.9222 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.9251 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.9266 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.9275 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233852.9290 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.9306 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233852.9320 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c9964166a6c87ce2','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233852.9324 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233852.9956 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233852.9990 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c9964166a6c87ce2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,130000,?,?,?)
20240728@233853.2690 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.2730 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.5500.00.1'
20240728@233853.2960 q1t70g6blm3gmatgpar55qt296 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.5500.00.1'
20240728@233853.4510 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.4930 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.5260 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.5450 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.5870 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.6060 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.5500.00.1' and lote = 'r2301223200a'
20240728@233853.6400 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6620 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.6800 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c9666566a6c87d0f','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.6870 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.7170 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.7590 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c9666566a6c87d0f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,150000,?,?,?,?,?)
20240728@233853.1091 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.1096 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '304.4020.00.1'
20240728@233853.1121 q1t70g6blm3gmatgpar55qt296 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4020.00.1'
20240728@233853.1287 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.1310 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.1342 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.1365 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.1375 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.1391 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='304.4020.00.1' and lote = '240409'
20240728@233853.1426 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.1443 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.1462 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1593466a6c87d22','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.1467 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.1489 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.1527 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c1593466a6c87d22',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20240728@233853.1889 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.1893 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20240728@233853.1919 q1t70g6blm3gmatgpar55qt296 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.4521.00.1'
20240728@233853.2084 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.2104 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.2152 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.2171 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.2181 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.2203 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400052200a'
20240728@233853.2220 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.2237 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.2252 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c9254266a6c87d36','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.2258 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.2278 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.2314 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c9254266a6c87d36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,170000,?,?,?,?,?)
20240728@233853.2624 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.2628 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240728@233853.2653 q1t70g6blm3gmatgpar55qt296 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240728@233853.2669 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.2688 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.2720 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.2739 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.2755 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.2773 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240897'
20240728@233853.2787 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.2805 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.2820 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1255566a6c87d44','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.2826 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.2843 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.2881 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c1255566a6c87d44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,180000,?,?,?,?,?)
20240728@233853.3151 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.3154 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240728@233853.3181 q1t70g6blm3gmatgpar55qt296 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240728@233853.3198 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.3712 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.4412 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.4437 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.4448 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.4463 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240728@233853.4478 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.4494 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.4581 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c0182266a6c87d6d','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.4586 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.4604 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.4638 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c0182266a6c87d6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20240728@233853.5080 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.5105 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.5137 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.5221 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.5268 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.5322 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.5340 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.5357 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c5545366a6c87d81','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.5362 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.5381 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.5419 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c5545366a6c87d81',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,200000,?,?,?)
20240728@233853.5766 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.5770 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.4906.00.1'
20240728@233853.5795 q1t70g6blm3gmatgpar55qt296 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.4906.00.1'
20240728@233853.5959 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.5978 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.6013 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6032 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.6042 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.6058 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.4906.00.1' and lote = 'r2300207200a'
20240728@233853.6089 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6116 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.6130 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c0608266a6c87d94','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.6135 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6156 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.6201 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c0608266a6c87d94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20240728@233853.6478 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6499 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.6528 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6546 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.6557 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.6573 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6592 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.6607 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c9916066a6c87da0','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.6613 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6631 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.6667 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c9916066a6c87da0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,230000,?,?,?)
20240728@233853.6950 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.6954 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.1461.00.1'
20240728@233853.6979 q1t70g6blm3gmatgpar55qt296 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.1461.00.1'
20240728@233853.7143 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.7164 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.9100 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9120 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.9129 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.9142 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.1461.00.1' and lote = 'r2100463200a'
20240728@233853.9157 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9174 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.9188 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c2921566a6c87ddf','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.9192 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9208 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.9240 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c2921566a6c87ddf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20240728@233853.9516 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.9520 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240728@233853.9541 q1t70g6blm3gmatgpar55qt296 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.958.00.01'
20240728@233853.9694 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9711 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.9741 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9758 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.9768 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.9782 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240728@233853.9803 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9820 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.9834 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c8442266a6c87def','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.9838 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9853 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.9884 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c8442266a6c87def',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,260000,?,?,?,?,?)
20240728@233854.1610 q1t70g6blm3gmatgpar55qt296 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a6c4347166a6c87c3f','2404974','wait',39,'adm09112754980.682000002')
20240728@233854.2360 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233854.2400 q1t70g6blm3gmatgpar55qt296 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240728@233854.2750 q1t70g6blm3gmatgpar55qt296 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1193';
20240728@233854.3020 q1t70g6blm3gmatgpar55qt296 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1193';
20240728@233854.3390 q1t70g6blm3gmatgpar55qt296 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1193';
20240728@233854.3650 q1t70g6blm3gmatgpar55qt296 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1193';
20240728@233854.8620 he4ff5rok34opbfa2fbtrh947u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240728@233854.8730 he4ff5rok34opbfa2fbtrh947u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240728@233854.9270 he4ff5rok34opbfa2fbtrh947u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1194';
20240728@233854.9810 he4ff5rok34opbfa2fbtrh947u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1194';
20240728@233854.1029 he4ff5rok34opbfa2fbtrh947u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1194';
20240728@233854.1053 he4ff5rok34opbfa2fbtrh947u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1194';
20240728@233854.1171 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.1175 he4ff5rok34opbfa2fbtrh947u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240728@233854.1251 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.1254 he4ff5rok34opbfa2fbtrh947u Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240728@233854.1530 he4ff5rok34opbfa2fbtrh947u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20240728@233854.1718 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404981 and bi.ref ='324.1667.00.1' and bi.lordem =1
20240728@233854.2179 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2184 he4ff5rok34opbfa2fbtrh947u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240728@233854.2222 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2226 he4ff5rok34opbfa2fbtrh947u Query : select top 1 1 valor from td where td.ndoc = 39
20240728@233854.2260 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2264 he4ff5rok34opbfa2fbtrh947u 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')
20240728@233854.2299 he4ff5rok34opbfa2fbtrh947u 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
20240728@233854.2338 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2342 he4ff5rok34opbfa2fbtrh947u Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240728@233854.2483 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2487 he4ff5rok34opbfa2fbtrh947u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240728@233854.2521 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2525 he4ff5rok34opbfa2fbtrh947u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240728@233854.2572 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2576 he4ff5rok34opbfa2fbtrh947u Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240728@233854.2647 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2651 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from td where ndoc = 39
20240728@233854.2666 he4ff5rok34opbfa2fbtrh947u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240728@233854.2684 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.2704 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233854.2727 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.2744 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233854.2778 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.2795 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233854.2810 he4ff5rok34opbfa2fbtrh947u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233854.2883 he4ff5rok34opbfa2fbtrh947u Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233854.2899 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.3952 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233854.4046 he4ff5rok34opbfa2fbtrh947u Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a6c5533066a6c87e44' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240728@233854.4226 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.4246 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233854.4283 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240728@233854.4297 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240728@233854.4310 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240728@233854.4324 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240728@233854.4338 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240728@233854.4353 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240728@233854.4367 he4ff5rok34opbfa2fbtrh947u Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a6c5533066a6c87e44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240728@233854.4614 he4ff5rok34opbfa2fbtrh947u Query : select top 1 fno valor from wsftdata order by fno desc
20240728@233854.4631 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.4650 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233854.4675 he4ff5rok34opbfa2fbtrh947u Query : select 'normal' from dummy
20240728@233854.4693 he4ff5rok34opbfa2fbtrh947u Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a6c5533066a6c87e44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',43,100810,0,'2024-07-28',39,'euro',0,0,2024 ,?,?)
20240728@233854.4985 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.4988 he4ff5rok34opbfa2fbtrh947u Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20240728@233854.5015 he4ff5rok34opbfa2fbtrh947u 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.1667.00.1'
20240728@233854.5173 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5192 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233854.5226 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5246 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233854.5256 he4ff5rok34opbfa2fbtrh947u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233854.5271 he4ff5rok34opbfa2fbtrh947u Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2400065200a'
20240728@233854.5288 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5305 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233854.5321 he4ff5rok34opbfa2fbtrh947u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c6102766a6c87e81','aut66a6c5533066a6c87e44' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233854.5326 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5343 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233854.5378 he4ff5rok34opbfa2fbtrh947u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c6102766a6c87e81',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66a6c5533066a6c87e44' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240728@233854.5651 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5673 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233854.5703 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5719 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233854.5729 he4ff5rok34opbfa2fbtrh947u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233854.5745 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5763 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233854.5778 he4ff5rok34opbfa2fbtrh947u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c6330366a6c87e8c','aut66a6c5533066a6c87e44' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233854.5782 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5798 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233854.5832 he4ff5rok34opbfa2fbtrh947u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c6330366a6c87e8c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c5533066a6c87e44' ,0,0 ,2,23.00,20000,?,?,?)
20240728@233854.6086 he4ff5rok34opbfa2fbtrh947u Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a6c5533066a6c87e44','2404981','wait',39,'adm09112754980.682000002')
20240728@233854.6163 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.6167 he4ff5rok34opbfa2fbtrh947u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240728@233854.6202 he4ff5rok34opbfa2fbtrh947u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1194';
20240728@233854.6229 he4ff5rok34opbfa2fbtrh947u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1194';
20240728@233854.6266 he4ff5rok34opbfa2fbtrh947u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1194';
20240728@233854.6288 he4ff5rok34opbfa2fbtrh947u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1194';
20240728@233854.6814 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240728@233854.6825 lb3ksk2ifc640h0nntv7gcmc93 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240728@233854.6878 lb3ksk2ifc640h0nntv7gcmc93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1195';
20240728@233854.6932 lb3ksk2ifc640h0nntv7gcmc93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1195';
20240728@233854.7061 lb3ksk2ifc640h0nntv7gcmc93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1195';
20240728@233854.7089 lb3ksk2ifc640h0nntv7gcmc93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1195';
20240728@233854.7142 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7146 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240728@233854.7215 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7218 lb3ksk2ifc640h0nntv7gcmc93 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240728@233854.7259 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1684.00.1'
20240728@233854.7443 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404982 and bi.ref ='324.1684.00.1' and bi.lordem =1
20240728@233854.7771 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7775 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240728@233854.7812 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7816 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 1 valor from td where td.ndoc = 39
20240728@233854.7849 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7852 lb3ksk2ifc640h0nntv7gcmc93 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')
20240728@233854.7884 lb3ksk2ifc640h0nntv7gcmc93 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
20240728@233854.7920 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7923 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240728@233854.8099 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.8103 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240728@233854.8253 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.8256 lb3ksk2ifc640h0nntv7gcmc93 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240728@233854.8348 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.8352 lb3ksk2ifc640h0nntv7gcmc93 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240728@233854.8397 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.8399 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from td where ndoc = 39
20240728@233854.8413 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240728@233854.8427 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8444 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233854.8465 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8564 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233854.8597 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8614 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233854.8630 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233854.8705 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233854.8718 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8735 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233854.8753 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a6c1221366a6c87ed2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240728@233854.8936 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8959 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233854.8996 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240728@233854.9013 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240728@233854.9028 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240728@233854.9042 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240728@233854.9056 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240728@233854.9069 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240728@233854.9081 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a6c1221366a6c87ed2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240728@233854.9431 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 fno valor from wsftdata order by fno desc
20240728@233854.9458 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.9478 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233854.9502 lb3ksk2ifc640h0nntv7gcmc93 Query : select 'normal' from dummy
20240728@233854.9520 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a6c1221366a6c87ed2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',44,100810,0,'2024-07-28',39,'euro',0,0,2024 ,?,?)
20240728@233854.9823 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.9826 lb3ksk2ifc640h0nntv7gcmc93 Query : select st.usalote valor from st where st.ref = '324.1684.00.1'
20240728@233854.9850 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1684.00.1'
20240728@233855.1160 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.1370 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.1710 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.1900 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.2000 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233855.2160 lb3ksk2ifc640h0nntv7gcmc93 Query : select sestamp valor from se where ref ='324.1684.00.1' and lote = 'r2301217200a'
20240728@233855.2320 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.2500 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.2640 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c7361866a6c87f05','aut66a6c1221366a6c87ed2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233855.2690 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.2880 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.3260 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c7361866a6c87f05',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66a6c1221366a6c87ed2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240728@233855.6150 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a6c1221366a6c87ed2','2404982','wait',39,'adm09112754980.682000002')
20240728@233855.6960 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233855.6990 lb3ksk2ifc640h0nntv7gcmc93 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240728@233855.7320 lb3ksk2ifc640h0nntv7gcmc93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1195';
20240728@233855.7950 lb3ksk2ifc640h0nntv7gcmc93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1195';
20240728@233855.8920 lb3ksk2ifc640h0nntv7gcmc93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1195';
20240728@233855.9170 lb3ksk2ifc640h0nntv7gcmc93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1195';
20240728@233855.2634 243kb2n7bb7no0s70v2aeod25d Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240728@233855.2645 243kb2n7bb7no0s70v2aeod25d Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240728@233855.2694 243kb2n7bb7no0s70v2aeod25d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1196';
20240728@233855.2956 243kb2n7bb7no0s70v2aeod25d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1196';
20240728@233855.3004 243kb2n7bb7no0s70v2aeod25d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1196';
20240728@233855.3027 243kb2n7bb7no0s70v2aeod25d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1196';
20240728@233855.3169 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.3172 243kb2n7bb7no0s70v2aeod25d Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240728@233855.3239 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.3242 243kb2n7bb7no0s70v2aeod25d Query : select no, estab,szadrsdesc from szadrs where u_coddest=635
20240728@233855.3381 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20240728@233855.3629 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.5342.00.1' and bi.lordem =1
20240728@233855.4131 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20240728@233855.4154 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.5342.00.1' and bi.lordem =2
20240728@233855.4472 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20240728@233855.4620 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.1816.00.1' and bi.lordem =4
20240728@233855.4909 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240728@233855.5048 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.1879.00.1' and bi.lordem =5
20240728@233855.5336 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240728@233855.5465 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.2031.00.1' and bi.lordem =6
20240728@233855.5755 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240728@233855.5774 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.2066.00.1' and bi.lordem =7
20240728@233855.6057 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240728@233855.6079 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.2066.00.1' and bi.lordem =7
20240728@233855.6097 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6100 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240728@233855.6131 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6134 243kb2n7bb7no0s70v2aeod25d Query : select top 1 1 valor from td where td.ndoc = 39
20240728@233855.6162 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6165 243kb2n7bb7no0s70v2aeod25d 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')
20240728@233855.6196 243kb2n7bb7no0s70v2aeod25d 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
20240728@233855.6232 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6235 243kb2n7bb7no0s70v2aeod25d Query : select top 1 ~inactivo valor from cl where no = '100053' and estab = 0 order by inactivo desc
20240728@233855.6358 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6361 243kb2n7bb7no0s70v2aeod25d Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240728@233855.6391 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6394 243kb2n7bb7no0s70v2aeod25d Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240728@233855.6434 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6437 243kb2n7bb7no0s70v2aeod25d Query : select szadrsstamp valor from szadrs where szadrsdesc='irmaos peixoto, s.a.'
20240728@233855.6484 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6487 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from td where ndoc = 39
20240728@233855.6501 243kb2n7bb7no0s70v2aeod25d Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240728@233855.6515 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6530 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233855.6549 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6566 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233855.6600 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6616 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233855.6629 243kb2n7bb7no0s70v2aeod25d Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233855.6702 243kb2n7bb7no0s70v2aeod25d Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233855.6716 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6732 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233855.6747 243kb2n7bb7no0s70v2aeod25d Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240728@233855.6954 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6970 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233855.7001 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240728@233855.7013 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240728@233855.7024 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240728@233855.7035 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240728@233855.7046 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240728@233855.7058 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240728@233855.7070 243kb2n7bb7no0s70v2aeod25d Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a6c3274466a6c87fa1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240728@233855.7354 243kb2n7bb7no0s70v2aeod25d Query : select top 1 fno valor from wsftdata order by fno desc
20240728@233855.8485 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.8504 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233855.8526 243kb2n7bb7no0s70v2aeod25d Query : select 'normal' from dummy
20240728@233855.8541 243kb2n7bb7no0s70v2aeod25d Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a6c3274466a6c87fa1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',45,100053,0,'2024-07-28',39,'euro',0,0,2024 ,?,?)
20240728@233855.8874 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.8877 243kb2n7bb7no0s70v2aeod25d Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240728@233855.8899 243kb2n7bb7no0s70v2aeod25d 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.5342.00.1'
20240728@233855.9050 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9067 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9091 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9105 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9113 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233855.9125 243kb2n7bb7no0s70v2aeod25d Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2300915100a'
20240728@233855.9137 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9152 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9164 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c2133766a6c87fdf','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233855.9174 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9188 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9214 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c2133766a6c87fdf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240728@233855.9487 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9503 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9528 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9541 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9549 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233855.9561 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9575 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9586 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c0716866a6c87fe9','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233855.9590 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9604 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9632 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c0716866a6c87fe9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,20000,?,?,?)
20240728@233855.9875 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.9879 243kb2n7bb7no0s70v2aeod25d Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240728@233855.9898 243kb2n7bb7no0s70v2aeod25d 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.5342.00.1'
20240728@233855.9912 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9929 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9954 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9970 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9979 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233855.9991 243kb2n7bb7no0s70v2aeod25d Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2300915100a'
20240728@233856.4000 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.2000 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.3300 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1830566a6c88000','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233856.3700 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.5200 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.7900 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c1830566a6c88000',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240728@233856.3420 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.3560 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.4060 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.4210 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.4290 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233856.4420 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.4560 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.4670 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c6602066a6c8800a','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233856.4710 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.4850 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.5120 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c6602066a6c8800a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,50000,?,?,?)
20240728@233856.7480 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233856.7510 243kb2n7bb7no0s70v2aeod25d Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240728@233856.7700 243kb2n7bb7no0s70v2aeod25d 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.1816.00.1'
20240728@233856.9120 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.9280 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.9530 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.9780 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.9860 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233856.9980 243kb2n7bb7no0s70v2aeod25d Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400198200a'
20240728@233856.1012 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1028 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.1040 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1070666a6c88018','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233856.1045 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1060 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.1088 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c1070666a6c88018',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240728@233856.1491 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1508 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.1535 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1551 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.1559 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233856.1572 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1587 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.1599 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1267566a6c88026','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233856.1604 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1619 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.1651 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c1267566a6c88026',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,80000,?,?,?)
20240728@233856.1928 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233856.1932 243kb2n7bb7no0s70v2aeod25d Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240728@233856.1953 243kb2n7bb7no0s70v2aeod25d 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.1879.00.1'
20240728@233856.2098 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.2114 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
