20241008@170219.3460 849hi369i9as52anrajl89nd9e Query : use flama_phc
20241008@170219.3540 849hi369i9as52anrajl89nd9e Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241008@170219.4140 849hi369i9as52anrajl89nd9e Query : use flama_phc
20241008@170219.4270 849hi369i9as52anrajl89nd9e Query : select szadrsstamp valor from szadrs where szadrsdesc='101900 - pd - alfena n/p'
20241008@170219.4950 849hi369i9as52anrajl89nd9e Query : use flama_phc
20241008@170219.4990 849hi369i9as52anrajl89nd9e Query : select 1 valor from td where ndoc = 39
20241008@170219.5130 849hi369i9as52anrajl89nd9e Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241008@170219.5330 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.5610 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170219.5920 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.6060 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170219.1268 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.1621 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170219.1636 849hi369i9as52anrajl89nd9e Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170219.1717 849hi369i9as52anrajl89nd9e Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170219.1729 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.1764 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170219.2159 849hi369i9as52anrajl89nd9e Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67055575456705578b27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241008@170219.2309 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.2327 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170219.2359 849hi369i9as52anrajl89nd9e Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241008@170219.2373 849hi369i9as52anrajl89nd9e Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241008@170219.2384 849hi369i9as52anrajl89nd9e Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241008@170219.2396 849hi369i9as52anrajl89nd9e Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241008@170219.2407 849hi369i9as52anrajl89nd9e Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241008@170219.2419 849hi369i9as52anrajl89nd9e Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241008@170219.2429 849hi369i9as52anrajl89nd9e Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67055575456705578b27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241008@170219.2652 849hi369i9as52anrajl89nd9e Query : select top 1 fno valor from wsftdata order by fno desc
20241008@170219.2675 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.2691 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170219.2714 849hi369i9as52anrajl89nd9e Query : select 'normal' from dummy
20241008@170219.2728 849hi369i9as52anrajl89nd9e Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67055575456705578b27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1150,101900,0,'2024-10-08',39,'euro',0,0,2024 ,?,?)
20241008@170219.3018 849hi369i9as52anrajl89nd9e Query : use flama_phc
20241008@170219.3022 849hi369i9as52anrajl89nd9e Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20241008@170219.3053 849hi369i9as52anrajl89nd9e 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'
20241008@170219.3226 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.3243 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.3268 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.3282 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.3291 849hi369i9as52anrajl89nd9e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170219.3303 849hi369i9as52anrajl89nd9e Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400052200a'
20241008@170219.3317 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.3331 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.3344 849hi369i9as52anrajl89nd9e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055575286705578b50','aut67055575456705578b27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170219.3348 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.3363 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.3393 849hi369i9as52anrajl89nd9e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055575286705578b50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67055575456705578b27' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241008@170219.3625 849hi369i9as52anrajl89nd9e Query : use flama_phc
20241008@170219.3628 849hi369i9as52anrajl89nd9e Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20241008@170219.3650 849hi369i9as52anrajl89nd9e 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'
20241008@170219.3805 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.3823 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.3851 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.3867 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.3877 849hi369i9as52anrajl89nd9e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170219.3890 849hi369i9as52anrajl89nd9e Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20241008@170219.3905 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.3922 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.3935 849hi369i9as52anrajl89nd9e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055099476705578b5f','aut67055575456705578b27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170219.3940 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.3955 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.3983 849hi369i9as52anrajl89nd9e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055099476705578b5f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67055575456705578b27' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241008@170219.4373 849hi369i9as52anrajl89nd9e Query : use flama_phc
20241008@170219.4377 849hi369i9as52anrajl89nd9e Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20241008@170219.4400 849hi369i9as52anrajl89nd9e 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'
20241008@170219.4569 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.4586 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.4615 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.4632 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.4642 849hi369i9as52anrajl89nd9e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170219.4656 849hi369i9as52anrajl89nd9e Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '241001'
20241008@170219.4680 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.4695 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.4724 849hi369i9as52anrajl89nd9e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055171846705578b72','aut67055575456705578b27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170219.4728 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.4745 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.4775 849hi369i9as52anrajl89nd9e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055171846705578b72',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',44.000 ,'aut67055575456705578b27' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241008@170219.5004 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.5021 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.5047 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.5062 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.5070 849hi369i9as52anrajl89nd9e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170219.5083 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.5098 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.5110 849hi369i9as52anrajl89nd9e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055078586705578b7c','aut67055575456705578b27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170219.5114 849hi369i9as52anrajl89nd9e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.5128 849hi369i9as52anrajl89nd9e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.5156 849hi369i9as52anrajl89nd9e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67055078586705578b7c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67055575456705578b27' ,0,0 ,2,23.00,40000,?,?,?)
20241008@170219.5377 849hi369i9as52anrajl89nd9e Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67055575456705578b27','2406550','wait',39,'adm09112754980.682000002')
20241008@170219.5448 849hi369i9as52anrajl89nd9e Query : use flama_phc
20241008@170219.5451 849hi369i9as52anrajl89nd9e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241008@170219.5480 849hi369i9as52anrajl89nd9e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2503';
20241008@170219.5511 849hi369i9as52anrajl89nd9e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2503';
20241008@170219.5571 849hi369i9as52anrajl89nd9e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2503';
20241008@170219.5604 849hi369i9as52anrajl89nd9e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2503';
20241008@170219.6514 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241008@170219.6524 68rvcb3gkuqu1a07k9mof5vl0a Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241008@170219.6583 68rvcb3gkuqu1a07k9mof5vl0a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2504';
20241008@170219.6654 68rvcb3gkuqu1a07k9mof5vl0a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2504';
20241008@170219.6706 68rvcb3gkuqu1a07k9mof5vl0a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2504';
20241008@170219.6732 68rvcb3gkuqu1a07k9mof5vl0a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2504';
20241008@170219.6780 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.6783 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241008@170219.6866 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.6870 68rvcb3gkuqu1a07k9mof5vl0a Query : select no, estab,szadrsdesc from szadrs where u_coddest=2448
20241008@170219.6913 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1317.00.1'
20241008@170219.6933 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406551 and bi.ref ='324.1317.00.1' and bi.lordem =1
20241008@170219.7281 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1317.00.1'
20241008@170219.7300 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406551 and bi.ref ='324.1317.00.1' and bi.lordem =1
20241008@170219.7317 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241008@170219.7476 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406551 and bi.ref ='324.2326.00.1' and bi.lordem =2
20241008@170219.7796 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241008@170219.7818 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406551 and bi.ref ='324.2326.00.1' and bi.lordem =2
20241008@170219.7849 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.7852 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241008@170219.7883 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.7886 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 1 valor from td where td.ndoc = 39
20241008@170219.7917 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.7920 68rvcb3gkuqu1a07k9mof5vl0a 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')
20241008@170219.7950 68rvcb3gkuqu1a07k9mof5vl0a 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
20241008@170219.7985 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.7988 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 ~inactivo valor from cl where no = '101889' and estab = 0 order by inactivo desc
20241008@170219.8031 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.8033 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241008@170219.8065 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.8068 68rvcb3gkuqu1a07k9mof5vl0a Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241008@170219.8108 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.8112 68rvcb3gkuqu1a07k9mof5vl0a Query : select szadrsstamp valor from szadrs where szadrsdesc='cooplecnorte,crl'
20241008@170219.8168 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.8170 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from td where ndoc = 39
20241008@170219.8182 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241008@170219.8198 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.8215 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170219.8236 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.8264 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170219.8292 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.8306 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170219.8319 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170219.8385 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170219.8397 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.8415 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170219.8432 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67055337706705578bcb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241008@170219.8594 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.8611 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170219.8645 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241008@170219.8656 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241008@170219.8668 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241008@170219.8679 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241008@170219.8690 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241008@170219.8701 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241008@170219.8712 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67055337706705578bcb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241008@170219.8923 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 fno valor from wsftdata order by fno desc
20241008@170219.8946 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.8962 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170219.8983 68rvcb3gkuqu1a07k9mof5vl0a Query : select 'normal' from dummy
20241008@170219.8997 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67055337706705578bcb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1151,101889,0,'2024-10-08',39,'euro',0,0,2024 ,?,?)
20241008@170219.9271 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.9274 68rvcb3gkuqu1a07k9mof5vl0a Query : select st.usalote valor from st where st.ref = '324.1317.00.1'
20241008@170219.9294 68rvcb3gkuqu1a07k9mof5vl0a 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.1317.00.1'
20241008@170219.9307 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.9323 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.9347 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.9361 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.9369 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170219.9383 68rvcb3gkuqu1a07k9mof5vl0a Query : select sestamp valor from se where ref ='324.1317.00.1' and lote = 'r2400458200a'
20241008@170219.9395 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.9409 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.9420 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055378316705578be5','aut67055337706705578bcb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170219.9438 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.9452 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.9479 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055378316705578be5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut67055337706705578bcb' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241008@170219.9703 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170219.9706 68rvcb3gkuqu1a07k9mof5vl0a Query : select st.usalote valor from st where st.ref = '324.1317.00.1'
20241008@170219.9725 68rvcb3gkuqu1a07k9mof5vl0a 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.1317.00.1'
20241008@170219.9738 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.9752 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.9774 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.9788 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.9796 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170219.9807 68rvcb3gkuqu1a07k9mof5vl0a Query : select sestamp valor from se where ref ='324.1317.00.1' and lote = 'r2400458200a'
20241008@170219.9825 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.9840 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170219.9851 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055804856705578bef','aut67055337706705578bcb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170219.9855 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170219.9870 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170219.9896 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055804856705578bef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',33.000 ,'aut67055337706705578bcb' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241008@170220.1160 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170220.1330 68rvcb3gkuqu1a07k9mof5vl0a Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241008@170220.1540 68rvcb3gkuqu1a07k9mof5vl0a 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.2326.00.1'
20241008@170220.3200 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.3390 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170220.3680 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.3990 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170220.4080 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170220.4200 68rvcb3gkuqu1a07k9mof5vl0a Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2100576400a'
20241008@170220.4390 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.4540 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170220.4650 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055022176705578c0a','aut67055337706705578bcb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170220.4690 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.4820 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170220.5120 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055022176705578c0a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',36.000 ,'aut67055337706705578bcb' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241008@170220.7340 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170220.7370 68rvcb3gkuqu1a07k9mof5vl0a Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241008@170220.7550 68rvcb3gkuqu1a07k9mof5vl0a 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.2326.00.1'
20241008@170220.7690 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.7840 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170220.8060 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.8200 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170220.8280 68rvcb3gkuqu1a07k9mof5vl0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170220.8400 68rvcb3gkuqu1a07k9mof5vl0a Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2100576400a'
20241008@170220.8520 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.8670 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170220.8780 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055025846705578c14','aut67055337706705578bcb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170220.8830 68rvcb3gkuqu1a07k9mof5vl0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.8970 68rvcb3gkuqu1a07k9mof5vl0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170220.9240 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055025846705578c14',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',84.000 ,'aut67055337706705578bcb' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241008@170220.1149 68rvcb3gkuqu1a07k9mof5vl0a Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67055337706705578bcb','2406551','wait',39,'adm09112754980.682000002')
20241008@170220.1222 68rvcb3gkuqu1a07k9mof5vl0a Query : use flama_phc
20241008@170220.1225 68rvcb3gkuqu1a07k9mof5vl0a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241008@170220.1255 68rvcb3gkuqu1a07k9mof5vl0a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2504';
20241008@170220.1287 68rvcb3gkuqu1a07k9mof5vl0a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2504';
20241008@170220.1373 68rvcb3gkuqu1a07k9mof5vl0a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2504';
20241008@170220.1402 68rvcb3gkuqu1a07k9mof5vl0a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2504';
20241008@170220.2200 8rbj0l5oin7emnepb3h16icdqi Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241008@170220.2211 8rbj0l5oin7emnepb3h16icdqi Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241008@170220.2314 8rbj0l5oin7emnepb3h16icdqi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2505';
20241008@170220.2387 8rbj0l5oin7emnepb3h16icdqi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2505';
20241008@170220.2500 8rbj0l5oin7emnepb3h16icdqi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2505';
20241008@170220.2542 8rbj0l5oin7emnepb3h16icdqi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2505';
20241008@170220.2603 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.2611 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241008@170220.2714 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.2725 8rbj0l5oin7emnepb3h16icdqi Query : select no, estab,szadrsdesc from szadrs where u_coddest=6917
20241008@170220.2824 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.600.94.01'
20241008@170220.3009 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406554 and bi.ref ='324.600.94.01' and bi.lordem =1
20241008@170220.3370 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.600.94.01'
20241008@170220.3420 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406554 and bi.ref ='324.600.94.01' and bi.lordem =1
20241008@170220.3437 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2000.94.1'
20241008@170220.3607 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406554 and bi.ref ='324.2000.94.1' and bi.lordem =2
20241008@170220.3956 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.900.94.01'
20241008@170220.4822 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406554 and bi.ref ='324.900.94.01' and bi.lordem =3
20241008@170220.5616 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.700.94.01'
20241008@170220.6406 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406554 and bi.ref ='324.700.94.01' and bi.lordem =4
20241008@170220.6927 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2200.94.1'
20241008@170220.7107 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406554 and bi.ref ='324.2200.94.1' and bi.lordem =5
20241008@170220.7462 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.7465 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241008@170220.7523 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.7527 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 1 valor from td where td.ndoc = 39
20241008@170220.7582 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.7585 8rbj0l5oin7emnepb3h16icdqi 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')
20241008@170220.7614 8rbj0l5oin7emnepb3h16icdqi 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
20241008@170220.7672 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.7785 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 ~inactivo valor from cl where no = '199800' and estab = 0 order by inactivo desc
20241008@170220.8573 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.8615 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241008@170220.9097 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.9117 8rbj0l5oin7emnepb3h16icdqi Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241008@170220.9155 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.9177 8rbj0l5oin7emnepb3h16icdqi Query : select szadrsstamp valor from szadrs where szadrsdesc='740 ent vnr bligeiro'
20241008@170220.9254 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170220.9270 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from td where ndoc = 39
20241008@170220.9282 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241008@170220.9303 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.9319 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170220.9348 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.9363 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170220.9417 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.9431 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170220.9447 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170220.9508 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170220.9541 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.9561 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170220.9599 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67055240306705578ce6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241008@170220.9759 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170220.9777 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170220.9823 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241008@170220.9839 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241008@170220.9851 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241008@170220.9881 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241008@170220.9933 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241008@170220.9944 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241008@170220.9958 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67055240306705578ce6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241008@170221.1670 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 fno valor from wsftdata order by fno desc
20241008@170221.2290 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.2460 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170221.2710 8rbj0l5oin7emnepb3h16icdqi Query : select 'normal' from dummy
20241008@170221.2870 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67055240306705578ce6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1152,199800,0,'2024-10-08',39,'euro',0,0,2024 ,?,?)
20241008@170221.5530 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170221.5560 8rbj0l5oin7emnepb3h16icdqi Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20241008@170221.5940 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.600.94.01'
20241008@170221.7510 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.8000 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.8270 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.8440 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.8530 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170221.8650 8rbj0l5oin7emnepb3h16icdqi Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20241008@170221.8840 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.9190 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.9310 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055611266705578d15','aut67055240306705578ce6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170221.9350 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.9660 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.9950 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055611266705578d15',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut67055240306705578ce6' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241008@170221.1232 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.1247 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.1273 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.1288 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.1296 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170221.1308 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.1333 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.1346 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055053086705578d1f','aut67055240306705578ce6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170221.1351 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.1365 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.1407 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67055053086705578d1f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67055240306705578ce6' ,0,0 ,2,23.00,20000,?,?,?)
20241008@170221.1624 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170221.1627 8rbj0l5oin7emnepb3h16icdqi Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20241008@170221.1646 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.600.94.01'
20241008@170221.1659 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.1675 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.1704 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.1720 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.1728 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170221.1740 8rbj0l5oin7emnepb3h16icdqi Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20241008@170221.1753 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.1767 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.1779 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055565756705578d2a','aut67055240306705578ce6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170221.1784 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.1798 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.1825 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055565756705578d2a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67055240306705578ce6' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241008@170221.2053 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.2070 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.2096 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.2110 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.2118 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170221.2130 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.2145 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.2155 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055472706705578d34','aut67055240306705578ce6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170221.2160 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.2178 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.2207 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67055472706705578d34',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67055240306705578ce6' ,0,0 ,2,23.00,50000,?,?,?)
20241008@170221.2448 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170221.2451 8rbj0l5oin7emnepb3h16icdqi Query : select st.usalote valor from st where st.ref = '324.2000.94.1'
20241008@170221.2471 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2000.94.1'
20241008@170221.2616 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.2632 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.2658 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.2674 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.2682 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170221.2695 8rbj0l5oin7emnepb3h16icdqi Query : select sestamp valor from se where ref ='324.2000.94.1' and lote = 'r2300916200a'
20241008@170221.2726 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.2741 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.2752 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055246376705578d42','aut67055240306705578ce6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170221.2757 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.2772 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.2800 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055246376705578d42',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',32.000 ,'aut67055240306705578ce6' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241008@170221.3017 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170221.3020 8rbj0l5oin7emnepb3h16icdqi Query : select st.usalote valor from st where st.ref = '324.900.94.01'
20241008@170221.3039 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.900.94.01'
20241008@170221.3183 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.3198 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.3223 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.3237 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.3245 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170221.3257 8rbj0l5oin7emnepb3h16icdqi Query : select sestamp valor from se where ref ='324.900.94.01' and lote = 'r2300952200a'
20241008@170221.3276 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.3290 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.3301 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055383746705578d4f','aut67055240306705578ce6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170221.3304 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.3319 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.3344 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055383746705578d4f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut67055240306705578ce6' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241008@170221.3581 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170221.3584 8rbj0l5oin7emnepb3h16icdqi Query : select st.usalote valor from st where st.ref = '324.700.94.01'
20241008@170221.3604 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.700.94.01'
20241008@170221.3754 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.3772 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.3797 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.3812 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.3820 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170221.3832 8rbj0l5oin7emnepb3h16icdqi Query : select sestamp valor from se where ref ='324.700.94.01' and lote = 'r2300913100a'
20241008@170221.3845 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.3859 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.3873 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055319946705578d5d','aut67055240306705578ce6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170221.3878 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.3892 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.3921 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055319946705578d5d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut67055240306705578ce6' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241008@170221.4169 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170221.4172 8rbj0l5oin7emnepb3h16icdqi Query : select st.usalote valor from st where st.ref = '324.2200.94.1'
20241008@170221.4193 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2200.94.1'
20241008@170221.4346 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.4365 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.4404 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.4421 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.4430 8rbj0l5oin7emnepb3h16icdqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170221.4442 8rbj0l5oin7emnepb3h16icdqi Query : select sestamp valor from se where ref ='324.2200.94.1' and lote = 'r2400046200a'
20241008@170221.4455 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.4471 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170221.4483 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055779386705578d6c','aut67055240306705578ce6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170221.4487 8rbj0l5oin7emnepb3h16icdqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170221.4505 8rbj0l5oin7emnepb3h16icdqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170221.4533 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055779386705578d6c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut67055240306705578ce6' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241008@170221.4834 8rbj0l5oin7emnepb3h16icdqi Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67055240306705578ce6','2406554','wait',39,'adm09112754980.682000002')
20241008@170221.6734 8rbj0l5oin7emnepb3h16icdqi Query : use flama_phc
20241008@170221.6737 8rbj0l5oin7emnepb3h16icdqi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241008@170221.6768 8rbj0l5oin7emnepb3h16icdqi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2505';
20241008@170221.6796 8rbj0l5oin7emnepb3h16icdqi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2505';
20241008@170221.6871 8rbj0l5oin7emnepb3h16icdqi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2505';
20241008@170221.6896 8rbj0l5oin7emnepb3h16icdqi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2505';
20241008@170221.7479 7j9n2sjulugk6p2dnt13cfv75q Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241008@170221.7489 7j9n2sjulugk6p2dnt13cfv75q Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241008@170221.7543 7j9n2sjulugk6p2dnt13cfv75q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2506';
20241008@170221.7601 7j9n2sjulugk6p2dnt13cfv75q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2506';
20241008@170221.7652 7j9n2sjulugk6p2dnt13cfv75q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2506';
20241008@170221.7678 7j9n2sjulugk6p2dnt13cfv75q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2506';
20241008@170221.7728 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170221.7731 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241008@170221.7791 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170221.7794 7j9n2sjulugk6p2dnt13cfv75q Query : select no, estab,szadrsdesc from szadrs where u_coddest=2064
20241008@170221.7880 7j9n2sjulugk6p2dnt13cfv75q 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'
20241008@170221.8052 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406555 and bi.ref ='324.645.00.01' and bi.lordem =1
20241008@170221.8373 7j9n2sjulugk6p2dnt13cfv75q 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'
20241008@170221.8539 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406555 and bi.ref ='324.646.00.01' and bi.lordem =2
20241008@170221.8898 7j9n2sjulugk6p2dnt13cfv75q 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'
20241008@170221.8920 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406555 and bi.ref ='324.646.00.01' and bi.lordem =2
20241008@170221.8938 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '326.597.00.01'
20241008@170221.9098 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406555 and bi.ref ='326.597.00.01' and bi.lordem =3
20241008@170221.9424 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20241008@170221.9654 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406555 and bi.ref ='324.966.00.01' and bi.lordem =4
20241008@170221.9997 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.0000 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241008@170222.3400 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.3700 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 1 valor from td where td.ndoc = 39
20241008@170222.6800 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.7100 7j9n2sjulugk6p2dnt13cfv75q 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')
20241008@170222.1010 7j9n2sjulugk6p2dnt13cfv75q 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
20241008@170222.1370 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.1410 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 ~inactivo valor from cl where no = '101645' and estab = 0 order by inactivo desc
20241008@170222.4670 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.4720 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241008@170222.5700 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.5760 7j9n2sjulugk6p2dnt13cfv75q Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241008@170222.7230 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.7500 7j9n2sjulugk6p2dnt13cfv75q Query : select szadrsstamp valor from szadrs where szadrsdesc='macorlux - electrodomÉsticos, s.a.'
20241008@170222.8390 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.8420 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from td where ndoc = 39
20241008@170222.9150 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241008@170222.9720 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.9880 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170222.1189 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.1281 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170222.1315 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.1331 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170222.1343 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170222.1413 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170222.1426 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.1471 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170222.1487 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67055036936705578e20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241008@170222.1636 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.1655 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170222.1690 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241008@170222.1702 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241008@170222.1713 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241008@170222.1725 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241008@170222.1736 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241008@170222.1747 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241008@170222.1758 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67055036936705578e20',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241008@170222.1953 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 fno valor from wsftdata order by fno desc
20241008@170222.1974 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.2053 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170222.2078 7j9n2sjulugk6p2dnt13cfv75q Query : select 'normal' from dummy
20241008@170222.2093 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67055036936705578e20',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1153,101645,0,'2024-10-08',39,'euro',0,0,2024 ,?,?)
20241008@170222.2356 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.2359 7j9n2sjulugk6p2dnt13cfv75q Query : select st.usalote valor from st where st.ref = '324.645.00.01'
20241008@170222.2382 7j9n2sjulugk6p2dnt13cfv75q 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'
20241008@170222.2533 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.2548 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.2577 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.2590 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.2601 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170222.2612 7j9n2sjulugk6p2dnt13cfv75q Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2301174100a'
20241008@170222.2632 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.2646 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.2658 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055368556705578e40','aut67055036936705578e20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170222.2662 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.2676 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.2704 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055368556705578e40',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut67055036936705578e20' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241008@170222.2923 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.2941 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.2969 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.2985 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.2996 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170222.3009 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.3024 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.3065 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055122266705578e49','aut67055036936705578e20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170222.3069 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.3085 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.3114 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67055122266705578e49',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67055036936705578e20' ,0,0 ,2,23.00,20000,?,?,?)
20241008@170222.3331 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.3335 7j9n2sjulugk6p2dnt13cfv75q Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241008@170222.3357 7j9n2sjulugk6p2dnt13cfv75q 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'
20241008@170222.3520 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.3537 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.3565 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.3581 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.3590 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170222.3603 7j9n2sjulugk6p2dnt13cfv75q Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400224100a'
20241008@170222.3635 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.3653 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.3665 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055322676705578e58','aut67055036936705578e20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170222.3670 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.3685 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.3714 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055322676705578e58',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',13.000 ,'aut67055036936705578e20' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241008@170222.4396 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5045 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.5070 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5084 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.5093 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170222.5105 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5119 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.5130 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055104516705578e7c','aut67055036936705578e20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170222.5134 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5149 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.5177 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67055104516705578e7c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67055036936705578e20' ,0,0 ,2,23.00,50000,?,?,?)
20241008@170222.5395 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.5399 7j9n2sjulugk6p2dnt13cfv75q Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241008@170222.5421 7j9n2sjulugk6p2dnt13cfv75q 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'
20241008@170222.5436 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5453 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.5480 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5496 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.5505 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170222.5519 7j9n2sjulugk6p2dnt13cfv75q Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400224100a'
20241008@170222.5532 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5549 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.5561 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055553736705578e87','aut67055036936705578e20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170222.5565 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5580 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.5622 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055553736705578e87',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut67055036936705578e20' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241008@170222.5890 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5908 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.5940 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5957 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.5966 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170222.5980 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.5996 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.6008 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055334586705578e91','aut67055036936705578e20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170222.6013 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.6034 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.6076 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67055334586705578e91',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67055036936705578e20' ,0,0 ,2,23.00,80000,?,?,?)
20241008@170222.6307 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.6311 7j9n2sjulugk6p2dnt13cfv75q Query : select st.usalote valor from st where st.ref = '326.597.00.01'
20241008@170222.6333 7j9n2sjulugk6p2dnt13cfv75q 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 = '326.597.00.01'
20241008@170222.6564 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.6596 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.6637 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.6666 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.6676 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170222.6694 7j9n2sjulugk6p2dnt13cfv75q Query : select sestamp valor from se where ref ='326.597.00.01' and lote = 'r2400936200a'
20241008@170222.6719 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.6736 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.6749 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055192566705578ea4','aut67055036936705578e20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170222.6754 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.6770 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.6801 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055192566705578ea4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut67055036936705578e20' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241008@170222.7229 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.7244 7j9n2sjulugk6p2dnt13cfv75q Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20241008@170222.7268 7j9n2sjulugk6p2dnt13cfv75q 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.966.00.01'
20241008@170222.7545 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.7562 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.7588 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.7603 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.7627 7j9n2sjulugk6p2dnt13cfv75q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170222.7713 7j9n2sjulugk6p2dnt13cfv75q Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20241008@170222.7728 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.7770 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170222.7914 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055901716705578ebc','aut67055036936705578e20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170222.7921 7j9n2sjulugk6p2dnt13cfv75q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170222.7941 7j9n2sjulugk6p2dnt13cfv75q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170222.8016 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055901716705578ebc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67055036936705578e20' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241008@170222.8481 7j9n2sjulugk6p2dnt13cfv75q Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67055036936705578e20','2406555','wait',39,'adm09112754980.682000002')
20241008@170222.8663 7j9n2sjulugk6p2dnt13cfv75q Query : use flama_phc
20241008@170222.8666 7j9n2sjulugk6p2dnt13cfv75q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241008@170222.8698 7j9n2sjulugk6p2dnt13cfv75q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2506';
20241008@170222.8733 7j9n2sjulugk6p2dnt13cfv75q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2506';
20241008@170222.8776 7j9n2sjulugk6p2dnt13cfv75q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2506';
20241008@170222.8805 7j9n2sjulugk6p2dnt13cfv75q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2506';
20241008@170222.9387 bo6bpmn0edou63etpa545d6i7f Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241008@170222.9398 bo6bpmn0edou63etpa545d6i7f Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241008@170222.9453 bo6bpmn0edou63etpa545d6i7f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2507';
20241008@170222.9514 bo6bpmn0edou63etpa545d6i7f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2507';
20241008@170222.9568 bo6bpmn0edou63etpa545d6i7f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2507';
20241008@170222.9598 bo6bpmn0edou63etpa545d6i7f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2507';
20241008@170222.9653 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170222.9656 bo6bpmn0edou63etpa545d6i7f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241008@170222.9721 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170222.9724 bo6bpmn0edou63etpa545d6i7f Query : select no, estab,szadrsdesc from szadrs where u_coddest=2150
20241008@170222.9808 bo6bpmn0edou63etpa545d6i7f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1317.00.1'
20241008@170222.9829 bo6bpmn0edou63etpa545d6i7f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406556 and bi.ref ='324.1317.00.1' and bi.lordem =1
20241008@170223.1630 bo6bpmn0edou63etpa545d6i7f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241008@170223.3190 bo6bpmn0edou63etpa545d6i7f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406556 and bi.ref ='324.1824.00.1' and bi.lordem =2
20241008@170223.6440 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.6470 bo6bpmn0edou63etpa545d6i7f Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241008@170223.6800 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.6830 bo6bpmn0edou63etpa545d6i7f Query : select top 1 1 valor from td where td.ndoc = 39
20241008@170223.7160 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.7190 bo6bpmn0edou63etpa545d6i7f 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')
20241008@170223.7470 bo6bpmn0edou63etpa545d6i7f 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
20241008@170223.7810 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.7840 bo6bpmn0edou63etpa545d6i7f Query : select top 1 ~inactivo valor from cl where no = '101345' and estab = 0 order by inactivo desc
20241008@170223.9060 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.9090 bo6bpmn0edou63etpa545d6i7f Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241008@170223.9390 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.9410 bo6bpmn0edou63etpa545d6i7f Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241008@170223.9820 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.9850 bo6bpmn0edou63etpa545d6i7f Query : select szadrsstamp valor from szadrs where szadrsdesc='celestino fÉlix silvestre herdºs.'
20241008@170223.1044 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.1047 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from td where ndoc = 39
20241008@170223.1060 bo6bpmn0edou63etpa545d6i7f Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241008@170223.1075 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.1091 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170223.1110 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.1124 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170223.1153 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.1168 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170223.1181 bo6bpmn0edou63etpa545d6i7f Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170223.1245 bo6bpmn0edou63etpa545d6i7f Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170223.1259 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.1274 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170223.1291 bo6bpmn0edou63etpa545d6i7f Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67055717536705578f1c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241008@170223.1447 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.1464 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170223.1497 bo6bpmn0edou63etpa545d6i7f Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241008@170223.1509 bo6bpmn0edou63etpa545d6i7f Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241008@170223.1522 bo6bpmn0edou63etpa545d6i7f Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241008@170223.1535 bo6bpmn0edou63etpa545d6i7f Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241008@170223.1547 bo6bpmn0edou63etpa545d6i7f Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241008@170223.1559 bo6bpmn0edou63etpa545d6i7f Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241008@170223.1570 bo6bpmn0edou63etpa545d6i7f Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67055717536705578f1c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241008@170223.1777 bo6bpmn0edou63etpa545d6i7f Query : select top 1 fno valor from wsftdata order by fno desc
20241008@170223.1800 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.1817 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170223.1841 bo6bpmn0edou63etpa545d6i7f Query : select 'normal' from dummy
20241008@170223.1857 bo6bpmn0edou63etpa545d6i7f Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67055717536705578f1c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1154,101345,0,'2024-10-08',39,'euro',0,0,2024 ,?,?)
20241008@170223.2163 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.2166 bo6bpmn0edou63etpa545d6i7f Query : select st.usalote valor from st where st.ref = '324.1317.00.1'
20241008@170223.2193 bo6bpmn0edou63etpa545d6i7f 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.1317.00.1'
20241008@170223.2213 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.2230 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170223.2258 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.2336 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170223.2455 bo6bpmn0edou63etpa545d6i7f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170223.2469 bo6bpmn0edou63etpa545d6i7f Query : select sestamp valor from se where ref ='324.1317.00.1' and lote = 'r2400458200a'
20241008@170223.2493 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.2520 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170223.2684 bo6bpmn0edou63etpa545d6i7f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055563446705578f3c','aut67055717536705578f1c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170223.2688 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.2706 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170223.2763 bo6bpmn0edou63etpa545d6i7f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055563446705578f3c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut67055717536705578f1c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241008@170223.2986 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.2989 bo6bpmn0edou63etpa545d6i7f Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241008@170223.3010 bo6bpmn0edou63etpa545d6i7f Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20241008@170223.3308 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.3423 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170223.3447 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.3465 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170223.3473 bo6bpmn0edou63etpa545d6i7f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170223.3485 bo6bpmn0edou63etpa545d6i7f Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20241008@170223.3541 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.3557 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170223.3572 bo6bpmn0edou63etpa545d6i7f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055624006705578f56','aut67055717536705578f1c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170223.3577 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.3591 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170223.3709 bo6bpmn0edou63etpa545d6i7f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67055624006705578f56',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67055717536705578f1c' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241008@170223.3956 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.4083 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170223.4115 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.4235 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170223.4245 bo6bpmn0edou63etpa545d6i7f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241008@170223.4256 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.4279 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241008@170223.4292 bo6bpmn0edou63etpa545d6i7f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67055852746705578f67','aut67055717536705578f1c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241008@170223.4325 bo6bpmn0edou63etpa545d6i7f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.4366 bo6bpmn0edou63etpa545d6i7f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241008@170223.4405 bo6bpmn0edou63etpa545d6i7f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67055852746705578f67',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67055717536705578f1c' ,0,0 ,2,23.00,30000,?,?,?)
20241008@170223.4666 bo6bpmn0edou63etpa545d6i7f Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67055717536705578f1c','2406556','wait',39,'adm09112754980.682000002')
20241008@170223.4764 bo6bpmn0edou63etpa545d6i7f Query : use flama_phc
20241008@170223.4767 bo6bpmn0edou63etpa545d6i7f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241008@170223.4797 bo6bpmn0edou63etpa545d6i7f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2507';
20241008@170223.4830 bo6bpmn0edou63etpa545d6i7f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2507';
20241008@170223.4871 bo6bpmn0edou63etpa545d6i7f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2507';
20241008@170223.4895 bo6bpmn0edou63etpa545d6i7f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2507';
20241008@170223.5589 l9tq6d5g9gltc90ta5gnudee48 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241008@170223.5602 l9tq6d5g9gltc90ta5gnudee48 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241008@170223.5657 l9tq6d5g9gltc90ta5gnudee48 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2508';
20241008@170223.5717 l9tq6d5g9gltc90ta5gnudee48 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2508';
20241008@170223.5771 l9tq6d5g9gltc90ta5gnudee48 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2508';
20241008@170223.5800 l9tq6d5g9gltc90ta5gnudee48 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2508';
20241008@170223.5849 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.5852 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241008@170223.5913 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.5916 l9tq6d5g9gltc90ta5gnudee48 Query : select no, estab,szadrsdesc from szadrs where u_coddest=227
20241008@170223.5958 l9tq6d5g9gltc90ta5gnudee48 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'
20241008@170223.6124 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406557 and bi.ref ='324.5342.00.1' and bi.lordem =1
20241008@170223.6464 l9tq6d5g9gltc90ta5gnudee48 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'
20241008@170223.6485 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406557 and bi.ref ='324.5342.00.1' and bi.lordem =2
20241008@170223.6831 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20241008@170223.7010 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406557 and bi.ref ='324.5343.00.1' and bi.lordem =3
20241008@170223.7414 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20241008@170223.7435 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2065 and bo.obrano = 2406557 and bi.ref ='324.5343.00.1' and bi.lordem =4
20241008@170223.7876 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.7880 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241008@170223.7917 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.7920 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 1 valor from td where td.ndoc = 39
20241008@170223.8037 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.8042 l9tq6d5g9gltc90ta5gnudee48 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')
20241008@170223.8073 l9tq6d5g9gltc90ta5gnudee48 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
20241008@170223.8181 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.8185 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 ~inactivo valor from cl where no = '100041' and estab = 0 order by inactivo desc
20241008@170223.8217 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.8220 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241008@170223.8250 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.8253 l9tq6d5g9gltc90ta5gnudee48 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241008@170223.8293 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.8297 l9tq6d5g9gltc90ta5gnudee48 Query : select szadrsstamp valor from szadrs where szadrsdesc='radiobela som, lda'
20241008@170223.8342 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.8345 l9tq6d5g9gltc90ta5gnudee48 Query : select 1 valor from td where ndoc = 39
20241008@170223.8357 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241008@170223.8373 l9tq6d5g9gltc90ta5gnudee48 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.8392 l9tq6d5g9gltc90ta5gnudee48 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170223.8412 l9tq6d5g9gltc90ta5gnudee48 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.8430 l9tq6d5g9gltc90ta5gnudee48 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170223.8466 l9tq6d5g9gltc90ta5gnudee48 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.8483 l9tq6d5g9gltc90ta5gnudee48 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170223.8496 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170223.8569 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241008@170223.8583 l9tq6d5g9gltc90ta5gnudee48 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.8616 l9tq6d5g9gltc90ta5gnudee48 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241008@170223.8633 l9tq6d5g9gltc90ta5gnudee48 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67055286926705578fcf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241008@170223.8791 l9tq6d5g9gltc90ta5gnudee48 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.8813 l9tq6d5g9gltc90ta5gnudee48 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241008@170223.8850 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241008@170223.8864 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241008@170223.8877 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241008@170223.8891 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241008@170223.8907 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241008@170223.8921 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241008@170223.8934 l9tq6d5g9gltc90ta5gnudee48 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67055286926705578fcf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241008@170223.9192 l9tq6d5g9gltc90ta5gnudee48 Query : select top 1 fno valor from wsftdata order by fno desc
20241008@170223.9218 l9tq6d5g9gltc90ta5gnudee48 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241008@170223.9238 l9tq6d5g9gltc90ta5gnudee48 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241008@170223.9268 l9tq6d5g9gltc90ta5gnudee48 Query : select 'normal' from dummy
20241008@170223.9287 l9tq6d5g9gltc90ta5gnudee48 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67055286926705578fcf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1155,100041,0,'2024-10-08',39,'euro',0,0,2024 ,?,?)
20241008@170223.9563 l9tq6d5g9gltc90ta5gnudee48 Query : use flama_phc
20241008@170223.9568 l9tq6d5g9gltc90ta5gnudee48 Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20241008@170223.9594 l9tq6d5g9gltc90ta5gnudee48 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'
