20240902@082147.6384 dh5ofeekq8kqaao5u1b4kqo1u3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@082147.6397 dh5ofeekq8kqaao5u1b4kqo1u3 Query : select sestamp valor from se where ref ='324.1896.00.1' and lote = 'r2101190100a'
20240902@082147.6634 dh5ofeekq8kqaao5u1b4kqo1u3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082147.6886 dh5ofeekq8kqaao5u1b4kqo1u3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@082147.7094 dh5ofeekq8kqaao5u1b4kqo1u3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d564451966d5678ba1','aut66d563509266d5678abc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240902@082147.7139 dh5ofeekq8kqaao5u1b4kqo1u3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082147.7340 dh5ofeekq8kqaao5u1b4kqo1u3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@082147.7372 dh5ofeekq8kqaao5u1b4kqo1u3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66d564451966d5678ba1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66d563509266d5678abc' ,0,0 ,2,23.00,30000,?,?,?,?)
20240902@082147.7905 dh5ofeekq8kqaao5u1b4kqo1u3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d563509266d5678abc','2405652','wait',39,'adm09112754980.682000002')
20240902@082147.8016 dh5ofeekq8kqaao5u1b4kqo1u3 Query : use flama_phc
20240902@082147.8020 dh5ofeekq8kqaao5u1b4kqo1u3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@082147.8053 dh5ofeekq8kqaao5u1b4kqo1u3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1746';
20240902@082147.8083 dh5ofeekq8kqaao5u1b4kqo1u3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1746';
20240902@082147.8136 dh5ofeekq8kqaao5u1b4kqo1u3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1746';
20240902@082147.8166 dh5ofeekq8kqaao5u1b4kqo1u3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1746';
20240902@082147.9583 6fu8ub4llh2q3tn0fohpaq54pg Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240902@082147.9595 6fu8ub4llh2q3tn0fohpaq54pg Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240902@082147.9855 6fu8ub4llh2q3tn0fohpaq54pg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1747';
20240902@082148.2250 6fu8ub4llh2q3tn0fohpaq54pg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1747';
20240902@082148.7300 6fu8ub4llh2q3tn0fohpaq54pg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1747';
20240902@082148.1291 6fu8ub4llh2q3tn0fohpaq54pg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1747';
20240902@082148.1615 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.1626 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240902@082148.1713 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.1718 6fu8ub4llh2q3tn0fohpaq54pg Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240902@082148.1822 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20240902@082148.2225 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.2229 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240902@082148.2266 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.2269 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 1 valor from td where td.ndoc = 39
20240902@082148.2302 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.2306 6fu8ub4llh2q3tn0fohpaq54pg 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')
20240902@082148.2337 6fu8ub4llh2q3tn0fohpaq54pg 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
20240902@082148.2374 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.2378 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240902@082148.2529 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.2533 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240902@082148.2567 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.2571 6fu8ub4llh2q3tn0fohpaq54pg Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240902@082148.2615 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.2619 6fu8ub4llh2q3tn0fohpaq54pg Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240902@082148.2671 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.2674 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from td where ndoc = 39
20240902@082148.2709 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240902@082148.2726 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.2747 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240902@082148.2768 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.2786 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240902@082148.3046 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.3067 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240902@082148.3083 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240902@082148.3156 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240902@082148.3171 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.3191 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240902@082148.3214 6fu8ub4llh2q3tn0fohpaq54pg Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d569254166d5678c4b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240902@082148.3498 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.3667 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240902@082148.3708 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240902@082148.3722 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240902@082148.3737 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240902@082148.3750 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240902@082148.3764 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240902@082148.3781 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240902@082148.3814 6fu8ub4llh2q3tn0fohpaq54pg Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d569254166d5678c4b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240902@082148.4192 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 fno valor from wsftdata order by fno desc
20240902@082148.4212 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.4230 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240902@082148.4256 6fu8ub4llh2q3tn0fohpaq54pg Query : select 'normal' from dummy
20240902@082148.4273 6fu8ub4llh2q3tn0fohpaq54pg Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d569254166d5678c4b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',534,100810,0,'2024-09-02',39,'euro',0,0,2024 ,?,?)
20240902@082148.4634 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.4639 6fu8ub4llh2q3tn0fohpaq54pg Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20240902@082148.4665 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1667.00.1'
20240902@082148.4974 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.4996 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@082148.5028 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.5046 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@082148.5057 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@082148.5070 6fu8ub4llh2q3tn0fohpaq54pg Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2400065200a'
20240902@082148.5091 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.5129 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@082148.5142 6fu8ub4llh2q3tn0fohpaq54pg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d568625766d5678c7c','aut66d569254166d5678c4b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240902@082148.5146 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.5163 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@082148.5194 6fu8ub4llh2q3tn0fohpaq54pg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66d568625766d5678c7c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d569254166d5678c4b' ,0,0 ,2,23.00,10000,?,?,?,?)
20240902@082148.5507 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.5526 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@082148.5553 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.5571 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@082148.5581 6fu8ub4llh2q3tn0fohpaq54pg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@082148.5595 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.5610 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@082148.5622 6fu8ub4llh2q3tn0fohpaq54pg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d566813566d5678c88','aut66d569254166d5678c4b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240902@082148.5628 6fu8ub4llh2q3tn0fohpaq54pg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.5642 6fu8ub4llh2q3tn0fohpaq54pg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@082148.5685 6fu8ub4llh2q3tn0fohpaq54pg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d566813566d5678c88',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d569254166d5678c4b' ,0,0 ,2,23.00,20000,?,?,?)
20240902@082148.5959 6fu8ub4llh2q3tn0fohpaq54pg Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d569254166d5678c4b','2405653','wait',39,'adm09112754980.682000002')
20240902@082148.6051 6fu8ub4llh2q3tn0fohpaq54pg Query : use flama_phc
20240902@082148.6055 6fu8ub4llh2q3tn0fohpaq54pg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@082148.6089 6fu8ub4llh2q3tn0fohpaq54pg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1747';
20240902@082148.6118 6fu8ub4llh2q3tn0fohpaq54pg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1747';
20240902@082148.6157 6fu8ub4llh2q3tn0fohpaq54pg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1747';
20240902@082148.6183 6fu8ub4llh2q3tn0fohpaq54pg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1747';
20240902@082148.6743 aqrbrlnd8dctod62q7566sqbt9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240902@082148.6755 aqrbrlnd8dctod62q7566sqbt9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240902@082148.6811 aqrbrlnd8dctod62q7566sqbt9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1748';
20240902@082148.8149 aqrbrlnd8dctod62q7566sqbt9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1748';
20240902@082148.8209 aqrbrlnd8dctod62q7566sqbt9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1748';
20240902@082148.8250 aqrbrlnd8dctod62q7566sqbt9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1748';
20240902@082148.8303 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.8307 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240902@082148.8382 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.8386 aqrbrlnd8dctod62q7566sqbt9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2064
20240902@082148.8487 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20240902@082148.8674 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1536.00.1'
20240902@082148.8871 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.8875 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240902@082148.8909 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.8914 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 1 valor from td where td.ndoc = 39
20240902@082148.8947 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.8951 aqrbrlnd8dctod62q7566sqbt9 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')
20240902@082148.8983 aqrbrlnd8dctod62q7566sqbt9 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
20240902@082148.9021 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.9025 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 ~inactivo valor from cl where no = '101645' and estab = 0 order by inactivo desc
20240902@082148.9245 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.9249 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240902@082148.9325 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.9330 aqrbrlnd8dctod62q7566sqbt9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240902@082148.9392 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.9397 aqrbrlnd8dctod62q7566sqbt9 Query : select szadrsstamp valor from szadrs where szadrsdesc='macorlux - electrodomÉsticos, s.a.'
20240902@082148.9538 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082148.9544 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from td where ndoc = 39
20240902@082148.9559 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240902@082148.9591 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.9623 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240902@082148.9669 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.9688 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240902@082148.9734 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.9753 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240902@082148.9773 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240902@082148.9955 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240902@082148.9971 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082148.9998 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240902@082149.1800 aqrbrlnd8dctod62q7566sqbt9 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d568088666d5678cee' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240902@082149.3150 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.3460 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240902@082149.4070 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240902@082149.4220 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240902@082149.4350 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240902@082149.4500 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240902@082149.4630 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240902@082149.5320 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240902@082149.5470 aqrbrlnd8dctod62q7566sqbt9 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d568088666d5678cee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240902@082149.8250 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 fno valor from wsftdata order by fno desc
20240902@082149.8500 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.8710 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240902@082149.8970 aqrbrlnd8dctod62q7566sqbt9 Query : select 'normal' from dummy
20240902@082149.9130 aqrbrlnd8dctod62q7566sqbt9 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d568088666d5678cee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',535,101645,0,'2024-09-02',39,'euro',0,0,2024 ,?,?)
20240902@082149.1236 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082149.1239 aqrbrlnd8dctod62q7566sqbt9 Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20240902@082149.1267 aqrbrlnd8dctod62q7566sqbt9 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'
20240902@082149.1444 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.1464 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@082149.1496 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.1514 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@082149.1524 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@082149.1540 aqrbrlnd8dctod62q7566sqbt9 Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20240902@082149.1565 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.1582 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@082149.1595 aqrbrlnd8dctod62q7566sqbt9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d562538566d5678d26','aut66d568088666d5678cee' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240902@082149.1600 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.1617 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@082149.1649 aqrbrlnd8dctod62q7566sqbt9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66d562538566d5678d26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66d568088666d5678cee' ,0,0 ,2,23.00,10000,?,?,?,?)
20240902@082149.1941 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082149.1944 aqrbrlnd8dctod62q7566sqbt9 Query : select st.usalote valor from st where st.ref = '324.1536.00.1'
20240902@082149.1968 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1536.00.1'
20240902@082149.2226 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.2271 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@082149.2309 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.2327 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@082149.2338 aqrbrlnd8dctod62q7566sqbt9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@082149.2352 aqrbrlnd8dctod62q7566sqbt9 Query : select sestamp valor from se where ref ='324.1536.00.1' and lote = 'r2100240100a'
20240902@082149.2376 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.2392 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@082149.2405 aqrbrlnd8dctod62q7566sqbt9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d565295866d5678d3a','aut66d568088666d5678cee' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240902@082149.2410 aqrbrlnd8dctod62q7566sqbt9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@082149.2426 aqrbrlnd8dctod62q7566sqbt9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@082149.2459 aqrbrlnd8dctod62q7566sqbt9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66d565295866d5678d3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66d568088666d5678cee' ,0,0 ,2,23.00,20000,?,?,?,?)
20240902@082149.2737 aqrbrlnd8dctod62q7566sqbt9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d568088666d5678cee','2405654','wait',39,'adm09112754980.682000002')
20240902@082149.2813 aqrbrlnd8dctod62q7566sqbt9 Query : use flama_phc
20240902@082149.2817 aqrbrlnd8dctod62q7566sqbt9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@082149.2850 aqrbrlnd8dctod62q7566sqbt9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1748';
20240902@082149.2882 aqrbrlnd8dctod62q7566sqbt9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1748';
20240902@082149.2926 aqrbrlnd8dctod62q7566sqbt9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1748';
20240902@082149.2955 aqrbrlnd8dctod62q7566sqbt9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1748';
20240902@083613.1380 610kcv3pflm9hjel1ojn2q5ruc Query : use flama_phc
20240902@083613.1440 610kcv3pflm9hjel1ojn2q5ruc Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@083613.2360 610kcv3pflm9hjel1ojn2q5ruc Query : use flama_phc
20240902@083613.2410 610kcv3pflm9hjel1ojn2q5ruc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@090545.1868 905j1pkh8erdtsikomges82458 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240902@090545.1883 905j1pkh8erdtsikomges82458 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240902@090545.1950 905j1pkh8erdtsikomges82458 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1749';
20240902@090545.2009 905j1pkh8erdtsikomges82458 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1749';
20240902@090545.2063 905j1pkh8erdtsikomges82458 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1749';
20240902@090545.2091 905j1pkh8erdtsikomges82458 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1749';
20240902@090545.2149 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2153 905j1pkh8erdtsikomges82458 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240902@090545.2223 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2226 905j1pkh8erdtsikomges82458 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240902@090545.2273 905j1pkh8erdtsikomges82458 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1684.00.1'
20240902@090545.2452 905j1pkh8erdtsikomges82458 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1578.00.1'
20240902@090545.2635 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2639 905j1pkh8erdtsikomges82458 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240902@090545.2676 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2680 905j1pkh8erdtsikomges82458 Query : select top 1 1 valor from td where td.ndoc = 39
20240902@090545.2714 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2718 905j1pkh8erdtsikomges82458 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')
20240902@090545.2750 905j1pkh8erdtsikomges82458 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
20240902@090545.2794 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2798 905j1pkh8erdtsikomges82458 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240902@090545.2833 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2837 905j1pkh8erdtsikomges82458 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240902@090545.2871 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2875 905j1pkh8erdtsikomges82458 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240902@090545.2920 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2924 905j1pkh8erdtsikomges82458 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240902@090545.2975 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.2979 905j1pkh8erdtsikomges82458 Query : select 1 valor from td where ndoc = 39
20240902@090545.2992 905j1pkh8erdtsikomges82458 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240902@090545.3009 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.3028 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240902@090545.3050 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.3070 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240902@090545.3102 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.3120 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240902@090545.3134 905j1pkh8erdtsikomges82458 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240902@090545.3205 905j1pkh8erdtsikomges82458 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240902@090545.3221 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.3684 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240902@090545.3702 905j1pkh8erdtsikomges82458 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d574735266d571d94c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240902@090545.4072 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.4093 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240902@090545.4195 905j1pkh8erdtsikomges82458 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240902@090545.4209 905j1pkh8erdtsikomges82458 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240902@090545.4224 905j1pkh8erdtsikomges82458 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240902@090545.4238 905j1pkh8erdtsikomges82458 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240902@090545.4254 905j1pkh8erdtsikomges82458 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240902@090545.4271 905j1pkh8erdtsikomges82458 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240902@090545.4285 905j1pkh8erdtsikomges82458 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d574735266d571d94c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240902@090545.4670 905j1pkh8erdtsikomges82458 Query : select top 1 fno valor from wsftdata order by fno desc
20240902@090545.4692 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.4710 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240902@090545.4736 905j1pkh8erdtsikomges82458 Query : select 'normal' from dummy
20240902@090545.4754 905j1pkh8erdtsikomges82458 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d574735266d571d94c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',536,100810,0,'2024-09-02',39,'euro',0,0,2024 ,?,?)
20240902@090545.5102 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.5106 905j1pkh8erdtsikomges82458 Query : select st.usalote valor from st where st.ref = '324.1684.00.1'
20240902@090545.5134 905j1pkh8erdtsikomges82458 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1684.00.1'
20240902@090545.5305 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.5325 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@090545.5356 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.5375 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@090545.5385 905j1pkh8erdtsikomges82458 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@090545.5402 905j1pkh8erdtsikomges82458 Query : select sestamp valor from se where ref ='324.1684.00.1' and lote = 'r2301217200a'
20240902@090545.5420 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.5446 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@090545.5461 905j1pkh8erdtsikomges82458 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d574725066d571d984','aut66d574735266d571d94c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240902@090545.5467 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.5485 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@090545.5518 905j1pkh8erdtsikomges82458 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66d574725066d571d984',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d574735266d571d94c' ,0,0 ,2,23.00,10000,?,?,?,?)
20240902@090545.5940 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.6022 905j1pkh8erdtsikomges82458 Query : select st.usalote valor from st where st.ref = '324.1578.00.1'
20240902@090545.6078 905j1pkh8erdtsikomges82458 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.1578.00.1'
20240902@090545.7294 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.7423 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@090545.7451 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.7467 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@090545.7476 905j1pkh8erdtsikomges82458 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@090545.7490 905j1pkh8erdtsikomges82458 Query : select sestamp valor from se where ref ='324.1578.00.1' and lote = 'r2101115200a'
20240902@090545.7506 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.7523 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@090545.7536 905j1pkh8erdtsikomges82458 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d570176866d571d9b7','aut66d574735266d571d94c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240902@090545.7541 905j1pkh8erdtsikomges82458 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090545.7557 905j1pkh8erdtsikomges82458 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@090545.7588 905j1pkh8erdtsikomges82458 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66d570176866d571d9b7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66d574735266d571d94c' ,0,0 ,2,23.00,20000,?,?,?,?)
20240902@090545.7883 905j1pkh8erdtsikomges82458 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d574735266d571d94c','2405634','wait',39,'adm09112754980.682000002')
20240902@090545.8058 905j1pkh8erdtsikomges82458 Query : use flama_phc
20240902@090545.8062 905j1pkh8erdtsikomges82458 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@090545.8129 905j1pkh8erdtsikomges82458 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1749';
20240902@090545.8175 905j1pkh8erdtsikomges82458 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1749';
20240902@090545.8250 905j1pkh8erdtsikomges82458 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1749';
20240902@090545.8294 905j1pkh8erdtsikomges82458 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1749';
20240902@090545.8876 2alq4o1bcpi7lninrkg7otubv8 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240902@090545.8904 2alq4o1bcpi7lninrkg7otubv8 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240902@090545.9000 2alq4o1bcpi7lninrkg7otubv8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1750';
20240902@090545.9082 2alq4o1bcpi7lninrkg7otubv8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1750';
20240902@090545.9176 2alq4o1bcpi7lninrkg7otubv8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1750';
20240902@090545.9222 2alq4o1bcpi7lninrkg7otubv8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1750';
20240902@090545.9327 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090545.9331 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240902@090545.9477 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090545.9481 2alq4o1bcpi7lninrkg7otubv8 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20240902@090545.9597 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9326.00.1'
20240902@090545.9797 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090545.9801 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240902@090545.9838 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090545.9842 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 1 valor from td where td.ndoc = 39
20240902@090545.9878 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090545.9882 2alq4o1bcpi7lninrkg7otubv8 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')
20240902@090545.9911 2alq4o1bcpi7lninrkg7otubv8 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
20240902@090545.9950 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090545.9954 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240902@090545.9989 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090545.9992 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240902@090546.2600 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090546.3000 2alq4o1bcpi7lninrkg7otubv8 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240902@090546.7400 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090546.7700 2alq4o1bcpi7lninrkg7otubv8 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20240902@090546.1280 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090546.1320 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from td where ndoc = 39
20240902@090546.1480 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240902@090546.1650 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.1920 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240902@090546.2260 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2430 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240902@090546.2780 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2960 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240902@090546.3160 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240902@090546.3890 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240902@090546.4060 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.4260 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240902@090546.4450 2alq4o1bcpi7lninrkg7otubv8 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66d579731666d571da07' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240902@090546.6500 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.6700 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240902@090546.7080 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240902@090546.7220 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240902@090546.7390 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240902@090546.7540 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240902@090546.7690 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240902@090546.7840 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240902@090546.7980 2alq4o1bcpi7lninrkg7otubv8 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66d579731666d571da07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240902@090546.1092 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 fno valor from wsftdata order by fno desc
20240902@090546.1114 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.1133 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240902@090546.1159 2alq4o1bcpi7lninrkg7otubv8 Query : select 'normal' from dummy
20240902@090546.1179 2alq4o1bcpi7lninrkg7otubv8 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66d579731666d571da07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',537,100810,0,'2024-09-02',39,'euro',0,0,2024 ,?,?)
20240902@090546.1963 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090546.2005 2alq4o1bcpi7lninrkg7otubv8 Query : select st.usalote valor from st where st.ref = '328.9326.00.1'
20240902@090546.2037 2alq4o1bcpi7lninrkg7otubv8 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 = '328.9326.00.1'
20240902@090546.2214 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2232 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@090546.2262 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2279 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@090546.2290 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@090546.2303 2alq4o1bcpi7lninrkg7otubv8 Query : select sestamp valor from se where ref ='328.9326.00.1' and lote = 'r2300691100a'
20240902@090546.2319 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2335 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@090546.2349 2alq4o1bcpi7lninrkg7otubv8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d579947866d571da38','aut66d579731666d571da07' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240902@090546.2354 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2371 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@090546.2403 2alq4o1bcpi7lninrkg7otubv8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66d579947866d571da38',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66d579731666d571da07' ,0,0 ,2,23.00,10000,?,?,?,?)
20240902@090546.2702 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2722 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@090546.2751 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2768 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@090546.2781 2alq4o1bcpi7lninrkg7otubv8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@090546.2794 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2811 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240902@090546.2827 2alq4o1bcpi7lninrkg7otubv8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d572108366d571da44','aut66d579731666d571da07' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240902@090546.2832 2alq4o1bcpi7lninrkg7otubv8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@090546.2850 2alq4o1bcpi7lninrkg7otubv8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240902@090546.2887 2alq4o1bcpi7lninrkg7otubv8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66d572108366d571da44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66d579731666d571da07' ,0,0 ,2,23.00,20000,?,?,?)
20240902@090546.3755 2alq4o1bcpi7lninrkg7otubv8 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66d579731666d571da07','2405635','wait',39,'adm09112754980.682000002')
20240902@090546.4401 2alq4o1bcpi7lninrkg7otubv8 Query : use flama_phc
20240902@090546.4405 2alq4o1bcpi7lninrkg7otubv8 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@090546.4440 2alq4o1bcpi7lninrkg7otubv8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1750';
20240902@090546.4473 2alq4o1bcpi7lninrkg7otubv8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1750';
20240902@090546.4518 2alq4o1bcpi7lninrkg7otubv8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1750';
20240902@090546.4544 2alq4o1bcpi7lninrkg7otubv8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1750';
20240902@091912.7090 9n12f35mvbq157ekstvbko0oto Query : use flama_phc
20240902@091912.7150 9n12f35mvbq157ekstvbko0oto Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@091912.8210 9n12f35mvbq157ekstvbko0oto Query : use flama_phc
20240902@091912.8260 9n12f35mvbq157ekstvbko0oto Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@093613.1127 r24ik16s05rfqk9ai4e5mn8497 Query : use flama_phc
20240902@093613.1217 r24ik16s05rfqk9ai4e5mn8497 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@093614.8664 r24ik16s05rfqk9ai4e5mn8497 Query : use flama_phc
20240902@093614.8784 r24ik16s05rfqk9ai4e5mn8497 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@101914.7262 bc2bf0s17v4btn834le8ucir8o Query : use flama_phc
20240902@101914.7267 bc2bf0s17v4btn834le8ucir8o Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@101914.7365 bc2bf0s17v4btn834le8ucir8o Query : use flama_phc
20240902@101914.7369 bc2bf0s17v4btn834le8ucir8o Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@103615.3039 saqvebkn8fprla3dsq6besiavm Query : use flama_phc
20240902@103615.3046 saqvebkn8fprla3dsq6besiavm Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@103615.3138 saqvebkn8fprla3dsq6besiavm Query : use flama_phc
20240902@103615.3141 saqvebkn8fprla3dsq6besiavm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@103709.9663 p5kdq0rnp581134l2ouol3k72l Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240902@103709.9680 p5kdq0rnp581134l2ouol3k72l Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240902@103709.9741 p5kdq0rnp581134l2ouol3k72l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1751';
20240902@103709.9914 p5kdq0rnp581134l2ouol3k72l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1751';
20240902@103710.1230 p5kdq0rnp581134l2ouol3k72l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1751';
20240902@103710.1275 p5kdq0rnp581134l2ouol3k72l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1751';
20240902@103710.1321 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103710.1325 p5kdq0rnp581134l2ouol3k72l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240902@103710.1401 p5kdq0rnp581134l2ouol3k72l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.649.00.01'
20240902@103710.1539 p5kdq0rnp581134l2ouol3k72l 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 = 2400406 and bi.ref ='324.649.00.01' and bi.lordem =20000
20240902@103710.1887 p5kdq0rnp581134l2ouol3k72l 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 = 'cps24041054970,562000002 ' 
20240902@103710.2321 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103710.2324 p5kdq0rnp581134l2ouol3k72l Query : select top 1 1 valor from ts where ts.ndos = 61
20240902@103710.2426 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103710.2429 p5kdq0rnp581134l2ouol3k72l 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')
20240902@103710.2463 p5kdq0rnp581134l2ouol3k72l 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
20240902@103710.2623 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103710.2627 p5kdq0rnp581134l2ouol3k72l Query : select top 1 ~inactivo valor from fl where no = '202549' and estab = 00 order by inactivo desc
20240902@103710.2770 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103710.2774 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from ts where ndos = 61
20240902@103710.2851 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.2869 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 61
20240902@103710.2882 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.2900 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 61
20240902@103710.2911 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.2929 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 61
20240902@103710.2946 p5kdq0rnp581134l2ouol3k72l 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
20240902@103710.3075 p5kdq0rnp581134l2ouol3k72l Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20240902@103710.3193 p5kdq0rnp581134l2ouol3k72l Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20240902@103710.3217 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103710.3224 p5kdq0rnp581134l2ouol3k72l Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='202549' and estab=00
20240902@103710.3315 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.3335 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 61
20240902@103710.3354 p5kdq0rnp581134l2ouol3k72l Query : insert into bo3 (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d588283866d587464e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240902@103710.3417 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.3436 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 61
20240902@103710.3453 p5kdq0rnp581134l2ouol3k72l Query : insert into bo2 (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d588283866d587464e','--','bo',7.8658892128279883381 ,1,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240902@103710.3746 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.3968 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 61
20240902@103710.3993 p5kdq0rnp581134l2ouol3k72l 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 ('aut66d588283866d587464e','guia r. fornecedor','2024-09-02',61,2402423,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240902@103710.4781 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103710.4785 p5kdq0rnp581134l2ouol3k72l Query : select st.usalote valor from st where st.ref = '324.649.00.01'
20240902@103710.4831 p5kdq0rnp581134l2ouol3k72l 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.649.00.01'
20240902@103710.5029 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.5070 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 61
20240902@103710.5088 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.5106 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 61
20240902@103710.5118 p5kdq0rnp581134l2ouol3k72l Query : select sestamp valor from se where ref ='324.649.00.01' and lote = 'r2400406200a'
20240902@103710.5133 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.5153 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'se' and documentnumber = 0
20240902@103710.5166 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.5189 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'se' and documentnumber = 0
20240902@103710.5203 p5kdq0rnp581134l2ouol3k72l Query : insert into se (sestamp,ref, lote, data,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d587202066d587467e',?,?,'20240902',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut;','aut;')
20240902@103710.6154 p5kdq0rnp581134l2ouol3k72l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@103710.6173 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.6248 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 61
20240902@103710.6272 p5kdq0rnp581134l2ouol3k72l Query : insert into bi2 (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66d581964066d5874696','aut66d588283866d587464e',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 = 'aut66d588283866d587464e'
20240902@103710.7298 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@103710.7548 p5kdq0rnp581134l2ouol3k72l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 61
20240902@103710.7607 p5kdq0rnp581134l2ouol3k72l 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 'aut66d581964066d5874696',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 1120, 1120*.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 ,24.01,24.01*200.48,24.01,24.01*200.48 ,0,0,'un ','' ,bo.marcada,1 ,24.01*1120,24.01*1120*200.48 ,31.935000,31.935000*200.48 ,31.935000,31.935000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,24.01,24.01*200.48,24.01*1120,24.01*1120*200.48,'cps24041054970,562000002 ',188.86,188.86*1120,188.86,188.86*1120,?,?,?,4 from bo bo where bo.bostamp = 'aut66d588283866d587464e'
20240902@103718.7863 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103718.7871 p5kdq0rnp581134l2ouol3k72l Query : declare @bostamp varchar(25) = 'aut66d588283866d587464e' ,@bistamp varchar(25) = '' update bi set tecoval = qtt * ecoval ,etecoval = qtt * eecoval ,tecoval2 = qtt * ecoval2 ,etecoval2 = qtt * eecoval2 where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end -- se tiver classificação e não for normal, não calcula nada update bi set ttdeb = 0 ,ettdeb = 0 ,ttmoeda = 0 where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and bi.classifc <> '' and bi.classifc <> 'normal' -- no caso normal com moeda euro if exists ( select 1 from bo cross apply ( select valor moeda from para1 where descricao = 'ge_pteoueuro' ) par where bo.bostamp = @bostamp and bo.moeda = par.moeda ) begin -- sem ecovalores update bi set ettdeb = round(bi.qtt * ((bi.edebito * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100))), 6) ,ttdeb = round(bi.qtt * ((bi.debito * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100))), 6) ,ttmoeda = 0 from bi inner join bo on bi.bostamp = bo.bostamp where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.econotcalc = 1 -- com ecovalores update bi set ettdeb = round(bi.qtt * ( ( bi.edebito + ( iif(p.st_econotdesc = 1, - bi.eecoval2, bi.eecoval) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ) ) ) * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) ), 6) + ( bi.qtt * iif(p.st_econotdesc = 1, (bi.eecoval + bi.eecoval2) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ), 0) ) ,ttdeb = round(bi.qtt * ( ( bi.debito + ( iif(p.st_econotdesc = 1, - bi.ecoval2, bi.ecoval) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ) ) ) * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) ), 6) + ( bi.qtt * iif(p.st_econotdesc = 1, (bi.ecoval + bi.ecoval2) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ), 0) ) ,ttmoeda = 0 from bi inner join bo on bi.bostamp = bo.bostamp left join st on bi.ref = st.ref left join taxasiva tiva on bi.tabiva = tiva.codigo cross apply ( select max(valor) st_econotdesc from ( select case when valor = 's' then 1 else 0 end valor from para1 where descricao = 'st_econotdesc' union all select 0 ) a ) p where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.econotcalc = 0 --acrescenta os descontos em valor, caso existam: update bi set ettdeb = round(bi.ettdeb - (bi.qtt * bi.evaldesc), 2) ,ttdeb = round(bi.ttdeb - (bi.qtt * bi.valdesc), 2) ,ttmoeda = 0 from bi where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.valdesc <> 0 end else begin update bi set ttmoeda = round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2) ,ettdeb = case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ,edebito = case when bi.qtt = 0 then 0 else round(abs(( case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ) / (1 - bi.desconto / 100) / (1 - bi.desc2 / 100) / (1 - bi.desc3 / 100) / (1 - bi.desc4 / 100) / (1 - bi.desc5 / 100) / (1 - bi.desc6 / 100) / bi.qtt), 2) end ,debito = case when bi.qtt = 0 then 0 else round(abs(( case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ) / (1 - bi.desconto / 100) / (1 - bi.desc2 / 100) / (1 - bi.desc3 / 100) / (1 - bi.desc4 / 100) / (1 - bi.desc5 / 100) / (1 - bi.desc6 / 100) / bi.qtt), 2) end * 200.482 from bi inner join bo2 on bi.bostamp = bo2.bo2stamp where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) update bi set ttdeb = round(bi.ttdeb - (bi.qtt * bi.valdesc), 2) ,ettdeb = round(bi.ettdeb - (bi.qtt * bi.evaldesc), 0) ,debito = round(bi.debito - (bi.qtt * bi.valdesc), 2) ,edebito = round(bi.edebito - (bi.qtt * bi.evaldesc), 2) where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.valdesc <> 0 end 
20240902@103730.5164 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103730.5169 p5kdq0rnp581134l2ouol3k72l Query : select 1 valor from bo where bo.bostamp = 'aut66d588283866d587464e'
20240902@103730.5282 p5kdq0rnp581134l2ouol3k72l Query : declare @errno int ,@errmsg varchar(255) ,@prod bit ,@nrdec numeric(10, 0) ,@totaldeb numeric(18, 5) ,@etotaldeb numeric(19, 6) ,@total numeric(18, 5) ,@etotal numeric(19, 6) ,@custo numeric(18, 5) ,@ecusto numeric(19, 6) ,@bo_1iliq numeric(19, 6) ,@bo_2iliq numeric(19, 6) ,@base1 numeric(19, 6) ,@base2 numeric(19, 6) ,@moetotal numeric(13, 3) ,@smoe1 numeric(13, 3) ,@smoe2 numeric(13, 3) ,@smoe3 numeric(13, 3) ,@smoe4 numeric(13, 3) ,@bo11_bins numeric(18, 5) ,@bo21_bins numeric(18, 5) ,@bo31_bins numeric(18, 5) ,@bo41_bins numeric(18, 5) ,@bo51_bins numeric(18, 5) ,@bo61_bins numeric(18, 5) ,@bo71_bins numeric(18, 5) ,@bo81_bins numeric(18, 5) ,@bo91_bins numeric(18, 5) ,@bo12_bins numeric(18, 5) ,@bo22_bins numeric(18, 5) ,@bo32_bins numeric(18, 5) ,@bo42_bins numeric(18, 5) ,@bo52_bins numeric(18, 5) ,@bo62_bins numeric(18, 5) ,@bo72_bins numeric(18, 5) ,@bo82_bins numeric(18, 5) ,@bo92_bins numeric(18, 5) ,@ebo11_bins numeric(19, 6) ,@ebo21_bins numeric(19, 6) ,@ebo31_bins numeric(19, 6) ,@ebo41_bins numeric(19, 6) ,@ebo51_bins numeric(19, 6) ,@ebo61_bins numeric(19, 6) ,@ebo71_bins numeric(18, 5) ,@ebo81_bins numeric(18, 5) ,@ebo91_bins numeric(18, 5) ,@ebo12_bins numeric(19, 6) ,@ebo22_bins numeric(19, 6) ,@ebo32_bins numeric(19, 6) ,@ebo42_bins numeric(19, 6) ,@ebo52_bins numeric(19, 6) ,@ebo62_bins numeric(19, 6) ,@ebo72_bins numeric(18, 5) ,@ebo82_bins numeric(18, 5) ,@ebo92_bins numeric(18, 5) ,@bo11_iva numeric(18, 5) ,@bo21_iva numeric(18, 5) ,@bo31_iva numeric(18, 5) ,@bo41_iva numeric(18, 5) ,@bo51_iva numeric(18, 5) ,@bo61_iva numeric(18, 5) ,@bo71_iva numeric(18, 5) ,@bo81_iva numeric(18, 5) ,@bo91_iva numeric(18, 5) ,@bo12_iva numeric(18, 5) ,@bo22_iva numeric(18, 5) ,@bo32_iva numeric(18, 5) ,@bo42_iva numeric(18, 5) ,@bo52_iva numeric(18, 5) ,@bo62_iva numeric(18, 5) ,@bo72_iva numeric(18, 5) ,@bo82_iva numeric(18, 5) ,@bo92_iva numeric(18, 5) ,@ebo11_iva numeric(19, 6) ,@ebo21_iva numeric(19, 6) ,@ebo31_iva numeric(19, 6) ,@ebo41_iva numeric(19, 6) ,@ebo51_iva numeric(19, 6) ,@ebo61_iva numeric(19, 6) ,@ebo71_iva numeric(18, 5) ,@ebo81_iva numeric(18, 5) ,@ebo91_iva numeric(18, 5) ,@ebo12_iva numeric(19, 6) ,@ebo22_iva numeric(19, 6) ,@ebo32_iva numeric(19, 6) ,@ebo42_iva numeric(19, 6) ,@ebo52_iva numeric(19, 6) ,@ebo62_iva numeric(19, 6) ,@ebo72_iva numeric(18, 5) ,@ebo82_iva numeric(18, 5) ,@ebo92_iva numeric(18, 5) ,@esdeb1 numeric(19, 6) ,@esdeb2 numeric(19, 6) ,@esdeb3 numeric(19, 6) ,@esdeb4 numeric(19, 6) ,@sdeb1 numeric(18, 5) ,@sdeb2 numeric(18, 5) ,@sdeb3 numeric(18, 5) ,@sdeb4 numeric(18, 5) ,@estot1 numeric(19, 6) ,@estot2 numeric(19, 6) ,@estot3 numeric(19, 6) ,@estot4 numeric(19, 6) ,@stot1 numeric(18, 5) ,@stot2 numeric(18, 5) ,@stot3 numeric(18, 5) ,@stot4 numeric(18, 5) ,@ebo_1tvall numeric(19, 6) ,@ebo_2tvall numeric(19, 6) ,@bo_1tvall numeric(18, 5) ,@bo_2tvall numeric(18, 5) ,@ebo_totp1 numeric(19, 6) ,@ebo_totp2 numeric(19, 6) ,@bo_totp1 numeric(18, 5) ,@bo_totp2 numeric(18, 5) ,@sqtt11 numeric(13, 3) ,@sqtt21 numeric(13, 3) ,@sqtt12 numeric(13, 3) ,@sqtt22 numeric(13, 3) ,@sqtt13 numeric(13, 3) ,@sqtt23 numeric(13, 3) ,@sqtt14 numeric(13, 3) ,@sqtt24 numeric(13, 3) ,@userinis varchar (30) ,@mybostamp char(25) = 'aut66d588283866d587464e' declare @totaisiva table ( bostamp varchar (25), codigo numeric(1), taxa numeric (5,2), ebaseinc numeric (19,6), baseinc numeric (18,5), evalor numeric (19,6), valor numeric (18,5) ) set @prod = ( select ts.producao from bo(nolock) inner join ts(nolock) on bo.ndos = ts.ndos and bo.bostamp = @mybostamp ) set @nrdec = ( select convert(numeric(10, 0), valor) from para1(nolock) where descricao = 'de_euro' ) --set @prod = 0 --set @nrdec = 2 select @ecusto = sum(bi.epcusto * bi.qtt) ,@custo = sum(bi.pcusto * bi.qtt) ,@bo11_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo21_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo31_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo41_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo51_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo61_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo71_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo81_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo91_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo12_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo22_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo32_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo42_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo52_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo62_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo72_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo82_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo92_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo11_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo21_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo31_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo41_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo51_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo61_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo71_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo81_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo91_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo12_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo22_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo32_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo42_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo52_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo62_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo72_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo82_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo92_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo_1iliq = round(sum(bi.qtt * bi.epu), @nrdec) ,@bo_2iliq = round(sum(bi.ettdeb), @nrdec) ,@bo11_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo12_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo21_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo22_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo31_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo32_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo41_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo42_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo51_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo52_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo61_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo62_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo71_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo72_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo81_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo82_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo91_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo92_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo11_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo12_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo21_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo22_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo31_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo32_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo41_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo42_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo51_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo52_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo61_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo62_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo71_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo72_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo81_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo82_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo91_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else bi.ettdeb - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo92_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@esdeb1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.ettdeb else bi.ettdeb - round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@esdeb2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.ettdeb else bi.ettdeb - round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@esdeb3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.ettdeb else bi.ettdeb - round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@esdeb4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) * bi.iva / 100, @nrdec) end else 0 end) ,@sdeb1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.ttdeb else bi.ttdeb - round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@sdeb2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.ttdeb else bi.ttdeb - round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@sdeb3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.ttdeb else bi.ttdeb - round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@sdeb4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) * bi.iva / 100, @nrdec) end else 0 end) ,@smoe1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@smoe2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@smoe3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@smoe4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@total = @stot1 + @stot2 + @stot3 + @stot4 ,@etotal = @estot1 + @estot2 + @estot3 + @estot4 ,@totaldeb = @sdeb1 + @sdeb2 + @sdeb3 + @sdeb4 ,@etotaldeb = @esdeb1 + @esdeb2 + @esdeb3 + @esdeb4 ,@moetotal = @smoe1 + @smoe2 + @smoe3 + @smoe4 ,@ebo_1tvall = @ebo11_bins + @ebo21_bins + @ebo31_bins + @ebo41_bins + @ebo51_bins + @ebo61_bins + @ebo71_bins + @ebo81_bins + @ebo91_bins ,@ebo_2tvall = @ebo12_bins + @ebo22_bins + @ebo32_bins + @ebo42_bins + @ebo52_bins + @ebo62_bins + @ebo72_bins + @ebo82_bins + @ebo92_bins ,@bo_1tvall = @bo11_bins + @bo21_bins + @bo31_bins + @bo41_bins + @bo51_bins + @bo61_bins + @bo71_bins + @bo81_bins + @bo91_bins ,@bo_2tvall = @bo12_bins + @bo22_bins + @bo32_bins + @bo42_bins + @bo52_bins + @bo62_bins + @bo72_bins + @bo82_bins + @bo92_bins ,@ebo_totp1 = sum(case when bi.ivaincl = 0 then (bi.epu * bi.qtt) else round((bi.epu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@ebo_totp2 = sum(case when bi.ivaincl = 0 then (bi.edebito * bi.qtt) else round((bi.edebito * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@bo_totp1 = sum(case when bi.ivaincl = 0 then (bi.pu * bi.qtt) else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@bo_totp2 = sum(case when bi.ivaincl = 0 then (bi.debito * bi.qtt) else round((bi.debito * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@sqtt11 = sum(case when bi.stipo = 1 then bi.qtt else 0 end) ,@sqtt21 = sum(case when bi.stipo = 1 then bi.qtt else 0 end) ,@sqtt12 = sum(case when bi.stipo = 2 then bi.qtt else 0 end) ,@sqtt22 = sum(case when bi.stipo = 2 then bi.qtt else 0 end) ,@sqtt13 = sum(case when bi.stipo = 3 then bi.qtt else 0 end) ,@sqtt23 = sum(case when bi.stipo = 3 then bi.qtt else 0 end) ,@sqtt14 = sum(case when bi.stipo = 4 then bi.qtt else 0 end) ,@sqtt24 = sum(case when bi.stipo = 5 then bi.qtt else 0 end) from bi(nolock) where bi.bostamp = @mybostamp and bi.producao = case when @prod = 1 then 1 else bi.producao end and bi.composto = 0 and bi.qtt <> 0 update bo set bo.totaldeb = isnull(@totaldeb, 0) ,bo.total = isnull(@total, 0) ,bo.etotaldeb = isnull(@etotaldeb, 0) ,bo.moetotal = isnull(@moetotal, 0) ,bo.etotal = isnull(@etotal, 0) ,bo.ecusto = isnull(@ecusto, 0) ,bo.custo = isnull(@custo, 0) ,bo.bo11_bins = isnull(@bo11_bins, 0) ,bo.bo12_bins = isnull(@bo12_bins, 0) ,bo.bo21_bins = isnull(@bo21_bins, 0) ,bo.bo22_bins = isnull(@bo22_bins, 0) ,bo.bo31_bins = isnull(@bo31_bins, 0) ,bo.bo32_bins = isnull(@bo32_bins, 0) ,bo.bo41_bins = isnull(@bo41_bins, 0) ,bo.bo42_bins = isnull(@bo42_bins, 0) ,bo.bo51_bins = isnull(@bo51_bins, 0) ,bo.bo52_bins = isnull(@bo52_bins, 0) ,bo.bo61_bins = isnull(@bo61_bins, 0) ,bo.bo62_bins = isnull(@bo62_bins, 0) ,bo.ebo11_bins = isnull(@ebo11_bins, 0) ,bo.ebo12_bins = isnull(@ebo12_bins, 0) ,bo.ebo21_bins = isnull(@ebo21_bins, 0) ,bo.ebo22_bins = isnull(@ebo22_bins, 0) ,bo.ebo31_bins = isnull(@ebo31_bins, 0) ,bo.ebo32_bins = isnull(@ebo32_bins, 0) ,bo.ebo41_bins = isnull(@ebo41_bins, 0) ,bo.ebo42_bins = isnull(@ebo42_bins, 0) ,bo.ebo51_bins = isnull(@ebo51_bins, 0) ,bo.ebo52_bins = isnull(@ebo52_bins, 0) ,bo.ebo61_bins = isnull(@ebo61_bins, 0) ,bo.ebo62_bins = isnull(@ebo62_bins, 0) ,bo.bo11_iva = isnull(@bo11_iva, 0) ,bo.bo12_iva = isnull(@bo12_iva, 0) ,bo.bo21_iva = isnull(@bo21_iva, 0) ,bo.bo22_iva = isnull(@bo22_iva, 0) ,bo.bo31_iva = isnull(@bo31_iva, 0) ,bo.bo32_iva = isnull(@bo32_iva, 0) ,bo.bo41_iva = isnull(@bo41_iva, 0) ,bo.bo42_iva = isnull(@bo42_iva, 0) ,bo.bo51_iva = isnull(@bo51_iva, 0) ,bo.bo52_iva = isnull(@bo52_iva, 0) ,bo.bo61_iva = isnull(@bo61_iva, 0) ,bo.bo62_iva = isnull(@bo62_iva, 0) ,bo.ebo11_iva = isnull(@ebo11_iva, 0) ,bo.ebo12_iva = isnull(@ebo12_iva, 0) ,bo.ebo21_iva = isnull(@ebo21_iva, 0) ,bo.ebo22_iva = isnull(@ebo22_iva, 0) ,bo.ebo31_iva = isnull(@ebo31_iva, 0) ,bo.ebo32_iva = isnull(@ebo32_iva, 0) ,bo.ebo41_iva = isnull(@ebo41_iva, 0) ,bo.ebo42_iva = isnull(@ebo42_iva, 0) ,bo.ebo51_iva = isnull(@ebo51_iva, 0) ,bo.ebo52_iva = isnull(@ebo52_iva, 0) ,bo.ebo61_iva = isnull(@ebo61_iva, 0) ,bo.ebo62_iva = isnull(@ebo62_iva, 0) ,bo.esdeb1 = isnull(@esdeb1, 0) ,bo.esdeb2 = isnull(@esdeb2, 0) ,bo.esdeb3 = isnull(@esdeb3, 0) ,bo.esdeb4 = isnull(@esdeb4, 0) ,bo.sdeb1 = isnull(@sdeb1, 0) ,bo.sdeb2 = isnull(@sdeb2, 0) ,bo.sdeb3 = isnull(@sdeb3, 0) ,bo.sdeb4 = isnull(@sdeb4, 0) ,bo.smoe1 = isnull(@smoe1, 0) ,bo.smoe2 = isnull(@smoe2, 0) ,bo.smoe3 = isnull(@smoe3, 0) ,bo.smoe4 = isnull(@smoe4, 0) ,bo.estot1 = isnull(@estot1, 0) ,bo.estot2 = isnull(@estot2, 0) ,bo.estot3 = isnull(@estot3, 0) ,bo.estot4 = isnull(@estot4, 0) ,bo.stot1 = isnull(@stot1, 0) ,bo.stot2 = isnull(@stot2, 0) ,bo.stot3 = isnull(@stot3, 0) ,bo.stot4 = isnull(@stot4, 0) ,bo.ebo_1tvall = isnull(@ebo_1tvall, 0) ,bo.ebo_2tvall = isnull(@ebo_2tvall, 0) ,bo.bo_1tvall = isnull(@bo_1tvall, 0) ,bo.bo_2tvall = isnull(@bo_2tvall, 0) ,bo.ebo_totp1 = isnull(@ebo_totp1, 0) ,bo.ebo_totp2 = isnull(@ebo_totp2, 0) ,bo.bo_totp1 = isnull(@bo_totp1, 0) ,bo.bo_totp2 = isnull(@bo_totp2, 0) ,bo.sqtt11 = isnull(@sqtt11, 0) ,bo.sqtt21 = isnull(@sqtt21, 0) ,bo.sqtt12 = isnull(@sqtt12, 0) ,bo.sqtt22 = isnull(@sqtt22, 0) ,bo.sqtt13 = isnull(@sqtt13, 0) ,bo.sqtt23 = isnull(@sqtt23, 0) ,bo.sqtt14 = isnull(@sqtt14, 0) ,bo.sqtt24 = isnull(@sqtt24, 0) where bostamp = @mybostamp update bo2 set bo2.bo71_bins = isnull(@bo71_bins, 0) ,bo2.bo72_bins = isnull(@bo72_bins, 0) ,bo2.bo81_bins = isnull(@bo81_bins, 0) ,bo2.bo82_bins = isnull(@bo82_bins, 0) ,bo2.bo91_bins = isnull(@bo91_bins, 0) ,bo2.bo92_bins = isnull(@bo92_bins, 0) ,bo2.ebo71_bins = isnull(@ebo71_bins, 0) ,bo2.ebo72_bins = isnull(@ebo72_bins, 0) ,bo2.ebo81_bins = isnull(@ebo81_bins, 0) ,bo2.ebo82_bins = isnull(@ebo82_bins, 0) ,bo2.ebo91_bins = isnull(@ebo91_bins, 0) ,bo2.ebo92_bins = isnull(@ebo92_bins, 0) ,bo2.bo71_iva = isnull(@bo71_iva, 0) ,bo2.bo72_iva = isnull(@bo72_iva, 0) ,bo2.bo81_iva = isnull(@bo81_iva, 0) ,bo2.bo82_iva = isnull(@bo82_iva, 0) ,bo2.bo91_iva = isnull(@bo91_iva, 0) ,bo2.bo92_iva = isnull(@bo92_iva, 0) ,bo2.ebo71_iva = isnull(@ebo71_iva, 0) ,bo2.ebo72_iva = isnull(@ebo72_iva, 0) ,bo2.ebo81_iva = isnull(@ebo81_iva, 0) ,bo2.ebo82_iva = isnull(@ebo82_iva, 0) ,bo2.ebo91_iva = isnull(@ebo91_iva, 0) ,bo2.ebo92_iva = isnull(@ebo92_iva, 0) ,bo2.etotalciva = isnull(@etotaldeb, 0) + isnull(@ebo12_iva, 0) +isnull(@ebo22_iva, 0) +isnull(@ebo32_iva, 0) +isnull(@ebo42_iva, 0) +isnull(@ebo52_iva, 0) +isnull(@ebo62_iva, 0) +isnull(@ebo72_iva, 0) +isnull(@ebo82_iva, 0) +isnull(@ebo92_iva, 0) --,bo2.mtotalciva =isnull(@moetotal, 0) where bo2stamp = @mybostamp -- trata os bot select @userinis = usrinis from bo where bo.bostamp=@mybostamp insert into @totaisiva ( bostamp, codigo, taxa, ebaseinc, baseinc, evalor, valor ) select @mybostamp,codigo,taxa ,case when (@ebo11_bins <>0) then @ebo11_bins else @ebo12_bins end ,case when (@ebo11_bins <>0) then @bo11_bins else @bo12_bins end ,case when (@ebo11_bins <>0) then @ebo11_iva else @ebo12_iva end ,case when (@ebo11_bins <>0) then @bo11_iva else @bo12_iva end from taxasiva where codigo = 1 union all select @mybostamp,codigo,taxa ,case when (@ebo21_bins <>0) then @ebo21_bins else @ebo22_bins end ,case when (@ebo21_bins <>0) then @bo21_bins else @bo22_bins end ,case when (@ebo21_bins <>0) then @ebo21_iva else @ebo22_iva end ,case when (@ebo21_bins <>0) then @bo21_iva else @bo22_iva end from taxasiva where codigo = 2 union all select @mybostamp,codigo,taxa ,case when (@ebo31_bins <>0) then @ebo31_bins else @ebo32_bins end ,case when (@ebo31_bins <>0) then @bo31_bins else @bo32_bins end ,case when (@ebo31_bins <>0) then @ebo31_iva else @ebo32_iva end ,case when (@ebo31_bins <>0) then @bo31_iva else @bo32_iva end from taxasiva where codigo = 3 union all select @mybostamp,codigo,taxa ,case when (@ebo41_bins <>0) then @ebo41_bins else @ebo42_bins end ,case when (@ebo41_bins <>0) then @bo41_bins else @bo42_bins end ,case when (@ebo41_bins <>0) then @ebo41_iva else @ebo42_iva end ,case when (@ebo41_bins <>0) then @bo41_iva else @bo42_iva end from taxasiva where codigo = 4 union all select @mybostamp,codigo,taxa ,case when (@ebo51_bins <>0) then @ebo51_bins else @ebo52_bins end ,case when (@ebo51_bins <>0) then @bo51_bins else @bo52_bins end ,case when (@ebo51_bins <>0) then @ebo51_iva else @ebo52_iva end ,case when (@ebo51_bins <>0) then @bo51_iva else @bo52_iva end from taxasiva where codigo = 5 union all select @mybostamp,codigo,taxa ,case when (@ebo61_bins <>0) then @ebo61_bins else @ebo62_bins end ,case when (@ebo61_bins <>0) then @bo61_bins else @bo62_bins end ,case when (@ebo61_bins <>0) then @ebo61_iva else @ebo62_iva end ,case when (@ebo61_bins <>0) then @bo61_iva else @bo62_iva end from taxasiva where codigo = 6 union all select @mybostamp,codigo,taxa ,case when (@ebo71_bins <>0) then @ebo71_bins else @ebo72_bins end ,case when (@ebo71_bins <>0) then @bo71_bins else @bo72_bins end ,case when (@ebo71_bins <>0) then @ebo71_iva else @ebo72_iva end ,case when (@ebo71_bins <>0) then @bo71_iva else @bo72_iva end from taxasiva where codigo = 7 union all select @mybostamp,codigo,taxa ,case when (@ebo81_bins <>0) then @ebo81_bins else @ebo82_bins end ,case when (@ebo81_bins <>0) then @bo81_bins else @bo82_bins end ,case when (@ebo81_bins <>0) then @ebo81_iva else @ebo82_iva end ,case when (@ebo81_bins <>0) then @bo81_iva else @bo82_iva end from taxasiva where codigo = 8 union all select @mybostamp,codigo,taxa ,case when (@ebo91_bins <>0) then @ebo91_bins else @ebo92_bins end ,case when (@ebo91_bins <>0) then @bo91_bins else @bo92_bins end ,case when (@ebo91_bins <>0) then @ebo91_iva else @ebo92_iva end ,case when (@ebo91_bins <>0) then @bo91_iva else @bo92_iva end from taxasiva where codigo = 9 update bot set ebaseinc = totiva.ebaseinc, baseinc = totiva.baseinc, evalor = totiva.evalor, valor = totiva.valor, usrinis = @userinis, usrdata = convert (date,getdate()), usrhora = convert (time,getdate()) from @totaisiva totiva inner join bot on totiva.bostamp = bot.bostamp and totiva.codigo = bot.codigo insert into bot ( botstamp ,bostamp ,codigo ,taxa ,ebaseinc ,baseinc ,evalor ,valor ,ousrinis ,ousrdata ,ousrhora ,usrinis ,usrdata ,usrhora ) select ( left(@userinis,3) + 'tt' + left(newid(),5) + right(newid(),5) + left(newid(),5) + right(newid(),5)) stamp ,@mybostamp stampbo ,totiva.codigo ,totiva.taxa ,totiva.ebaseinc ,totiva.baseinc ,totiva.evalor ,totiva.valor ,@userinis ,convert (date,getdate()) ,convert (time,getdate()) ,@userinis ,convert (date,getdate()) ,convert (time,getdate()) from @totaisiva totiva left join bot on totiva.bostamp = bot.bostamp and totiva.codigo = bot.codigo where bot.botstamp is null -- atualiza os campo bi.series e bi.series2, caso tenha equipamentos update bi set series = s1, series2=s2 from bi inner join ( select distinct bistamp,ser.s1, ser.s2 from boma cross apply (select stuff ( ( select ',' + rtrim(serie) from boma myboma where myboma.bistamp = boma.bistamp order by serie for xml path('') ), 1, 1, '' ) s1 , stuff ( ( select ',' + rtrim(serie2) from boma myboma where myboma.bistamp = boma.bistamp order by serie for xml path('') ), 1, 1, '' ) s2 ) ser where boma.bostamp = @mybostamp ) myboma on bi.bistamp = myboma.bistamp where bi.bostamp = @mybostamp 
20240902@103730.7659 p5kdq0rnp581134l2ouol3k72l Query : use flama_phc
20240902@103730.7663 p5kdq0rnp581134l2ouol3k72l Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@103730.7719 p5kdq0rnp581134l2ouol3k72l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1751';
20240902@103730.7753 p5kdq0rnp581134l2ouol3k72l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1751';
20240902@111913.2911 48j77fpmud66evbtp865sfui9g Query : use flama_phc
20240902@111913.2942 48j77fpmud66evbtp865sfui9g Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@111913.3393 48j77fpmud66evbtp865sfui9g Query : use flama_phc
20240902@111913.3398 48j77fpmud66evbtp865sfui9g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@113613.4868 krh9tsjtllfsb47ohlh7u7694b Query : use flama_phc
20240902@113613.4909 krh9tsjtllfsb47ohlh7u7694b Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@113613.5040 krh9tsjtllfsb47ohlh7u7694b Query : use flama_phc
20240902@113613.5043 krh9tsjtllfsb47ohlh7u7694b Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@121912.9465 h87e8vdkc80o0f5iqtjm45528e Query : use flama_phc
20240902@121912.9470 h87e8vdkc80o0f5iqtjm45528e Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@121912.9651 h87e8vdkc80o0f5iqtjm45528e Query : use flama_phc
20240902@121912.9656 h87e8vdkc80o0f5iqtjm45528e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@123612.7621 iqj2ia8m5065016qrejbr3naq4 Query : use flama_phc
20240902@123612.7627 iqj2ia8m5065016qrejbr3naq4 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@123612.7723 iqj2ia8m5065016qrejbr3naq4 Query : use flama_phc
20240902@123612.7727 iqj2ia8m5065016qrejbr3naq4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@131911.1160 ubmq39e7nk2hoo4h3hfm73egc9 Query : use flama_phc
20240902@131911.1167 ubmq39e7nk2hoo4h3hfm73egc9 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@131911.1277 ubmq39e7nk2hoo4h3hfm73egc9 Query : use flama_phc
20240902@131911.1281 ubmq39e7nk2hoo4h3hfm73egc9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@133611.1748 ub9l32bkt85nlasvirr8klgj16 Query : use flama_phc
20240902@133611.1754 ub9l32bkt85nlasvirr8klgj16 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@133611.1855 ub9l32bkt85nlasvirr8klgj16 Query : use flama_phc
20240902@133611.1859 ub9l32bkt85nlasvirr8klgj16 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@141915.1160 46o8c1ds1r71bodv8g142cb90d Query : use flama_phc
20240902@141915.1165 46o8c1ds1r71bodv8g142cb90d Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@141915.1256 46o8c1ds1r71bodv8g142cb90d Query : use flama_phc
20240902@141915.1259 46o8c1ds1r71bodv8g142cb90d Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@143614.9069 lnqa7v13keepr3fbqvlmui1a6h Query : use flama_phc
20240902@143614.9075 lnqa7v13keepr3fbqvlmui1a6h Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@143614.9214 lnqa7v13keepr3fbqvlmui1a6h Query : use flama_phc
20240902@143614.9217 lnqa7v13keepr3fbqvlmui1a6h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@151910.4891 5mkvqqjp9g3hdmlocl6imibu0i Query : use flama_phc
20240902@151910.4898 5mkvqqjp9g3hdmlocl6imibu0i Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240902@151910.5010 5mkvqqjp9g3hdmlocl6imibu0i Query : use flama_phc
20240902@151910.5015 5mkvqqjp9g3hdmlocl6imibu0i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240902@152448.8488 jidlalr6e30grmg56pk4ugi589 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240902@152448.8521 jidlalr6e30grmg56pk4ugi589 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240902@152448.8721 jidlalr6e30grmg56pk4ugi589 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1752';
20240902@152448.8785 jidlalr6e30grmg56pk4ugi589 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1752';
20240902@152448.8837 jidlalr6e30grmg56pk4ugi589 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1752';
20240902@152448.8863 jidlalr6e30grmg56pk4ugi589 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1752';
20240902@152448.8901 jidlalr6e30grmg56pk4ugi589 Query : use flama_phc
20240902@152448.8904 jidlalr6e30grmg56pk4ugi589 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240902@152448.9020 jidlalr6e30grmg56pk4ugi589 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1642.00.2'
20240902@152448.9145 jidlalr6e30grmg56pk4ugi589 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 = 2400526 and bi.ref ='324.1642.00.2' and bi.lordem =20000
20240902@152448.9496 jidlalr6e30grmg56pk4ugi589 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 = 'cps24051531830,086000002 ' 
20240902@152448.9849 jidlalr6e30grmg56pk4ugi589 Query : use flama_phc
20240902@152448.9853 jidlalr6e30grmg56pk4ugi589 Query : select top 1 1 valor from ts where ts.ndos = 61
20240902@152449.4100 jidlalr6e30grmg56pk4ugi589 Query : use flama_phc
20240902@152449.4400 jidlalr6e30grmg56pk4ugi589 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')
20240902@152449.1470 jidlalr6e30grmg56pk4ugi589 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
20240902@152449.1890 jidlalr6e30grmg56pk4ugi589 Query : use flama_phc
20240902@152449.1930 jidlalr6e30grmg56pk4ugi589 Query : select top 1 ~inactivo valor from fl where no = '202558' and estab = 00 order by inactivo desc
20240902@152449.3240 jidlalr6e30grmg56pk4ugi589 Query : use flama_phc
20240902@152449.3270 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from ts where ndos = 61
20240902@152449.4130 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152449.7570 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 61
20240902@152449.7930 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152449.8110 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 61
20240902@152449.8200 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152449.8360 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 61
20240902@152449.8450 jidlalr6e30grmg56pk4ugi589 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
20240902@152449.8730 jidlalr6e30grmg56pk4ugi589 Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20240902@152449.9020 jidlalr6e30grmg56pk4ugi589 Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20240902@152449.9220 jidlalr6e30grmg56pk4ugi589 Query : use flama_phc
20240902@152449.9300 jidlalr6e30grmg56pk4ugi589 Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='202558' and estab=00
20240902@152449.1043 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152449.1062 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 61
20240902@152449.1078 jidlalr6e30grmg56pk4ugi589 Query : insert into bo3 (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d5c5799366d5cab116',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240902@152449.1084 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152449.1103 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 61
20240902@152449.1116 jidlalr6e30grmg56pk4ugi589 Query : insert into bo2 (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d5c5799366d5cab116','--','bo',7.8664620107444359171 ,1,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240902@152449.1127 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152449.1143 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 61
20240902@152449.1156 jidlalr6e30grmg56pk4ugi589 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 ('aut66d5c5799366d5cab116','guia r. fornecedor','2024-09-02',61,2402427,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240902@152453.3925 jidlalr6e30grmg56pk4ugi589 Query : use flama_phc
20240902@152453.3930 jidlalr6e30grmg56pk4ugi589 Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20240902@152453.3965 jidlalr6e30grmg56pk4ugi589 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1642.00.2'
20240902@152453.4158 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152453.4177 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 61
20240902@152453.4195 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152453.4217 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 61
20240902@152453.4227 jidlalr6e30grmg56pk4ugi589 Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400526200a'
20240902@152453.4246 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152453.4263 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'se' and documentnumber = 0
20240902@152453.4275 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152453.4298 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'se' and documentnumber = 0
20240902@152453.4311 jidlalr6e30grmg56pk4ugi589 Query : insert into se (sestamp,ref, lote, data,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66d5c9324066d5cab568',?,?,'20240902',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut;','aut;')
20240902@152453.4925 jidlalr6e30grmg56pk4ugi589 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240902@152453.4971 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152453.5001 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 61
20240902@152453.5018 jidlalr6e30grmg56pk4ugi589 Query : insert into bi2 (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66d5c6396566d5cab579','aut66d5c5799366d5cab116',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 = 'aut66d5c5799366d5cab116'
20240902@152453.5213 jidlalr6e30grmg56pk4ugi589 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240902@152453.5234 jidlalr6e30grmg56pk4ugi589 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 61
20240902@152453.5257 jidlalr6e30grmg56pk4ugi589 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 'aut66d5c6396566d5cab579',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 3075, 3075*.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 ,26.06,26.06*200.48,26.06,26.06*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,26.06*3075,26.06*3075*200.48 ,.000000,.000000*200.48 ,.000000,.000000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,26.06,26.06*200.48,26.06*3075,26.06*3075*200.48,'cps24051531830,086000002 ',205,205*3075,205,205*3075,?,?,?,4 from bo bo where bo.bostamp = 'aut66d5c5799366d5cab116'
20240902@152501.8351 jidlalr6e30grmg56pk4ugi589 Query : use flama_phc
20240902@152501.8357 jidlalr6e30grmg56pk4ugi589 Query : declare @bostamp varchar(25) = 'aut66d5c5799366d5cab116' ,@bistamp varchar(25) = '' update bi set tecoval = qtt * ecoval ,etecoval = qtt * eecoval ,tecoval2 = qtt * ecoval2 ,etecoval2 = qtt * eecoval2 where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end -- se tiver classificação e não for normal, não calcula nada update bi set ttdeb = 0 ,ettdeb = 0 ,ttmoeda = 0 where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and bi.classifc <> '' and bi.classifc <> 'normal' -- no caso normal com moeda euro if exists ( select 1 from bo cross apply ( select valor moeda from para1 where descricao = 'ge_pteoueuro' ) par where bo.bostamp = @bostamp and bo.moeda = par.moeda ) begin -- sem ecovalores update bi set ettdeb = round(bi.qtt * ((bi.edebito * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100))), 6) ,ttdeb = round(bi.qtt * ((bi.debito * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100))), 6) ,ttmoeda = 0 from bi inner join bo on bi.bostamp = bo.bostamp where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.econotcalc = 1 -- com ecovalores update bi set ettdeb = round(bi.qtt * ( ( bi.edebito + ( iif(p.st_econotdesc = 1, - bi.eecoval2, bi.eecoval) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ) ) ) * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) ), 6) + ( bi.qtt * iif(p.st_econotdesc = 1, (bi.eecoval + bi.eecoval2) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ), 0) ) ,ttdeb = round(bi.qtt * ( ( bi.debito + ( iif(p.st_econotdesc = 1, - bi.ecoval2, bi.ecoval) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ) ) ) * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) ), 6) + ( bi.qtt * iif(p.st_econotdesc = 1, (bi.ecoval + bi.ecoval2) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ), 0) ) ,ttmoeda = 0 from bi inner join bo on bi.bostamp = bo.bostamp left join st on bi.ref = st.ref left join taxasiva tiva on bi.tabiva = tiva.codigo cross apply ( select max(valor) st_econotdesc from ( select case when valor = 's' then 1 else 0 end valor from para1 where descricao = 'st_econotdesc' union all select 0 ) a ) p where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.econotcalc = 0 --acrescenta os descontos em valor, caso existam: update bi set ettdeb = round(bi.ettdeb - (bi.qtt * bi.evaldesc), 2) ,ttdeb = round(bi.ttdeb - (bi.qtt * bi.valdesc), 2) ,ttmoeda = 0 from bi where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.valdesc <> 0 end else begin update bi set ttmoeda = round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2) ,ettdeb = case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ,edebito = case when bi.qtt = 0 then 0 else round(abs(( case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ) / (1 - bi.desconto / 100) / (1 - bi.desc2 / 100) / (1 - bi.desc3 / 100) / (1 - bi.desc4 / 100) / (1 - bi.desc5 / 100) / (1 - bi.desc6 / 100) / bi.qtt), 2) end ,debito = case when bi.qtt = 0 then 0 else round(abs(( case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ) / (1 - bi.desconto / 100) / (1 - bi.desc2 / 100) / (1 - bi.desc3 / 100) / (1 - bi.desc4 / 100) / (1 - bi.desc5 / 100) / (1 - bi.desc6 / 100) / bi.qtt), 2) end * 200.482 from bi inner join bo2 on bi.bostamp = bo2.bo2stamp where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) update bi set ttdeb = round(bi.ttdeb - (bi.qtt * bi.valdesc), 2) ,ettdeb = round(bi.ettdeb - (bi.qtt * bi.evaldesc), 0) ,debito = round(bi.debito - (bi.qtt * bi.valdesc), 2) ,edebito = round(bi.edebito - (bi.qtt * bi.evaldesc), 2) where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.valdesc <> 0 end 
