20240923@074631.2883 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406065 and bi.ref ='324.4960.00.1' and bi.lordem =1
20240923@074631.3979 krmndpfjma0kfaik55dlcq2hdf 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'
20240923@074631.4278 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406065 and bi.ref ='324.958.00.01' and bi.lordem =2
20240923@074631.4591 krmndpfjma0kfaik55dlcq2hdf 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'
20240923@074631.4613 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406065 and bi.ref ='324.958.00.01' and bi.lordem =2
20240923@074631.4629 krmndpfjma0kfaik55dlcq2hdf 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'
20240923@074631.4649 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406065 and bi.ref ='324.958.00.01' and bi.lordem =2
20240923@074631.4667 krmndpfjma0kfaik55dlcq2hdf 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'
20240923@074631.4817 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406065 and bi.ref ='324.2031.00.1' and bi.lordem =3
20240923@074631.5128 krmndpfjma0kfaik55dlcq2hdf 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'
20240923@074631.5152 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406065 and bi.ref ='324.2031.00.1' and bi.lordem =3
20240923@074631.5169 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.5172 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@074631.5205 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.5208 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 1 valor from td where td.ndoc = 39
20240923@074631.5239 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.5242 krmndpfjma0kfaik55dlcq2hdf Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240923@074631.5270 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240923@074631.5304 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.5307 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 ~inactivo valor from cl where no = '101645' and estab = 0 order by inactivo desc
20240923@074631.5339 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.5342 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@074631.5372 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.5375 krmndpfjma0kfaik55dlcq2hdf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@074631.5413 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.5415 krmndpfjma0kfaik55dlcq2hdf Query : select szadrsstamp valor from szadrs where szadrsdesc='macorlux - electrodomÉsticos, s.a.'
20240923@074631.5461 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.5464 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from td where ndoc = 39
20240923@074631.5476 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@074631.5490 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.5506 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@074631.5525 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.5539 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@074631.5567 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.5581 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@074631.5593 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@074631.5664 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@074631.5676 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.5690 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@074631.5706 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f105254666f10ec788' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@074631.5881 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.5897 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@074631.5953 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@074631.5966 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@074631.5978 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@074631.5989 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@074631.6000 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@074631.6011 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@074631.6022 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f105254666f10ec788',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@074631.6263 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 fno valor from wsftdata order by fno desc
20240923@074631.6282 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.6300 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@074631.6323 krmndpfjma0kfaik55dlcq2hdf Query : select 'normal' from dummy
20240923@074631.6341 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f105254666f10ec788',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',844,101645,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@074631.6625 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.6628 krmndpfjma0kfaik55dlcq2hdf Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20240923@074631.6650 krmndpfjma0kfaik55dlcq2hdf 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.4960.00.1'
20240923@074631.6664 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.6681 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.6710 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.6726 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.6736 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074631.6748 krmndpfjma0kfaik55dlcq2hdf Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20240923@074631.6762 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.6780 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.6792 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f102494766f10ec7a5','aut66f105254666f10ec788' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074631.6797 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.6812 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.6843 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f102494766f10ec7a5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut66f105254666f10ec788' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@074631.7088 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.7091 krmndpfjma0kfaik55dlcq2hdf Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240923@074631.7113 krmndpfjma0kfaik55dlcq2hdf 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'
20240923@074631.7257 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.7273 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.7301 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.7317 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.7326 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074631.7339 krmndpfjma0kfaik55dlcq2hdf Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240923@074631.7352 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.7366 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.7377 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f100769166f10ec7b3','aut66f105254666f10ec788' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074631.7381 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.7396 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.7424 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f100769166f10ec7b3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f105254666f10ec788' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240923@074631.7738 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.7741 krmndpfjma0kfaik55dlcq2hdf Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240923@074631.7761 krmndpfjma0kfaik55dlcq2hdf 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'
20240923@074631.7775 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.7790 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.7824 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.7839 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.7847 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074631.7861 krmndpfjma0kfaik55dlcq2hdf Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240923@074631.7874 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.7889 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.7900 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f105449766f10ec7c0','aut66f105254666f10ec788' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074631.7904 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.7918 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.7946 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f105449766f10ec7c0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',40.000 ,'aut66f105254666f10ec788' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240923@074631.8200 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.8203 krmndpfjma0kfaik55dlcq2hdf Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240923@074631.8222 krmndpfjma0kfaik55dlcq2hdf 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'
20240923@074631.8235 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.8250 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.8281 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.8295 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.8305 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074631.8317 krmndpfjma0kfaik55dlcq2hdf Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240923@074631.8329 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.8343 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.8355 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f109314266f10ec7cb','aut66f105254666f10ec788' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074631.8360 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.8374 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.8402 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f109314266f10ec7cb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut66f105254666f10ec788' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240923@074631.8639 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.8642 krmndpfjma0kfaik55dlcq2hdf Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240923@074631.8661 krmndpfjma0kfaik55dlcq2hdf 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.2031.00.1'
20240923@074631.8808 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.8823 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.8850 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.8864 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.8872 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074631.8883 krmndpfjma0kfaik55dlcq2hdf Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240923@074631.8919 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.8933 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.8945 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f101175266f10ec7d9','aut66f105254666f10ec788' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074631.8949 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.8963 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.8990 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f101175266f10ec7d9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut66f105254666f10ec788' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240923@074631.9262 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.9279 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.9310 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.9325 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.9334 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074631.9348 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.9363 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.9375 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f103753066f10ec7e4','aut66f105254666f10ec788' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074631.9379 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.9393 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.9423 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f103753066f10ec7e4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f105254666f10ec788' ,0,0 ,2,23.00,60000,?,?,?)
20240923@074631.9670 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074631.9673 krmndpfjma0kfaik55dlcq2hdf Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240923@074631.9699 krmndpfjma0kfaik55dlcq2hdf 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.2031.00.1'
20240923@074631.9714 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.9730 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.9758 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.9775 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.9784 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074631.9796 krmndpfjma0kfaik55dlcq2hdf Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240923@074631.9809 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.9822 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074631.9835 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f104662266f10ec7ef','aut66f105254666f10ec788' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074631.9839 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074631.9856 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074631.9885 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f104662266f10ec7ef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',36.000 ,'aut66f105254666f10ec788' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240923@074632.1410 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.1570 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074632.1840 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.1990 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074632.2070 krmndpfjma0kfaik55dlcq2hdf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074632.2190 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.2320 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074632.2440 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f103951466f10ec805','aut66f105254666f10ec788' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074632.2470 krmndpfjma0kfaik55dlcq2hdf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.2610 krmndpfjma0kfaik55dlcq2hdf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074632.2870 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f103951466f10ec805',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f105254666f10ec788' ,0,0 ,2,23.00,90000,?,?,?)
20240923@074632.5370 krmndpfjma0kfaik55dlcq2hdf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f105254666f10ec788','2406065','wait',39,'adm09112754980.682000002')
20240923@074632.6150 krmndpfjma0kfaik55dlcq2hdf Query : use flama_phc
20240923@074632.6190 krmndpfjma0kfaik55dlcq2hdf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@074632.6540 krmndpfjma0kfaik55dlcq2hdf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2111';
20240923@074632.6830 krmndpfjma0kfaik55dlcq2hdf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2111';
20240923@074632.7250 krmndpfjma0kfaik55dlcq2hdf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2111';
20240923@074632.7480 krmndpfjma0kfaik55dlcq2hdf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2111';
20240923@074632.2001 pa9e42ren36rmpq21sn7ahspec Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@074632.2011 pa9e42ren36rmpq21sn7ahspec Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@074632.2067 pa9e42ren36rmpq21sn7ahspec Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2112';
20240923@074632.2119 pa9e42ren36rmpq21sn7ahspec Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2112';
20240923@074632.2178 pa9e42ren36rmpq21sn7ahspec Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2112';
20240923@074632.2203 pa9e42ren36rmpq21sn7ahspec Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2112';
20240923@074632.2253 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.2256 pa9e42ren36rmpq21sn7ahspec Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@074632.2327 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.2332 pa9e42ren36rmpq21sn7ahspec Query : select no, estab,szadrsdesc from szadrs where u_coddest=2064
20240923@074632.2372 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20240923@074632.2531 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.2221.00.1' and bi.lordem =1
20240923@074632.2842 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20240923@074632.2871 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.2221.00.1' and bi.lordem =1
20240923@074632.2887 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20240923@074632.3033 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.2224.00.1' and bi.lordem =2
20240923@074632.3330 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20240923@074632.3352 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.2224.00.1' and bi.lordem =2
20240923@074632.3370 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20240923@074632.3392 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.2221.00.1' and bi.lordem =3
20240923@074632.3687 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2222.00.1'
20240923@074632.3836 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.2222.00.1' and bi.lordem =4
20240923@074632.4143 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4961.00.1'
20240923@074632.4309 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.4961.00.1' and bi.lordem =5
20240923@074632.4634 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4962.00.1'
20240923@074632.4784 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.4962.00.1' and bi.lordem =6
20240923@074632.5094 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4963.00.1'
20240923@074632.5240 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.4963.00.1' and bi.lordem =7
20240923@074632.5618 pa9e42ren36rmpq21sn7ahspec Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4964.00.1'
20240923@074632.5776 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406066 and bi.ref ='324.4964.00.1' and bi.lordem =8
20240923@074632.6087 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.6091 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@074632.6123 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.6126 pa9e42ren36rmpq21sn7ahspec Query : select top 1 1 valor from td where td.ndoc = 39
20240923@074632.6160 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.6163 pa9e42ren36rmpq21sn7ahspec Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240923@074632.6202 pa9e42ren36rmpq21sn7ahspec Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240923@074632.6244 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.6250 pa9e42ren36rmpq21sn7ahspec Query : select top 1 ~inactivo valor from cl where no = '101645' and estab = 0 order by inactivo desc
20240923@074632.6284 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.6287 pa9e42ren36rmpq21sn7ahspec Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@074632.6324 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.6327 pa9e42ren36rmpq21sn7ahspec Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@074632.6385 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.6388 pa9e42ren36rmpq21sn7ahspec Query : select szadrsstamp valor from szadrs where szadrsdesc='macorlux - electrodomÉsticos, s.a.'
20240923@074632.6441 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.6444 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from td where ndoc = 39
20240923@074632.6456 pa9e42ren36rmpq21sn7ahspec Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@074632.6470 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.6486 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@074632.6507 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.6522 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@074632.6552 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.6567 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@074632.6580 pa9e42ren36rmpq21sn7ahspec Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@074632.6647 pa9e42ren36rmpq21sn7ahspec Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@074632.6661 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.6676 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@074632.6694 pa9e42ren36rmpq21sn7ahspec Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@074632.6890 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.6906 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@074632.6939 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@074632.6951 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@074632.6963 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@074632.6974 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@074632.6985 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@074632.6997 pa9e42ren36rmpq21sn7ahspec Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@074632.7009 pa9e42ren36rmpq21sn7ahspec Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f108018766f10ec8a0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@074632.7246 pa9e42ren36rmpq21sn7ahspec Query : select top 1 fno valor from wsftdata order by fno desc
20240923@074632.7264 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.7279 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@074632.7301 pa9e42ren36rmpq21sn7ahspec Query : select 'normal' from dummy
20240923@074632.7317 pa9e42ren36rmpq21sn7ahspec Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f108018766f10ec8a0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',845,101645,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@074632.7598 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.7601 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20240923@074632.7622 pa9e42ren36rmpq21sn7ahspec 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.2221.00.1'
20240923@074632.7804 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.7820 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074632.7845 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.7860 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074632.7869 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074632.7881 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20240923@074632.7919 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.7934 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074632.7946 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f100328666f10ec8c1','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074632.7950 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.7965 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074632.7999 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f100328666f10ec8c1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@074632.8249 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.8252 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20240923@074632.8276 pa9e42ren36rmpq21sn7ahspec 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.2221.00.1'
20240923@074632.8290 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.8306 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074632.8331 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.8345 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074632.8354 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074632.8370 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20240923@074632.8383 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.8399 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074632.8410 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f103279066f10ec8cc','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074632.8414 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074632.8431 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074632.8461 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f103279066f10ec8cc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240923@074632.8700 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074632.8703 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20240923@074632.8726 pa9e42ren36rmpq21sn7ahspec 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.2224.00.1'
20240923@074632.9854 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.4200 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.6700 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.8100 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.9000 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074633.1070 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301280100a'
20240923@074633.1260 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.1400 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.1510 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f109950066f10ec903','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074633.1550 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.1690 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.2010 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f109950066f10ec903',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240923@074633.4540 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074633.4570 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20240923@074633.4740 pa9e42ren36rmpq21sn7ahspec 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.2224.00.1'
20240923@074633.4870 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.5010 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.5240 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.5370 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.5460 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074633.5580 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301280100a'
20240923@074633.5700 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.5850 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.5960 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f105206766f10ec90d','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074633.6000 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.6190 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.6460 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f105206766f10ec90d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240923@074633.8840 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074633.8870 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20240923@074633.9060 pa9e42ren36rmpq21sn7ahspec 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.2221.00.1'
20240923@074633.9190 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.9330 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.9580 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.9720 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.9810 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074633.9930 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20240923@074633.1005 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.1019 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.1030 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f101293366f10ec918','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074633.1034 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.1048 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.1076 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f101293366f10ec918',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240923@074633.1317 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074633.1320 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20240923@074633.1344 pa9e42ren36rmpq21sn7ahspec 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.2222.00.1'
20240923@074633.1485 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.1501 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.1526 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.1541 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.1549 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074633.1561 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2301281400a'
20240923@074633.1577 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.1592 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.1604 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f107220466f10ec926','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074633.1608 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.1622 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.1650 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f107220466f10ec926',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240923@074633.1897 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074633.1900 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.4961.00.1'
20240923@074633.1920 pa9e42ren36rmpq21sn7ahspec 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.4961.00.1'
20240923@074633.2059 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.2073 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.2098 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.2113 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.2121 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074633.2132 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.4961.00.1' and lote = 'r2101092200a'
20240923@074633.2165 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.2178 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.2189 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f106186566f10ec934','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074633.2193 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.2208 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.2236 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f106186566f10ec934',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240923@074633.2503 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074633.2506 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.4962.00.1'
20240923@074633.2526 pa9e42ren36rmpq21sn7ahspec 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.4962.00.1'
20240923@074633.2672 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.2687 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.2712 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.2726 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.2734 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074633.2746 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.4962.00.1' and lote = 'r2101092100a'
20240923@074633.2766 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.2780 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.2791 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f107305266f10ec943','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074633.2796 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.2810 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.2838 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f107305266f10ec943',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240923@074633.3092 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074633.3095 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.4963.00.1'
20240923@074633.3114 pa9e42ren36rmpq21sn7ahspec 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.4963.00.1'
20240923@074633.3264 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.3280 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.3305 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.3319 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.3329 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074633.3341 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.4963.00.1' and lote = 'r2300717200a'
20240923@074633.3368 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.3385 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.3396 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f101991166f10ec952','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074633.3400 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.3417 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.3445 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f101991166f10ec952',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20240923@074633.3687 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074633.3690 pa9e42ren36rmpq21sn7ahspec Query : select st.usalote valor from st where st.ref = '324.4964.00.1'
20240923@074633.3714 pa9e42ren36rmpq21sn7ahspec 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.4964.00.1'
20240923@074633.3850 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.3867 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.3895 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.3911 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.3920 pa9e42ren36rmpq21sn7ahspec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@074633.3932 pa9e42ren36rmpq21sn7ahspec Query : select sestamp valor from se where ref ='324.4964.00.1' and lote = 'r2300717100a'
20240923@074633.3946 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.3960 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@074633.3974 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f101037966f10ec960','aut66f108018766f10ec8a0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@074633.3978 pa9e42ren36rmpq21sn7ahspec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@074633.3994 pa9e42ren36rmpq21sn7ahspec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@074633.4028 pa9e42ren36rmpq21sn7ahspec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f101037966f10ec960',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f108018766f10ec8a0' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240923@074633.4283 pa9e42ren36rmpq21sn7ahspec Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f108018766f10ec8a0','2406066','wait',39,'adm09112754980.682000002')
20240923@074633.4364 pa9e42ren36rmpq21sn7ahspec Query : use flama_phc
20240923@074633.4367 pa9e42ren36rmpq21sn7ahspec Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@074633.4403 pa9e42ren36rmpq21sn7ahspec Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2112';
20240923@074633.4433 pa9e42ren36rmpq21sn7ahspec Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2112';
20240923@074633.4486 pa9e42ren36rmpq21sn7ahspec Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2112';
20240923@074633.4517 pa9e42ren36rmpq21sn7ahspec Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2112';
20240923@074633.5066 4osavbfm1mhu18h295dopjpt1u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@074633.5079 4osavbfm1mhu18h295dopjpt1u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@074633.5141 4osavbfm1mhu18h295dopjpt1u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2113';
20240923@074633.5193 4osavbfm1mhu18h295dopjpt1u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2113';
20240923@074633.5252 4osavbfm1mhu18h295dopjpt1u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2113';
20240923@074633.5276 4osavbfm1mhu18h295dopjpt1u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2113';
20240923@074633.5336 4osavbfm1mhu18h295dopjpt1u Query : use flama_phc
20240923@074633.5338 4osavbfm1mhu18h295dopjpt1u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@074633.5409 4osavbfm1mhu18h295dopjpt1u Query : use flama_phc
20240923@074633.5413 4osavbfm1mhu18h295dopjpt1u Query : select no, estab,szadrsdesc from szadrs where u_coddest=2064
20240923@074633.5452 4osavbfm1mhu18h295dopjpt1u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20240923@074633.5605 4osavbfm1mhu18h295dopjpt1u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406067 and bi.ref ='324.1670.00.1' and bi.lordem =1
20240923@074633.5939 4osavbfm1mhu18h295dopjpt1u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20240923@074633.5961 4osavbfm1mhu18h295dopjpt1u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406067 and bi.ref ='324.1670.00.1' and bi.lordem =1
20240923@074633.5979 4osavbfm1mhu18h295dopjpt1u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20240923@074633.5999 4osavbfm1mhu18h295dopjpt1u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406067 and bi.ref ='324.1670.00.1' and bi.lordem =1
20240923@074633.6017 4osavbfm1mhu18h295dopjpt1u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20240923@074633.6038 4osavbfm1mhu18h295dopjpt1u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406067 and bi.ref ='324.1670.00.1' and bi.lordem =1
20240923@074633.6063 4osavbfm1mhu18h295dopjpt1u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20240923@074633.6082 4osavbfm1mhu18h295dopjpt1u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406067 and bi.ref ='324.1670.00.1' and bi.lordem =1
20240923@074633.6101 4osavbfm1mhu18h295dopjpt1u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20240923@074633.6122 4osavbfm1mhu18h295dopjpt1u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406067 and bi.ref ='324.1670.00.1' and bi.lordem =1
20240923@074633.6140 4osavbfm1mhu18h295dopjpt1u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20240923@074633.6161 4osavbfm1mhu18h295dopjpt1u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406067 and bi.ref ='324.1670.00.1' and bi.lordem =1
20240923@074633.6178 4osavbfm1mhu18h295dopjpt1u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1675.00.2'
20240923@074633.6335 4osavbfm1mhu18h295dopjpt1u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406067 and bi.ref ='324.1675.00.2' and bi.lordem =2
20240923@074633.6651 4osavbfm1mhu18h295dopjpt1u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1675.00.2'
20240923@074633.6672 4osavbfm1mhu18h295dopjpt1u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2060 and bo.obrano = 2406067 and bi.ref ='324.1675.00.2' and bi.lordem =2
20240923@074633.6690 4osavbfm1mhu18h295dopjpt1u Query : use flama_phc
20240923@074633.6693 4osavbfm1mhu18h295dopjpt1u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@074633.6725 4osavbfm1mhu18h295dopjpt1u Query : use flama_phc
20240923@074633.6728 4osavbfm1mhu18h295dopjpt1u Query : select top 1 1 valor from td where td.ndoc = 39
20240923@074633.6757 4osavbfm1mhu18h295dopjpt1u Query : use flama_phc
20240923@074633.6760 4osavbfm1mhu18h295dopjpt1u Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240923@074633.6787 4osavbfm1mhu18h295dopjpt1u Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240923@074633.6823 4osavbfm1mhu18h295dopjpt1u Query : use flama_phc
20240923@074633.6826 4osavbfm1mhu18h295dopjpt1u Query : select top 1 ~inactivo valor from cl where no = '101645' and estab = 0 order by inactivo desc
20240923@074633.6855 4osavbfm1mhu18h295dopjpt1u Query : use flama_phc
20240923@074633.6857 4osavbfm1mhu18h295dopjpt1u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@074633.6902 4osavbfm1mhu18h295dopjpt1u Query : use flama_phc
20240923@074633.6906 4osavbfm1mhu18h295dopjpt1u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
