20250120@191817.7000 om7epu6b8igdas94srbd466jco Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4796';
20250120@191817.7350 om7epu6b8igdas94srbd466jco Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4796';
20250120@191817.1282 98bku88creqkeg776bj8ie2gd4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250120@191817.1294 98bku88creqkeg776bj8ie2gd4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250120@191817.1653 98bku88creqkeg776bj8ie2gd4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4797';
20250120@191817.1746 98bku88creqkeg776bj8ie2gd4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4797';
20250120@191817.1844 98bku88creqkeg776bj8ie2gd4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4797';
20250120@191817.1940 98bku88creqkeg776bj8ie2gd4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4797';
20250120@191817.2054 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.2057 98bku88creqkeg776bj8ie2gd4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250120@191817.2199 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.2202 98bku88creqkeg776bj8ie2gd4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=9437
20250120@191817.2311 98bku88creqkeg776bj8ie2gd4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.711.00.01'
20250120@191817.2493 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2005 and bo.obrano = 2500509 and bi.ref ='324.711.00.01' and bi.lordem =1
20250120@191817.2890 98bku88creqkeg776bj8ie2gd4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20250120@191817.3146 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2005 and bo.obrano = 2500509 and bi.ref ='324.2224.00.1' and bi.lordem =2
20250120@191817.3764 98bku88creqkeg776bj8ie2gd4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20250120@191817.3941 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2005 and bo.obrano = 2500509 and bi.ref ='324.691.00.01' and bi.lordem =3
20250120@191817.4523 98bku88creqkeg776bj8ie2gd4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20250120@191817.4544 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2005 and bo.obrano = 2500509 and bi.ref ='324.691.00.01' and bi.lordem =3
20250120@191817.4561 98bku88creqkeg776bj8ie2gd4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.644.00.01'
20250120@191817.4733 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2005 and bo.obrano = 2500509 and bi.ref ='324.644.00.01' and bi.lordem =4
20250120@191817.6361 98bku88creqkeg776bj8ie2gd4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.644.00.01'
20250120@191817.6388 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2005 and bo.obrano = 2500509 and bi.ref ='324.644.00.01' and bi.lordem =4
20250120@191817.6409 98bku88creqkeg776bj8ie2gd4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20250120@191817.6605 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2005 and bo.obrano = 2500509 and bi.ref ='324.497.00.01' and bi.lordem =5
20250120@191817.6953 98bku88creqkeg776bj8ie2gd4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4964.00.1'
20250120@191817.7147 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2005 and bo.obrano = 2500509 and bi.ref ='324.4964.00.1' and bi.lordem =6
20250120@191817.7515 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.7519 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250120@191817.7558 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.7562 98bku88creqkeg776bj8ie2gd4 Query : select top 1 1 valor from td where td.ndoc = 39
20250120@191817.7595 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.7598 98bku88creqkeg776bj8ie2gd4 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')
20250120@191817.7627 98bku88creqkeg776bj8ie2gd4 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
20250120@191817.7719 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.7723 98bku88creqkeg776bj8ie2gd4 Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20250120@191817.7869 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.7873 98bku88creqkeg776bj8ie2gd4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250120@191817.7905 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.7909 98bku88creqkeg776bj8ie2gd4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250120@191817.8005 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.8009 98bku88creqkeg776bj8ie2gd4 Query : select szadrsstamp valor from szadrs where szadrsdesc='mirandadis, s.l. - e. leclerc'
20250120@191817.8060 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.8064 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from td where ndoc = 39
20250120@191817.8078 98bku88creqkeg776bj8ie2gd4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250120@191817.8094 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.8115 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250120@191817.8135 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.8151 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250120@191817.8182 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.8198 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250120@191817.8211 98bku88creqkeg776bj8ie2gd4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250120@191817.8319 98bku88creqkeg776bj8ie2gd4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250120@191817.8332 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.8349 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250120@191817.8366 98bku88creqkeg776bj8ie2gd4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250120@191817.8570 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.8590 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250120@191817.8625 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250120@191817.8637 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250120@191817.8652 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250120@191817.8668 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250120@191817.8680 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250120@191817.8693 98bku88creqkeg776bj8ie2gd4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250120@191817.8705 98bku88creqkeg776bj8ie2gd4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut678ea04925678ea179c8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250120@191817.9015 98bku88creqkeg776bj8ie2gd4 Query : select top 1 fno valor from wsftdata order by fno desc
20250120@191817.9069 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.9093 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250120@191817.9120 98bku88creqkeg776bj8ie2gd4 Query : select 'normal' from dummy
20250120@191817.9137 98bku88creqkeg776bj8ie2gd4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut678ea04925678ea179c8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3077,200500,0,'2025-01-20',39,'euro',0,0,2025 ,?,?)
20250120@191817.9495 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191817.9499 98bku88creqkeg776bj8ie2gd4 Query : select st.usalote valor from st where st.ref = '324.711.00.01'
20250120@191817.9537 98bku88creqkeg776bj8ie2gd4 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.711.00.01'
20250120@191817.9710 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.9727 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191817.9753 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.9768 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191817.9777 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191817.9790 98bku88creqkeg776bj8ie2gd4 Query : select sestamp valor from se where ref ='324.711.00.01' and lote = 'r2401063200a'
20250120@191817.9810 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.9825 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191817.9837 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea29971678ea179ef','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191817.9843 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191817.9857 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191817.9887 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut678ea29971678ea179ef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250120@191818.1740 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.1910 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.2160 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.2310 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.2400 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191818.2530 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.2680 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.2800 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea02011678ea17a06','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191818.2840 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.2990 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.3260 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut678ea02011678ea17a06',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,20000,?,?,?)
20250120@191818.7170 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191818.7210 98bku88creqkeg776bj8ie2gd4 Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20250120@191818.2686 98bku88creqkeg776bj8ie2gd4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2224.00.1'
20250120@191818.2850 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.2868 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.2895 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.2909 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.2917 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191818.2929 98bku88creqkeg776bj8ie2gd4 Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301280100a'
20250120@191818.2949 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.2965 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.2978 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea63207678ea17a48','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191818.2983 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.2998 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.3026 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut678ea63207678ea17a48',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20250120@191818.3303 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191818.3306 98bku88creqkeg776bj8ie2gd4 Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20250120@191818.3329 98bku88creqkeg776bj8ie2gd4 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.691.00.01'
20250120@191818.3488 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.3507 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.3535 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.3550 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.3559 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191818.3571 98bku88creqkeg776bj8ie2gd4 Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2400837300a'
20250120@191818.3610 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.3625 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.3636 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea54605678ea17a58','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191818.3641 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.3655 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.3685 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut678ea54605678ea17a58',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20250120@191818.5429 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.5448 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.5473 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.5488 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.5496 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191818.5509 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.5525 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.5537 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea95264678ea17a86','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191818.5542 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.5556 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.5583 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut678ea95264678ea17a86',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,60000,?,?,?)
20250120@191818.5865 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191818.5870 98bku88creqkeg776bj8ie2gd4 Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20250120@191818.5964 98bku88creqkeg776bj8ie2gd4 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.691.00.01'
20250120@191818.5983 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.6006 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.6039 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.6057 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.6068 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191818.6084 98bku88creqkeg776bj8ie2gd4 Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2400837300a'
20250120@191818.6101 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.6118 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.6133 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea13511678ea17a94','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191818.6140 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.6162 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.6197 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut678ea13511678ea17a94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20250120@191818.6626 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.6653 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.6687 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.6705 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.6716 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191818.6730 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.6751 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.6766 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea93542678ea17aa4','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191818.6771 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.6790 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.6824 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut678ea93542678ea17aa4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,90000,?,?,?)
20250120@191818.7262 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191818.7265 98bku88creqkeg776bj8ie2gd4 Query : select st.usalote valor from st where st.ref = '324.644.00.01'
20250120@191818.7290 98bku88creqkeg776bj8ie2gd4 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.644.00.01'
20250120@191818.7471 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.7490 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.7520 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.7538 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.7548 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191818.7562 98bku88creqkeg776bj8ie2gd4 Query : select sestamp valor from se where ref ='324.644.00.01' and lote = 'r2400749200a'
20250120@191818.7625 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.7646 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.7660 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea07976678ea17aba','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191818.7666 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.7683 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.7719 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut678ea07976678ea17aba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20250120@191818.8007 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191818.8011 98bku88creqkeg776bj8ie2gd4 Query : select st.usalote valor from st where st.ref = '324.644.00.01'
20250120@191818.8090 98bku88creqkeg776bj8ie2gd4 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.644.00.01'
20250120@191818.8105 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.8123 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.8153 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.8168 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.8179 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191818.8191 98bku88creqkeg776bj8ie2gd4 Query : select sestamp valor from se where ref ='324.644.00.01' and lote = 'r2400749200a'
20250120@191818.8205 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.8220 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.8277 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea63591678ea17ac8','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191818.8282 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.8298 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.8326 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut678ea63591678ea17ac8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20250120@191818.8608 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191818.8611 98bku88creqkeg776bj8ie2gd4 Query : select st.usalote valor from st where st.ref = '324.497.00.01'
20250120@191818.8643 98bku88creqkeg776bj8ie2gd4 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.497.00.01'
20250120@191818.9827 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.9845 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191818.9871 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.9886 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.9895 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191818.9910 98bku88creqkeg776bj8ie2gd4 Query : select sestamp valor from se where ref ='324.497.00.01' and lote = 'r2300024300a'
20250120@191818.9947 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.9962 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191818.9974 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea12540678ea17af2','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191818.9978 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191818.9993 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191819.2000 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut678ea12540678ea17af2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20250120@191819.2920 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191819.2950 98bku88creqkeg776bj8ie2gd4 Query : select st.usalote valor from st where st.ref = '324.4964.00.1'
20250120@191819.3160 98bku88creqkeg776bj8ie2gd4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4964.00.1'
20250120@191819.5860 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191819.6030 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191819.1835 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191819.1853 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191819.1863 98bku88creqkeg776bj8ie2gd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191819.1876 98bku88creqkeg776bj8ie2gd4 Query : select sestamp valor from se where ref ='324.4964.00.1' and lote = 'r2300717100a'
20250120@191819.1918 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191819.1934 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250120@191819.1949 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea27264678ea17b2e','aut678ea04925678ea179c8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250120@191819.1954 98bku88creqkeg776bj8ie2gd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191819.1969 98bku88creqkeg776bj8ie2gd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250120@191819.2001 98bku88creqkeg776bj8ie2gd4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut678ea27264678ea17b2e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut678ea04925678ea179c8' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20250120@191819.2274 98bku88creqkeg776bj8ie2gd4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut678ea04925678ea179c8','2500509','wait',39,'adm09112754980.682000002')
20250120@191819.2360 98bku88creqkeg776bj8ie2gd4 Query : use flama_phc
20250120@191819.2363 98bku88creqkeg776bj8ie2gd4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@191819.2394 98bku88creqkeg776bj8ie2gd4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4797';
20250120@191819.2445 98bku88creqkeg776bj8ie2gd4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4797';
20250120@191819.2506 98bku88creqkeg776bj8ie2gd4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4797';
20250120@191819.2542 98bku88creqkeg776bj8ie2gd4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4797';
20250120@191819.3108 2b08f7ok847eo3khtrafj47lr4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250120@191819.3122 2b08f7ok847eo3khtrafj47lr4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250120@191819.3215 2b08f7ok847eo3khtrafj47lr4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4798';
20250120@191819.3287 2b08f7ok847eo3khtrafj47lr4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4798';
20250120@191819.3361 2b08f7ok847eo3khtrafj47lr4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4798';
20250120@191819.3417 2b08f7ok847eo3khtrafj47lr4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4798';
20250120@191819.4319 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250120@191819.4330 5u59su1l30l1r5dv7hsoa9jmtm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250120@191819.4403 5u59su1l30l1r5dv7hsoa9jmtm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4799';
20250120@191819.4472 5u59su1l30l1r5dv7hsoa9jmtm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4799';
20250120@191819.4540 5u59su1l30l1r5dv7hsoa9jmtm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4799';
20250120@191819.4575 5u59su1l30l1r5dv7hsoa9jmtm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4799';
20250120@191819.4626 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191819.4629 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250120@191819.4700 5u59su1l30l1r5dv7hsoa9jmtm Query : select no, estab,szadrsdesc from szadrs where u_coddest=23
20250120@191819.4838 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.658.00.01'
20250120@191819.4992 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='324.658.00.01' and bi.lordem =10000
20250120@191819.5351 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012043791,827000001 ' 
20250120@191819.5687 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.734.00.02'
20250120@191819.5821 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='324.734.00.02' and bi.lordem =20000
20250120@191819.8150 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012043841,647000002 ' 
20250120@191819.8493 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.727.00.01'
20250120@191819.8623 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='324.727.00.01' and bi.lordem =30000
20250120@191819.8977 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012043886,033000003 ' 
20250120@191819.9653 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.728.00.01'
20250120@191819.9799 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='324.728.00.01' and bi.lordem =40000
20250120@191820.5410 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012043923,497000004 ' 
20250120@191820.8840 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.969.00.01'
20250120@191820.1054 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='324.969.00.01' and bi.lordem =50000
20250120@191820.1423 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012043938,257000005 ' 
20250120@191820.1807 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1608.00.1'
20250120@191820.1936 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='324.1608.00.1' and bi.lordem =60000
20250120@191820.2291 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012043974,704000006 ' 
20250120@191820.2631 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2907.00.1'
20250120@191820.2775 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='324.2907.00.1' and bi.lordem =70000
20250120@191820.3485 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012043999,034000007 ' 
20250120@191820.3952 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1329.00.1'
20250120@191820.4325 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='324.1329.00.1' and bi.lordem =80000
20250120@191820.5126 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012044021,127000008 ' 
20250120@191820.5467 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1676.00.1'
20250120@191820.5644 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='324.1676.00.1' and bi.lordem =90000
20250120@191820.6715 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012044235,750000010 ' 
20250120@191820.7476 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '304.2185.00.1'
20250120@191820.7613 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000004 and bi.ref ='304.2185.00.1' and bi.lordem =100000
20250120@191820.7948 5u59su1l30l1r5dv7hsoa9jmtm Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll25012044332,024000011 ' 
20250120@191820.8286 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191820.8289 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 1 valor from ts where ts.ndos = 5
20250120@191820.8388 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191820.8392 5u59su1l30l1r5dv7hsoa9jmtm 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')
20250120@191820.8420 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20250120@191820.8578 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191820.8582 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 ~inactivo valor from fl where no = '100999' and estab = 0 order by inactivo desc
20250120@191820.8704 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191820.8708 5u59su1l30l1r5dv7hsoa9jmtm Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250120@191820.8748 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191820.8751 5u59su1l30l1r5dv7hsoa9jmtm Query : select szadrsstamp valor from szadrs where szadrsdesc='flama-fab.louÇas e electrodomesticos,sa'
20250120@191820.8802 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191820.8805 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from ts where ndos = 5
20250120@191820.8889 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191820.8907 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20250120@191820.8921 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191820.8936 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20250120@191820.8946 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191820.8961 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20250120@191820.8970 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20250120@191820.9105 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250120@191820.9257 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250120@191820.9363 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191820.9369 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100999' and estab=0
20250120@191820.9464 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191820.9481 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20250120@191820.9496 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678ea19215678ea17ce4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250120@191820.9563 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191820.9580 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20250120@191820.9593 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut678ea19215678ea17ce4','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20250120','19:48',?,?)
20250120@191820.9881 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191820.9904 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20250120@191820.9925 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut678ea19215678ea17ce4','trf entre armazéns a','2025-01-20',5,24,?,?,?,?,?,?,?,?,2025, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20250120@191821.5700 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.5740 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '324.658.00.01'
20250120@191821.5970 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.6000 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.658.00.01'
20250120@191821.7320 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.7350 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.658.00.01' and sa.armazem = 133 
20250120@191821.8080 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.8110 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.658.00.01'
20250120@191821.8350 5u59su1l30l1r5dv7hsoa9jmtm 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.658.00.01'
20250120@191821.9920 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.1010 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.1024 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.1039 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.1049 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='324.658.00.01' and lote = 'r2400222100a'
20250120@191821.1075 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191821.1090 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.1108 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.1122 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea98163678ea17d1a','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.1585 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.1608 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.1626 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea98163678ea17d1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,79.99,79.99*200.48,79.99,79.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,79.99*4.000,79.99*4.000*200.48 ,19.303000,19.303000*200.48 ,19.303000,19.303000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,79.99,79.99*200.48,79.99*4.000,79.99*4.000*200.48,'pll25012043791,827000001 ',79.99,79.99*4.000,79.99,79.99*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.2231 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.2237 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '324.734.00.02'
20250120@191821.2254 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.2257 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.734.00.02'
20250120@191821.2275 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.2278 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.734.00.02' and sa.armazem = 133 
20250120@191821.2373 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.2376 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.734.00.02'
20250120@191821.2396 5u59su1l30l1r5dv7hsoa9jmtm 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.734.00.02'
20250120@191821.2562 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.2579 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.2594 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.2610 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.2619 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='324.734.00.02' and lote = 'r2400471100a'
20250120@191821.2634 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191821.2647 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.2663 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.2679 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea57752678ea17d40','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.2856 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.2877 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.2895 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea57752678ea17d40',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 16.000, 16.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,20000 ,34.99,34.99*200.48,34.99,34.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,34.99*16.000,34.99*16.000*200.48 ,9.358000,9.358000*200.48 ,9.358000,9.358000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,34.99,34.99*200.48,34.99*16.000,34.99*16.000*200.48,'pll25012043841,647000002 ',34.99,34.99*16.000,34.99,34.99*16.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.3244 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.3249 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20250120@191821.3265 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.3268 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.727.00.01'
20250120@191821.3286 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.3293 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.727.00.01' and sa.armazem = 133 
20250120@191821.3384 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.3387 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.727.00.01'
20250120@191821.3409 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20250120@191821.3580 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.3599 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.3615 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.3633 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.3643 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2400239200a'
20250120@191821.3671 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191821.3686 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.3702 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.3714 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea60483678ea17d59','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.3895 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.3913 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.3930 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea60483678ea17d59',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 8.000, 8.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,30000 ,29.99,29.99*200.48,29.99,29.99*200.48 ,0,0,'un ','' ,bo.marcada,1 ,29.99*8.000,29.99*8.000*200.48 ,7.338000,7.338000*200.48 ,7.338000,7.338000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,29.99,29.99*200.48,29.99*8.000,29.99*8.000*200.48,'pll25012043886,033000003 ',29.99,29.99*8.000,29.99,29.99*8.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.4273 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.4279 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '324.728.00.01'
20250120@191821.4298 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.4301 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.728.00.01'
20250120@191821.4319 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.4322 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.728.00.01' and sa.armazem = 133 
20250120@191821.4413 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.4416 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.728.00.01'
20250120@191821.4437 5u59su1l30l1r5dv7hsoa9jmtm 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.728.00.01'
20250120@191821.4660 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.4724 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.4738 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.4761 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.4770 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='324.728.00.01' and lote = 'r2400238200a'
20250120@191821.5061 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191821.5174 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.5193 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.5206 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea28547678ea17d7e','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.5391 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.5412 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.5429 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea28547678ea17d7e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,40000 ,26.99,26.99*200.48,26.99,26.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,26.99*4.000,26.99*4.000*200.48 ,6.961000,6.961000*200.48 ,6.961000,6.961000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,26.99,26.99*200.48,26.99*4.000,26.99*4.000*200.48,'pll25012043923,497000004 ',26.99,26.99*4.000,26.99,26.99*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.5789 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.5795 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20250120@191821.5811 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.5814 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.969.00.01'
20250120@191821.5832 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.5835 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.969.00.01' and sa.armazem = 133 
20250120@191821.5916 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.5919 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.969.00.01'
20250120@191821.5948 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.969.00.01'
20250120@191821.6187 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.6207 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.6222 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.6237 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.6247 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20250120@191821.6284 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191821.6298 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.6314 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.6327 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea62898678ea17d99','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.6521 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.6545 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.6563 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea62898678ea17d99',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,50000 ,49.99,49.99*200.48,49.99,49.99*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,49.99*6.000,49.99*6.000*200.48 ,15.817000,15.817000*200.48 ,15.817000,15.817000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,49.99,49.99*200.48,49.99*6.000,49.99*6.000*200.48,'pll25012043938,257000005 ',49.99,49.99*6.000,49.99,49.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.6916 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.6921 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20250120@191821.6939 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.6942 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.1608.00.1'
20250120@191821.6962 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.6965 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1608.00.1' and sa.armazem = 133 
20250120@191821.8197 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.8204 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.1608.00.1'
20250120@191821.8236 5u59su1l30l1r5dv7hsoa9jmtm 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.1608.00.1'
20250120@191821.8419 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.8436 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.8449 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.8465 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.8474 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2400237100a'
20250120@191821.8488 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191821.8500 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.8514 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.8525 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea69400678ea17dcf','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.8701 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.8718 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.8734 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea69400678ea17dcf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,60000 ,39.99,39.99*200.48,39.99,39.99*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,39.99*6.000,39.99*6.000*200.48 ,12.567000,12.567000*200.48 ,12.567000,12.567000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,39.99,39.99*200.48,39.99*6.000,39.99*6.000*200.48,'pll25012043974,704000006 ',39.99,39.99*6.000,39.99,39.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.9081 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.9086 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '324.2907.00.1'
20250120@191821.9103 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.9105 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.2907.00.1'
20250120@191821.9122 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.9125 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.2907.00.1' and sa.armazem = 133 
20250120@191821.9201 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191821.9203 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.2907.00.1'
20250120@191821.9222 5u59su1l30l1r5dv7hsoa9jmtm 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.2907.00.1'
20250120@191821.9377 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.9393 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.9406 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.9421 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.9430 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='324.2907.00.1' and lote = 'r2400091200a'
20250120@191821.9457 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191821.9470 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.9485 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191821.9497 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea41428678ea17de7','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191821.9673 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191821.9692 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191821.9709 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea41428678ea17de7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,70000 ,19.99,19.99*200.48,19.99,19.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,19.99*4.000,19.99*4.000*200.48 ,3.839000,3.839000*200.48 ,3.839000,3.839000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,19.99,19.99*200.48,19.99*4.000,19.99*4.000*200.48,'pll25012043999,034000007 ',19.99,19.99*4.000,19.99,19.99*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191822.5700 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.6200 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '324.1329.00.1'
20250120@191822.8200 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.8500 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.1329.00.1'
20250120@191822.1030 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.1060 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1329.00.1' and sa.armazem = 133 
20250120@191822.1870 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.1910 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.1329.00.1'
20250120@191822.2090 5u59su1l30l1r5dv7hsoa9jmtm 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.1329.00.1'
20250120@191822.3600 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.3770 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191822.3900 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.4040 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191822.4130 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='324.1329.00.1' and lote = 'r2400496300a'
20250120@191822.4260 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191822.4400 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.4560 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191822.4680 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea28273678ea17e0a','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191822.6750 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.7000 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191822.7200 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea28273678ea17e0a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,80000 ,279.99,279.99*200.48,279.99,279.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,279.99*6.000,279.99*6.000*200.48 ,72.409000,72.409000*200.48 ,72.409000,72.409000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,279.99,279.99*200.48,279.99*6.000,279.99*6.000*200.48,'pll25012044021,127000008 ',279.99,279.99*6.000,279.99,279.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191822.1070 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.1076 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20250120@191822.1092 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.1095 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.1676.00.1'
20250120@191822.1111 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.1114 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1676.00.1' and sa.armazem = 133 
20250120@191822.1245 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.1277 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '324.1676.00.1'
20250120@191822.1300 5u59su1l30l1r5dv7hsoa9jmtm 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.1676.00.1'
20250120@191822.1462 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.1480 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191822.1494 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.1509 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191822.1517 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20250120@191822.1546 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191822.1559 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.1574 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191822.1586 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea77770678ea17e26','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191822.1761 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.1780 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191822.1797 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea77770678ea17e26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,90000 ,89.99,89.99*200.48,89.99,89.99*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,89.99*6.000,89.99*6.000*200.48 ,24.530000,24.530000*200.48 ,24.530000,24.530000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,89.99,89.99*200.48,89.99*6.000,89.99*6.000*200.48,'pll25012044235,750000010 ',89.99,89.99*6.000,89.99,89.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191822.2128 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.2133 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.usalote valor from st where st.ref = '304.2185.00.1'
20250120@191822.2149 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.2152 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '304.2185.00.1'
20250120@191822.2169 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.2172 5u59su1l30l1r5dv7hsoa9jmtm Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '304.2185.00.1' and sa.armazem = 133 
20250120@191822.2246 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.2249 5u59su1l30l1r5dv7hsoa9jmtm Query : select st.stns valor from st where st.ref = '304.2185.00.1'
20250120@191822.2269 5u59su1l30l1r5dv7hsoa9jmtm 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.2185.00.1'
20250120@191822.2423 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.2440 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191822.2453 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.2481 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191822.2490 5u59su1l30l1r5dv7hsoa9jmtm Query : select sestamp valor from se where ref ='304.2185.00.1' and lote = '211653'
20250120@191822.2533 5u59su1l30l1r5dv7hsoa9jmtm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250120@191822.2546 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.2562 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250120@191822.2574 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678ea85790678ea17e3e','aut678ea19215678ea17ce4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191822.2744 5u59su1l30l1r5dv7hsoa9jmtm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250120@191822.2764 5u59su1l30l1r5dv7hsoa9jmtm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250120@191822.2782 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut678ea85790678ea17e3e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 2.000, 2.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,100000 ,399.99,399.99*200.48,399.99,399.99*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,399.99*2.000,399.99*2.000*200.48 ,136.198000,136.198000*200.48 ,136.198000,136.198000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,399.99,399.99*200.48,399.99*2.000,399.99*2.000*200.48,'pll25012044332,024000011 ',399.99,399.99*2.000,399.99,399.99*2.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut678ea19215678ea17ce4'
20250120@191822.3138 5u59su1l30l1r5dv7hsoa9jmtm Query : insert into wsbocreationlog (initialstamp,externalid,creationstatus,documenttypeid,idustamp,transactionid) values ('aut678ea19215678ea17ce4','','wait',5,'adm12071144683,938000003','')
20250120@191822.3235 5u59su1l30l1r5dv7hsoa9jmtm Query : use flama_phc
20250120@191822.3239 5u59su1l30l1r5dv7hsoa9jmtm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@191822.3304 5u59su1l30l1r5dv7hsoa9jmtm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4799';
20250120@191822.3353 5u59su1l30l1r5dv7hsoa9jmtm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4799';
20250120@191910.7836 jm25ldel4r83q622ph19l8fqec Query : use flama_phc
20250120@191910.7841 jm25ldel4r83q622ph19l8fqec Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@191910.7943 jm25ldel4r83q622ph19l8fqec Query : use flama_phc
20250120@191910.7947 jm25ldel4r83q622ph19l8fqec Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@193610.4636 pl7ev7lelcg1bq54vk8mhht2m1 Query : use flama_phc
20250120@193610.4642 pl7ev7lelcg1bq54vk8mhht2m1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@193610.4735 pl7ev7lelcg1bq54vk8mhht2m1 Query : use flama_phc
20250120@193610.4739 pl7ev7lelcg1bq54vk8mhht2m1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@201909.7788 slttennmkejrku1rtvl5umju4d Query : use flama_phc
20250120@201909.7792 slttennmkejrku1rtvl5umju4d Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@201909.7883 slttennmkejrku1rtvl5umju4d Query : use flama_phc
20250120@201909.7887 slttennmkejrku1rtvl5umju4d Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@203610.2317 rsui04jppcrutbglgom5j7aphb Query : use flama_phc
20250120@203610.2321 rsui04jppcrutbglgom5j7aphb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@203610.2497 rsui04jppcrutbglgom5j7aphb Query : use flama_phc
20250120@203610.2501 rsui04jppcrutbglgom5j7aphb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@211910.6265 vkrjrj9c9ulgiv5einhg2ecsk6 Query : use flama_phc
20250120@211910.6271 vkrjrj9c9ulgiv5einhg2ecsk6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@211910.6370 vkrjrj9c9ulgiv5einhg2ecsk6 Query : use flama_phc
20250120@211910.6374 vkrjrj9c9ulgiv5einhg2ecsk6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@213610.4670 s0q8shhtrkf6fcc82vpk0g3okp Query : use flama_phc
20250120@213610.4675 s0q8shhtrkf6fcc82vpk0g3okp Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@213610.4769 s0q8shhtrkf6fcc82vpk0g3okp Query : use flama_phc
20250120@213610.4773 s0q8shhtrkf6fcc82vpk0g3okp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@221909.4383 f8hjndi34umv5351k68vt7etrn Query : use flama_phc
20250120@221909.4388 f8hjndi34umv5351k68vt7etrn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@221909.4489 f8hjndi34umv5351k68vt7etrn Query : use flama_phc
20250120@221909.4493 f8hjndi34umv5351k68vt7etrn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@223609.7288 ijufonvir9518i7u9oqp4fld6a Query : use flama_phc
20250120@223609.7293 ijufonvir9518i7u9oqp4fld6a Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@223609.7402 ijufonvir9518i7u9oqp4fld6a Query : use flama_phc
20250120@223609.7407 ijufonvir9518i7u9oqp4fld6a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@231909.6281 fbkabhmdnlgck613tkfgv6vs8u Query : use flama_phc
20250120@231909.6290 fbkabhmdnlgck613tkfgv6vs8u Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@231909.6392 fbkabhmdnlgck613tkfgv6vs8u Query : use flama_phc
20250120@231909.6396 fbkabhmdnlgck613tkfgv6vs8u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250120@233609.3058 9rks979f3bp91p87lthui1dknj Query : use flama_phc
20250120@233609.3065 9rks979f3bp91p87lthui1dknj Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250120@233609.3164 9rks979f3bp91p87lthui1dknj Query : use flama_phc
20250120@233609.3168 9rks979f3bp91p87lthui1dknj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@071909.4353 l1oc0kcar0digisokp2jdkrvps Query : use flama_phc
20250121@071909.4358 l1oc0kcar0digisokp2jdkrvps Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@071909.4545 l1oc0kcar0digisokp2jdkrvps Query : use flama_phc
20250121@071909.4549 l1oc0kcar0digisokp2jdkrvps Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@073644.6690 unfkd311ldlgtgfhlbgptfes4a Query : use flama_phc
20250121@073644.6695 unfkd311ldlgtgfhlbgptfes4a Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@073644.6848 unfkd311ldlgtgfhlbgptfes4a Query : use flama_phc
20250121@073644.6851 unfkd311ldlgtgfhlbgptfes4a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@081908.9536 tfu7df2bb9dchv0gllolb75i9d Query : use flama_phc
20250121@081908.9541 tfu7df2bb9dchv0gllolb75i9d Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@081908.9640 tfu7df2bb9dchv0gllolb75i9d Query : use flama_phc
20250121@081908.9644 tfu7df2bb9dchv0gllolb75i9d Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@083406.2085 bt5llknbfibns70jn24el3h1c3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250121@083406.2119 bt5llknbfibns70jn24el3h1c3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250121@083406.2440 bt5llknbfibns70jn24el3h1c3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4800';
20250121@083406.2514 bt5llknbfibns70jn24el3h1c3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4800';
20250121@083406.2603 bt5llknbfibns70jn24el3h1c3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4800';
20250121@083406.2643 bt5llknbfibns70jn24el3h1c3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4800';
20250121@083406.4208 f1jkvvsq97ss8gp35t40fbnjl0 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250121@083406.4222 f1jkvvsq97ss8gp35t40fbnjl0 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250121@083406.4314 f1jkvvsq97ss8gp35t40fbnjl0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4801';
20250121@083406.4386 f1jkvvsq97ss8gp35t40fbnjl0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4801';
20250121@083406.4467 f1jkvvsq97ss8gp35t40fbnjl0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4801';
20250121@083406.4513 f1jkvvsq97ss8gp35t40fbnjl0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4801';
20250121@083406.4576 f1jkvvsq97ss8gp35t40fbnjl0 Query : use flama_phc
20250121@083406.4580 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250121@083406.4701 f1jkvvsq97ss8gp35t40fbnjl0 Query : select no, estab,szadrsdesc from szadrs where u_coddest=00000001
20250121@083406.5779 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5365.00.1'
20250121@083406.5879 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5365.00.1'
20250121@083406.6687 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5365.00.1'
20250121@083406.6714 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5396.00.1'
20250121@083406.7504 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5396.00.1'
20250121@083406.7530 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5396.00.1'
20250121@083406.7565 f1jkvvsq97ss8gp35t40fbnjl0 Query : use flama_phc
20250121@083406.7570 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 1 valor from ts where ts.ndos = 5
20250121@083406.7640 f1jkvvsq97ss8gp35t40fbnjl0 Query : use flama_phc
20250121@083406.7643 f1jkvvsq97ss8gp35t40fbnjl0 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')
20250121@083406.7720 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20250121@083406.7884 f1jkvvsq97ss8gp35t40fbnjl0 Query : use flama_phc
20250121@083406.7888 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 ~inactivo valor from fl where no = '102245' and estab = 0 order by inactivo desc
20250121@083406.8038 f1jkvvsq97ss8gp35t40fbnjl0 Query : use flama_phc
20250121@083406.8042 f1jkvvsq97ss8gp35t40fbnjl0 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -230
20250121@083406.8373 f1jkvvsq97ss8gp35t40fbnjl0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4801';
20250121@083406.8430 f1jkvvsq97ss8gp35t40fbnjl0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4801';
20250121@083609.3754 br3quqtoa9781kualhve9ent7o Query : use flama_phc
20250121@083609.3759 br3quqtoa9781kualhve9ent7o Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@083609.3859 br3quqtoa9781kualhve9ent7o Query : use flama_phc
20250121@083609.3862 br3quqtoa9781kualhve9ent7o Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@091909.1491 dscmvu2arbm1ceh6td3aighdd4 Query : use flama_phc
20250121@091909.1523 dscmvu2arbm1ceh6td3aighdd4 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@091909.1879 dscmvu2arbm1ceh6td3aighdd4 Query : use flama_phc
20250121@091909.1883 dscmvu2arbm1ceh6td3aighdd4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@093609.3964 v4gq7fnguo9m62o7dvho4o60jb Query : use flama_phc
20250121@093609.3968 v4gq7fnguo9m62o7dvho4o60jb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@093609.4076 v4gq7fnguo9m62o7dvho4o60jb Query : use flama_phc
20250121@093609.4080 v4gq7fnguo9m62o7dvho4o60jb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@101909.8743 9igggbe53u49kil9qq52d3a197 Query : use flama_phc
20250121@101909.8748 9igggbe53u49kil9qq52d3a197 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@101909.8852 9igggbe53u49kil9qq52d3a197 Query : use flama_phc
20250121@101909.8856 9igggbe53u49kil9qq52d3a197 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@103609.8288 bbka8e9hkaq658bnpdc5u9nt39 Query : use flama_phc
20250121@103609.8293 bbka8e9hkaq658bnpdc5u9nt39 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@103609.8390 bbka8e9hkaq658bnpdc5u9nt39 Query : use flama_phc
20250121@103609.8394 bbka8e9hkaq658bnpdc5u9nt39 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@111911.8259 mugdknhq675q3u9ioe4u61m67l Query : use flama_phc
20250121@111911.8264 mugdknhq675q3u9ioe4u61m67l Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@111911.8359 mugdknhq675q3u9ioe4u61m67l Query : use flama_phc
20250121@111911.8363 mugdknhq675q3u9ioe4u61m67l Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@113611.8079 49oub94dmgh02cunr3sib7ne5t Query : use flama_phc
20250121@113611.8123 49oub94dmgh02cunr3sib7ne5t Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250121@113612.3880 49oub94dmgh02cunr3sib7ne5t Query : use flama_phc
20250121@113612.4340 49oub94dmgh02cunr3sib7ne5t Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250121@115203.1898 v22fclja32u3lp02oti1iqgmtf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250121@115203.1930 v22fclja32u3lp02oti1iqgmtf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250121@115203.2281 v22fclja32u3lp02oti1iqgmtf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4802';
20250121@115203.2357 v22fclja32u3lp02oti1iqgmtf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4802';
20250121@115203.2448 v22fclja32u3lp02oti1iqgmtf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4802';
20250121@115203.2495 v22fclja32u3lp02oti1iqgmtf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4802';
20250121@115203.2559 v22fclja32u3lp02oti1iqgmtf Query : use flama_phc
20250121@115203.2563 v22fclja32u3lp02oti1iqgmtf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250121@115203.2672 v22fclja32u3lp02oti1iqgmtf Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.727.00.01'
20250121@115203.2781 v22fclja32u3lp02oti1iqgmtf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400693 and bi.ref ='324.727.00.01' and bi.lordem =10000
20250121@115203.3144 v22fclja32u3lp02oti1iqgmtf Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24060663112,986000003 ' 
20250121@115203.3632 v22fclja32u3lp02oti1iqgmtf Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.719.00.02'
20250121@115203.3739 v22fclja32u3lp02oti1iqgmtf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400693 and bi.ref ='324.719.00.02' and bi.lordem =10000
20250121@115203.4090 v22fclja32u3lp02oti1iqgmtf Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24062540064,559000004 ' 
20250121@115203.4669 v22fclja32u3lp02oti1iqgmtf Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.736.00.01'
20250121@115203.4797 v22fclja32u3lp02oti1iqgmtf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400693 and bi.ref ='324.736.00.01' and bi.lordem =20000
20250121@115203.5133 v22fclja32u3lp02oti1iqgmtf Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24060663113,331000004 ' 
20250121@115203.5451 v22fclja32u3lp02oti1iqgmtf Query : use flama_phc
20250121@115203.5455 v22fclja32u3lp02oti1iqgmtf Query : select top 1 1 valor from ts where ts.ndos = 61
20250121@115203.5532 v22fclja32u3lp02oti1iqgmtf Query : use flama_phc
20250121@115203.5537 v22fclja32u3lp02oti1iqgmtf 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')
20250121@115203.5616 v22fclja32u3lp02oti1iqgmtf Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =61
20250121@115203.5752 v22fclja32u3lp02oti1iqgmtf Query : use flama_phc
20250121@115203.5755 v22fclja32u3lp02oti1iqgmtf Query : select top 1 ~inactivo valor from fl where no = '202315' and estab = 00 order by inactivo desc
20250121@115203.5865 v22fclja32u3lp02oti1iqgmtf Query : use flama_phc
20250121@115203.5869 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from ts where ndos = 61
20250121@115203.5933 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115203.6337 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 61
20250121@115203.6408 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115203.6426 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 61
20250121@115203.6450 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115203.6475 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 61
20250121@115203.6487 v22fclja32u3lp02oti1iqgmtf Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 61
20250121@115203.6599 v22fclja32u3lp02oti1iqgmtf Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2025 order by obrano desc
20250121@115203.6705 v22fclja32u3lp02oti1iqgmtf Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2025 order by obrano desc
20250121@115203.6729 v22fclja32u3lp02oti1iqgmtf Query : use flama_phc
20250121@115203.6745 v22fclja32u3lp02oti1iqgmtf Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='202315' and estab=00
20250121@115203.6822 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115203.6841 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 61
20250121@115203.6880 v22fclja32u3lp02oti1iqgmtf Query : insert into bo3 (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678f849599678f8a63a4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250121@115203.6943 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115203.6961 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 61
20250121@115203.6977 v22fclja32u3lp02oti1iqgmtf Query : insert into bo2 (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678f849599678f8a63a4','--','bo',7.8799489144316730523 ,1,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250121@115203.7140 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115203.7160 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 61
20250121@115203.7175 v22fclja32u3lp02oti1iqgmtf Query : insert into bo (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678f849599678f8a63a4','guia r. fornecedor','2025-01-21',61,2500230,?,?,?,?,?,?,?,?,2025, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250121@115207.1335 v22fclja32u3lp02oti1iqgmtf Query : use flama_phc
20250121@115207.1340 v22fclja32u3lp02oti1iqgmtf Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20250121@115207.1475 v22fclja32u3lp02oti1iqgmtf Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20250121@115207.1613 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115207.1634 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 61
20250121@115207.1653 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115207.1671 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 61
20250121@115207.1683 v22fclja32u3lp02oti1iqgmtf Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2400693100a'
20250121@115207.1750 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115207.1770 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'se' and documentnumber = 0
20250121@115207.1780 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115207.1805 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'se' and documentnumber = 0
20250121@115207.1822 v22fclja32u3lp02oti1iqgmtf Query : insert into se (sestamp,ref, lote, data,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut678f885346678f8a672b',?,?,'20250121',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut;','aut;')
20250121@115207.3268 v22fclja32u3lp02oti1iqgmtf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250121@115207.3319 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115207.3340 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 61
20250121@115207.3355 v22fclja32u3lp02oti1iqgmtf Query : insert into bi2 (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut678f812881678f8a6751','aut678f849599678f8a63a4',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from bo bo where bo.bostamp = 'aut678f849599678f8a63a4'
20250121@115207.3501 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250121@115207.3521 v22fclja32u3lp02oti1iqgmtf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 61
20250121@115207.3549 v22fclja32u3lp02oti1iqgmtf Query : insert into bi (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,obistamp ,stipo) select 'aut678f812881678f8a6751',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 2540, 2540*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,5.7043517017828,5.7043517017828*200.48,5.7043517017828,5.7043517017828*200.48 ,0,0,'un ','' ,bo.marcada,1 ,5.7043517017828*2540,5.7043517017828*2540*200.48 ,7.338000,7.338000*200.48 ,7.338000,7.338000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,5.7043517017828,5.7043517017828*200.48,5.7043517017828*2540,5.7043517017828*2540*200.48,'cps24060663112,986000003 ',44.95,44.95*2540,44.95,44.95*2540,?,?,?,4 from bo bo where bo.bostamp = 'aut678f849599678f8a63a4'
20250121@115227.3451 v22fclja32u3lp02oti1iqgmtf Query : use flama_phc
20250121@115227.3456 v22fclja32u3lp02oti1iqgmtf Query : select st.usalote valor from st where st.ref = '324.719.00.02'
20250121@115227.3604 v22fclja32u3lp02oti1iqgmtf Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.719.00.02'
20250121@115227.3966 v22fclja32u3lp02oti1iqgmtf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
