20241204@202429.7979 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241204@202429.7993 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241204@202429.8006 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241204@202429.8018 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241204@202429.8031 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6750b984136750ba7db5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241204@202429.8325 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 fno valor from wsftdata order by fno desc
20241204@202429.8354 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202429.8369 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241204@202429.8392 5irmnj3qgm8ipkkscms99l5v1h Query : select 'normal' from dummy
20241204@202429.8407 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6750b984136750ba7db5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2237,102145,0,'2024-12-04',39,'euro',0,0,2024 ,?,?)
20241204@202429.8737 5irmnj3qgm8ipkkscms99l5v1h Query : use flama_phc
20241204@202429.8741 5irmnj3qgm8ipkkscms99l5v1h Query : select st.usalote valor from st where st.ref = '326.595.00.01'
20241204@202429.8766 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '326.595.00.01'
20241204@202429.8921 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202429.8938 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202429.8965 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202429.8980 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202429.8990 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@202429.9003 5irmnj3qgm8ipkkscms99l5v1h Query : select sestamp valor from se where ref ='326.595.00.01' and lote = 'r2400411200a'
20241204@202429.9036 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202429.9054 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202429.9066 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6750b488866750ba7ddc','aut6750b984136750ba7db5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@202429.9070 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202429.9085 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202429.9117 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6750b488866750ba7ddc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6750b984136750ba7db5' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241204@202429.9421 5irmnj3qgm8ipkkscms99l5v1h Query : use flama_phc
20241204@202429.9426 5irmnj3qgm8ipkkscms99l5v1h Query : select st.usalote valor from st where st.ref = '326.595.00.01'
20241204@202429.9448 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '326.595.00.01'
20241204@202429.9464 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202429.9632 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202429.9690 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202429.9707 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202429.9716 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@202429.9727 5irmnj3qgm8ipkkscms99l5v1h Query : select sestamp valor from se where ref ='326.595.00.01' and lote = 'r2400411200a'
20241204@202429.9740 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202429.9756 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202429.9768 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6750b370956750ba7ded','aut6750b984136750ba7db5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@202429.9773 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202429.9788 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202429.9818 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6750b370956750ba7ded',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6750b984136750ba7db5' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241204@202430.1190 5irmnj3qgm8ipkkscms99l5v1h Query : use flama_phc
20241204@202430.1230 5irmnj3qgm8ipkkscms99l5v1h Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241204@202430.1440 5irmnj3qgm8ipkkscms99l5v1h 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.1834.00.1'
20241204@202430.1590 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.1760 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.2020 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2170 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.2260 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@202430.2410 5irmnj3qgm8ipkkscms99l5v1h Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241204@202430.2550 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2720 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.2830 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6750b648676750ba7e06','aut6750b984136750ba7db5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@202430.2900 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.3060 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.3380 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6750b648676750ba7e06',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6750b984136750ba7db5' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241204@202430.6330 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.6530 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.6820 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.7000 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.7090 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@202430.7230 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.7390 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.7540 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6750b597236750ba7e11','aut6750b984136750ba7db5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@202430.7590 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.7740 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.8100 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6750b597236750ba7e11',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6750b984136750ba7db5' ,0,0 ,2,23.00,40000,?,?,?)
20241204@202430.1105 5irmnj3qgm8ipkkscms99l5v1h Query : use flama_phc
20241204@202430.1108 5irmnj3qgm8ipkkscms99l5v1h Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241204@202430.1130 5irmnj3qgm8ipkkscms99l5v1h 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.1834.00.1'
20241204@202430.1146 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.1166 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.1198 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.1213 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.1224 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@202430.1237 5irmnj3qgm8ipkkscms99l5v1h Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241204@202430.1252 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.1269 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.1285 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6750b810536750ba7e1e','aut6750b984136750ba7db5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@202430.1290 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.1307 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.1339 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6750b810536750ba7e1e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6750b984136750ba7db5' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241204@202430.1658 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.1678 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.1706 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.1721 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.1732 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@202430.1746 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.1763 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.1776 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6750b050856750ba7e2a','aut6750b984136750ba7db5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@202430.1780 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.1796 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.1826 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6750b050856750ba7e2a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6750b984136750ba7db5' ,0,0 ,2,23.00,70000,?,?,?)
20241204@202430.2129 5irmnj3qgm8ipkkscms99l5v1h Query : use flama_phc
20241204@202430.2132 5irmnj3qgm8ipkkscms99l5v1h Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241204@202430.2153 5irmnj3qgm8ipkkscms99l5v1h 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.1834.00.1'
20241204@202430.2169 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2186 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.2217 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2233 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.2242 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@202430.2259 5irmnj3qgm8ipkkscms99l5v1h Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241204@202430.2274 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2290 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.2303 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6750b454466750ba7e37','aut6750b984136750ba7db5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@202430.2308 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2324 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.2355 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6750b454466750ba7e37',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6750b984136750ba7db5' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241204@202430.2694 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2717 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.2749 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2769 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.2779 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@202430.2796 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2814 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.2828 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6750b456276750ba7e44','aut6750b984136750ba7db5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@202430.2833 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.2850 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.2882 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6750b456276750ba7e44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6750b984136750ba7db5' ,0,0 ,2,23.00,100000,?,?,?)
20241204@202430.3194 5irmnj3qgm8ipkkscms99l5v1h Query : use flama_phc
20241204@202430.3198 5irmnj3qgm8ipkkscms99l5v1h Query : select st.usalote valor from st where st.ref = '325.1290.1003'
20241204@202430.3221 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '325.1290.1003'
20241204@202430.3417 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.3435 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.3465 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.3481 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.3495 5irmnj3qgm8ipkkscms99l5v1h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@202430.3508 5irmnj3qgm8ipkkscms99l5v1h Query : select sestamp valor from se where ref ='325.1290.1003' and lote = 'r2400796200a'
20241204@202430.3536 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.3553 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@202430.3565 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6750b649036750ba7e56','aut6750b984136750ba7db5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@202430.3570 5irmnj3qgm8ipkkscms99l5v1h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@202430.3585 5irmnj3qgm8ipkkscms99l5v1h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@202430.3616 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6750b649036750ba7e56',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut6750b984136750ba7db5' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20241204@202430.5192 5irmnj3qgm8ipkkscms99l5v1h Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6750b984136750ba7db5','2408291','wait',39,'adm09112754980.682000002')
20241204@202430.6483 5irmnj3qgm8ipkkscms99l5v1h Query : use flama_phc
20241204@202430.6486 5irmnj3qgm8ipkkscms99l5v1h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241204@202430.6516 5irmnj3qgm8ipkkscms99l5v1h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3723';
20241204@202430.7963 5irmnj3qgm8ipkkscms99l5v1h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3723';
20241204@202430.8246 5irmnj3qgm8ipkkscms99l5v1h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3723';
20241204@202430.8430 5irmnj3qgm8ipkkscms99l5v1h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3723';

20241205@095956.4660 s77574s27p4pg38ps1t4gs4k56 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3724';
20241205@095956.4734 s77574s27p4pg38ps1t4gs4k56 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3724';
20241205@095956.4766 s77574s27p4pg38ps1t4gs4k56 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3724';
20241205@095956.4824 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.4827 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241205@095956.4934 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.4937 s77574s27p4pg38ps1t4gs4k56 Query : select no, estab,szadrsdesc from szadrs where u_coddest=9380
20241205@095956.5042 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20241205@095956.5202 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1407.00.1'
20241205@095956.5343 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1705.00.1'
20241205@095956.5483 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.5486 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241205@095956.5677 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.5680 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 1 valor from td where td.ndoc = 39
20241205@095956.5775 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.5778 s77574s27p4pg38ps1t4gs4k56 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')
20241205@095956.5852 s77574s27p4pg38ps1t4gs4k56 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
20241205@095956.5986 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.5989 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 ~inactivo valor from cl where no = '102947' and estab = 0 order by inactivo desc
20241205@095956.6104 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.6107 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241205@095956.6190 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.6194 s77574s27p4pg38ps1t4gs4k56 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241205@095956.6262 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.6265 s77574s27p4pg38ps1t4gs4k56 Query : select szadrsstamp valor from szadrs where szadrsdesc='andrade & ceu-comercio moveis electrodomesticos lda'
20241205@095956.6310 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.6313 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from td where ndoc = 39
20241205@095956.6393 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241205@095956.6465 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095956.6747 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241205@095956.6824 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095956.6839 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241205@095956.6867 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095956.6881 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241205@095956.6895 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241205@095956.7081 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241205@095956.7316 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095956.7332 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241205@095956.7373 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67517949836751799ca8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241205@095956.7696 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095956.7995 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241205@095956.8034 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241205@095956.8137 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241205@095956.8216 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241205@095956.8309 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241205@095956.8398 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241205@095956.8480 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241205@095956.8553 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67517949836751799ca8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241205@095956.9156 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 fno valor from wsftdata order by fno desc
20241205@095956.9227 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095956.9243 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241205@095956.9270 s77574s27p4pg38ps1t4gs4k56 Query : select 'normal' from dummy
20241205@095956.9315 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67517949836751799ca8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2238,102947,0,'2024-12-05',39,'euro',0,0,2024 ,?,?)
20241205@095956.9884 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095956.9888 s77574s27p4pg38ps1t4gs4k56 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20241205@095957.1030 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.958.00.01'
20241205@095957.2470 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.2640 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@095957.2910 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.3080 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@095957.3180 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@095957.3550 s77574s27p4pg38ps1t4gs4k56 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400704200a'
20241205@095957.4140 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.4290 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@095957.4420 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67517020296751799d0a','aut67517949836751799ca8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@095957.5090 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.5250 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@095957.5560 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut67517020296751799d0a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67517949836751799ca8' ,0,0 ,2,23.00,10000,?,?,?,?)
20241205@095957.9960 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095957.9990 s77574s27p4pg38ps1t4gs4k56 Query : select st.usalote valor from st where st.ref = '324.1407.00.1'
20241205@095957.1020 s77574s27p4pg38ps1t4gs4k56 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.1407.00.1'
20241205@095957.1167 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.1183 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@095957.1210 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.1226 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@095957.1235 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@095957.1248 s77574s27p4pg38ps1t4gs4k56 Query : select sestamp valor from se where ref ='324.1407.00.1' and lote = 'r2100703100a'
20241205@095957.1274 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.1289 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@095957.1302 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67517614936751799d1f','aut67517949836751799ca8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@095957.1306 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.1322 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@095957.1352 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut67517614936751799d1f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67517949836751799ca8' ,0,0 ,2,23.00,20000,?,?,?,?)
20241205@095957.1571 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095957.1574 s77574s27p4pg38ps1t4gs4k56 Query : select st.usalote valor from st where st.ref = '324.1705.00.1'
20241205@095957.1596 s77574s27p4pg38ps1t4gs4k56 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.1705.00.1'
20241205@095957.1773 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.1791 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@095957.1821 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.1838 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@095957.1848 s77574s27p4pg38ps1t4gs4k56 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@095957.1863 s77574s27p4pg38ps1t4gs4k56 Query : select sestamp valor from se where ref ='324.1705.00.1' and lote = 'r2400050500a'
20241205@095957.1884 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.1901 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@095957.1914 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67517350306751799d2e','aut67517949836751799ca8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@095957.1919 s77574s27p4pg38ps1t4gs4k56 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@095957.1938 s77574s27p4pg38ps1t4gs4k56 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@095957.1972 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut67517350306751799d2e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67517949836751799ca8' ,0,0 ,2,23.00,30000,?,?,?,?)
20241205@095957.2433 s77574s27p4pg38ps1t4gs4k56 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67517949836751799ca8','2408251','wait',39,'adm09112754980.682000002')
20241205@095957.2565 s77574s27p4pg38ps1t4gs4k56 Query : use flama_phc
20241205@095957.2568 s77574s27p4pg38ps1t4gs4k56 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241205@095957.2604 s77574s27p4pg38ps1t4gs4k56 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3724';
20241205@095957.2645 s77574s27p4pg38ps1t4gs4k56 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3724';
20241205@095957.2699 s77574s27p4pg38ps1t4gs4k56 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3724';
20241205@095957.2732 s77574s27p4pg38ps1t4gs4k56 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3724';

20241205@113114.4660 p5ufi4c7em1ict1sgujqo7q07a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3725';
20241205@113114.4733 p5ufi4c7em1ict1sgujqo7q07a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3725';
20241205@113114.4766 p5ufi4c7em1ict1sgujqo7q07a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3725';
20241205@113114.4863 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.4866 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241205@113114.4936 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.4980 p5ufi4c7em1ict1sgujqo7q07a Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241205@113114.5077 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241205@113114.5280 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408298 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241205@113114.5702 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20241205@113114.5926 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408298 and bi.ref ='324.948.00.01' and bi.lordem =2
20241205@113114.7277 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20241205@113114.7694 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408298 and bi.ref ='304.4320.00.1' and bi.lordem =3
20241205@113114.8129 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20241205@113114.8330 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408298 and bi.ref ='304.421.00.04' and bi.lordem =4
20241205@113114.9048 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.9091 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241205@113114.9537 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.9541 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 1 valor from td where td.ndoc = 39
20241205@113114.9575 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.9578 p5ufi4c7em1ict1sgujqo7q07a 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')
20241205@113114.9621 p5ufi4c7em1ict1sgujqo7q07a 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
20241205@113114.9666 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.9669 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241205@113114.9784 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.9787 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241205@113114.9825 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.9828 p5ufi4c7em1ict1sgujqo7q07a Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241205@113114.9874 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.9877 p5ufi4c7em1ict1sgujqo7q07a Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241205@113114.9925 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113114.9928 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from td where ndoc = 39
20241205@113114.9948 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241205@113114.9962 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113114.9991 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241205@113115.3700 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.5800 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241205@113115.9900 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.1170 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241205@113115.1330 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241205@113115.1970 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241205@113115.2260 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.2420 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241205@113115.2620 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675180518667518f0303' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241205@113115.5550 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.5730 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241205@113115.1749 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241205@113115.1761 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241205@113115.1773 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241205@113115.1785 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241205@113115.1798 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241205@113115.1809 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241205@113115.1820 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675180518667518f0303',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241205@113115.2449 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 fno valor from wsftdata order by fno desc
20241205@113115.2490 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.2505 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241205@113115.2529 p5ufi4c7em1ict1sgujqo7q07a Query : select 'normal' from dummy
20241205@113115.2560 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675180518667518f0303',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2239,102943,0,'2024-12-05',39,'euro',0,0,2024 ,?,?)
20241205@113115.2945 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113115.2948 p5ufi4c7em1ict1sgujqo7q07a Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241205@113115.2977 p5ufi4c7em1ict1sgujqo7q07a 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.1831.00.2'
20241205@113115.3129 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.3145 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.3170 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.3184 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.3195 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@113115.3213 p5ufi4c7em1ict1sgujqo7q07a Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400922200a'
20241205@113115.3231 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.3246 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.3257 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675185968067518f034e','aut675180518667518f0303' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@113115.3277 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.3292 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.3318 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675185968067518f034e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut675180518667518f0303' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241205@113115.3895 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.3910 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.3934 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.3949 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.3957 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@113115.3969 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.3984 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.3996 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675181054267518f0360','aut675180518667518f0303' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@113115.4000 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.4015 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.4043 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675181054267518f0360',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675180518667518f0303' ,0,0 ,2,23.00,20000,?,?,?)
20241205@113115.4273 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113115.4276 p5ufi4c7em1ict1sgujqo7q07a Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20241205@113115.4295 p5ufi4c7em1ict1sgujqo7q07a 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.948.00.01'
20241205@113115.4433 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.4449 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.4473 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.4488 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.4497 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@113115.4508 p5ufi4c7em1ict1sgujqo7q07a Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2400703100a'
20241205@113115.4521 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.4535 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.4546 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675182537167518f036e','aut675180518667518f0303' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@113115.4550 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.4564 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.4591 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675182537167518f036e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut675180518667518f0303' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241205@113115.4807 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113115.4811 p5ufi4c7em1ict1sgujqo7q07a Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20241205@113115.4830 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20241205@113115.4978 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.4994 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.5020 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.5034 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.5042 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@113115.5055 p5ufi4c7em1ict1sgujqo7q07a Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '241183'
20241205@113115.5079 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.5096 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.5107 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675187042267518f037c','aut675180518667518f0303' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@113115.5111 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.5126 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.5153 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675187042267518f037c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut675180518667518f0303' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241205@113115.5381 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113115.5385 p5ufi4c7em1ict1sgujqo7q07a Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20241205@113115.5405 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20241205@113115.5555 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.5570 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.5595 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.5609 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.5618 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@113115.5629 p5ufi4c7em1ict1sgujqo7q07a Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '241670'
20241205@113115.5648 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.5663 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.5675 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675181272467518f0389','aut675180518667518f0303' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@113115.5680 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.5696 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.5726 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675181272467518f0389',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut675180518667518f0303' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241205@113115.5986 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.6004 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.6031 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.6057 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.6066 p5ufi4c7em1ict1sgujqo7q07a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@113115.6078 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.6094 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.6105 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675181639267518f0394','aut675180518667518f0303' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@113115.6109 p5ufi4c7em1ict1sgujqo7q07a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.6124 p5ufi4c7em1ict1sgujqo7q07a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.6168 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675181639267518f0394',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675180518667518f0303' ,0,0 ,2,23.00,70000,?,?,?)
20241205@113115.6405 p5ufi4c7em1ict1sgujqo7q07a Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675180518667518f0303','2408298','wait',39,'adm09112754980.682000002')
20241205@113115.6482 p5ufi4c7em1ict1sgujqo7q07a Query : use flama_phc
20241205@113115.6485 p5ufi4c7em1ict1sgujqo7q07a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241205@113115.6513 p5ufi4c7em1ict1sgujqo7q07a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3725';
20241205@113115.6549 p5ufi4c7em1ict1sgujqo7q07a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3725';
20241205@113115.6595 p5ufi4c7em1ict1sgujqo7q07a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3725';
20241205@113115.6625 p5ufi4c7em1ict1sgujqo7q07a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3725';
20241205@113115.7239 gvt82kekul55rn89ppefsod31t Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241205@113115.7251 gvt82kekul55rn89ppefsod31t Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241205@113115.7330 gvt82kekul55rn89ppefsod31t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3726';
20241205@113115.7394 gvt82kekul55rn89ppefsod31t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3726';
20241205@113115.7470 gvt82kekul55rn89ppefsod31t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3726';
20241205@113115.7513 gvt82kekul55rn89ppefsod31t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3726';
20241205@113115.7581 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.7584 gvt82kekul55rn89ppefsod31t Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241205@113115.7647 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.7650 gvt82kekul55rn89ppefsod31t Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241205@113115.7694 gvt82kekul55rn89ppefsod31t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1332.00.1'
20241205@113115.7849 gvt82kekul55rn89ppefsod31t Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408299 and bi.ref ='324.1332.00.1' and bi.lordem =1
20241205@113115.8218 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.8221 gvt82kekul55rn89ppefsod31t Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241205@113115.8255 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.8258 gvt82kekul55rn89ppefsod31t Query : select top 1 1 valor from td where td.ndoc = 39
20241205@113115.8287 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.8290 gvt82kekul55rn89ppefsod31t 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')
20241205@113115.8318 gvt82kekul55rn89ppefsod31t 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
20241205@113115.8359 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.8362 gvt82kekul55rn89ppefsod31t Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241205@113115.8392 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.8395 gvt82kekul55rn89ppefsod31t Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241205@113115.8425 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.8428 gvt82kekul55rn89ppefsod31t Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241205@113115.8528 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.8533 gvt82kekul55rn89ppefsod31t Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241205@113115.8585 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.8588 gvt82kekul55rn89ppefsod31t Query : select 1 valor from td where ndoc = 39
20241205@113115.8602 gvt82kekul55rn89ppefsod31t Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241205@113115.8618 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.8637 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241205@113115.8657 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.8673 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241205@113115.8705 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.8721 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241205@113115.8735 gvt82kekul55rn89ppefsod31t Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241205@113115.8791 gvt82kekul55rn89ppefsod31t Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241205@113115.8804 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.8820 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241205@113115.8837 gvt82kekul55rn89ppefsod31t Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675188509267518f03d5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241205@113115.8991 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.9008 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241205@113115.9052 gvt82kekul55rn89ppefsod31t Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241205@113115.9066 gvt82kekul55rn89ppefsod31t Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241205@113115.9078 gvt82kekul55rn89ppefsod31t Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241205@113115.9092 gvt82kekul55rn89ppefsod31t Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241205@113115.9104 gvt82kekul55rn89ppefsod31t Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241205@113115.9116 gvt82kekul55rn89ppefsod31t Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241205@113115.9128 gvt82kekul55rn89ppefsod31t Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675188509267518f03d5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241205@113115.9399 gvt82kekul55rn89ppefsod31t Query : select top 1 fno valor from wsftdata order by fno desc
20241205@113115.9427 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.9444 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241205@113115.9467 gvt82kekul55rn89ppefsod31t Query : select 'normal' from dummy
20241205@113115.9482 gvt82kekul55rn89ppefsod31t Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675188509267518f03d5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2240,102943,0,'2024-12-05',39,'euro',0,0,2024 ,?,?)
20241205@113115.9735 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113115.9739 gvt82kekul55rn89ppefsod31t Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241205@113115.9761 gvt82kekul55rn89ppefsod31t 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.1332.00.1'
20241205@113115.9903 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.9919 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113115.9946 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113115.9961 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113115.9969 gvt82kekul55rn89ppefsod31t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@113115.9981 gvt82kekul55rn89ppefsod31t Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241205@113115.9996 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113116.1100 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241205@113116.2200 gvt82kekul55rn89ppefsod31t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675184210667518f03f4','aut675188509267518f03d5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241205@113116.2600 gvt82kekul55rn89ppefsod31t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@113116.1670 gvt82kekul55rn89ppefsod31t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241205@113116.2020 gvt82kekul55rn89ppefsod31t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675184210667518f03f4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675188509267518f03d5' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241205@113116.4260 gvt82kekul55rn89ppefsod31t Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675188509267518f03d5','2408299','wait',39,'adm09112754980.682000002')
20241205@113116.5190 gvt82kekul55rn89ppefsod31t Query : use flama_phc
20241205@113116.5220 gvt82kekul55rn89ppefsod31t Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241205@113116.5560 gvt82kekul55rn89ppefsod31t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3726';
20241205@113116.6000 gvt82kekul55rn89ppefsod31t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3726';
20241205@113116.6650 gvt82kekul55rn89ppefsod31t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3726';
20241205@113116.6990 gvt82kekul55rn89ppefsod31t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3726';

20241205@133403.1436 fagccbavhdc4rvldeno3orli33 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3727';
20241205@133403.1538 fagccbavhdc4rvldeno3orli33 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3727';
20241205@133403.1583 fagccbavhdc4rvldeno3orli33 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3727';
20241205@133403.1639 fagccbavhdc4rvldeno3orli33 Query : use flama_phc
20241205@133403.1645 fagccbavhdc4rvldeno3orli33 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241205@133403.1775 fagccbavhdc4rvldeno3orli33 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1803.00.1'
20241205@133403.1910 fagccbavhdc4rvldeno3orli33 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 = 2400705 and bi.ref ='324.1803.00.1' and bi.lordem =20000
20241205@133403.3458 fagccbavhdc4rvldeno3orli33 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 = 'cps24060734203,082000002 ' 
20241205@133403.4226 fagccbavhdc4rvldeno3orli33 Query : use flama_phc
20241205@133403.4237 fagccbavhdc4rvldeno3orli33 Query : select top 1 1 valor from ts where ts.ndos = 61
20241205@133403.4545 fagccbavhdc4rvldeno3orli33 Query : use flama_phc
20241205@133403.4682 fagccbavhdc4rvldeno3orli33 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')
20241205@133403.4943 fagccbavhdc4rvldeno3orli33 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
20241205@133403.5186 fagccbavhdc4rvldeno3orli33 Query : use flama_phc
20241205@133403.5193 fagccbavhdc4rvldeno3orli33 Query : select top 1 ~inactivo valor from fl where no = '202241' and estab = 00 order by inactivo desc
20241205@133403.5513 fagccbavhdc4rvldeno3orli33 Query : use flama_phc
20241205@133403.5540 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from ts where ndos = 61
20241205@133403.5770 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133403.6116 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 61
20241205@133403.6200 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133403.6220 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 61
20241205@133403.6231 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133403.6246 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 61
20241205@133403.6256 fagccbavhdc4rvldeno3orli33 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
20241205@133403.6389 fagccbavhdc4rvldeno3orli33 Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20241205@133403.6504 fagccbavhdc4rvldeno3orli33 Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20241205@133403.6523 fagccbavhdc4rvldeno3orli33 Query : use flama_phc
20241205@133403.6529 fagccbavhdc4rvldeno3orli33 Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='202241' and estab=00
20241205@133403.6640 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133403.6657 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 61
20241205@133403.6703 fagccbavhdc4rvldeno3orli33 Query : insert into bo3 (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6751a902696751abcb9f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20241205@133403.6773 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133403.6795 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 61
20241205@133403.6807 fagccbavhdc4rvldeno3orli33 Query : insert into bo2 (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6751a902696751abcb9f','--','bo',7.8750811161583387410 ,1,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20241205@133403.7020 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133403.7039 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 61
20241205@133403.7052 fagccbavhdc4rvldeno3orli33 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 ('aut6751a902696751abcb9f','guia r. fornecedor','2024-12-05',61,2403783,?,?,?,?,?,?,?,?,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')
20241205@133407.6841 fagccbavhdc4rvldeno3orli33 Query : use flama_phc
20241205@133407.6853 fagccbavhdc4rvldeno3orli33 Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20241205@133407.6894 fagccbavhdc4rvldeno3orli33 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.1803.00.1'
20241205@133407.7039 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133407.7055 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 61
20241205@133407.7086 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133407.7108 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 61
20241205@133407.7118 fagccbavhdc4rvldeno3orli33 Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2400705200a'
20241205@133407.7132 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133407.7152 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'se' and documentnumber = 0
20241205@133407.7162 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133407.7183 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'se' and documentnumber = 0
20241205@133407.7195 fagccbavhdc4rvldeno3orli33 Query : insert into se (sestamp,ref, lote, data,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6751a396476751abcfae',?,?,'20241205',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut;','aut;')
20241205@133407.8280 fagccbavhdc4rvldeno3orli33 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241205@133407.8388 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133407.8405 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 61
20241205@133407.8433 fagccbavhdc4rvldeno3orli33 Query : insert into bi2 (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6751a681876751abcfcc','aut6751a902696751abcb9f',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 = 'aut6751a902696751abcb9f'
20241205@133407.8611 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241205@133407.8633 fagccbavhdc4rvldeno3orli33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 61
20241205@133407.8653 fagccbavhdc4rvldeno3orli33 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 'aut6751a681876751abcfcc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 1336, 1336*.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 ,30.82,30.82*200.48,30.82,30.82*200.48 ,0,0,'un ','' ,bo.marcada,1 ,30.82*1336,30.82*1336*200.48 ,32.658000,32.658000*200.48 ,32.658000,32.658000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,30.82,30.82*200.48,30.82*1336,30.82*1336*200.48,'cps24060734203,082000002 ',242.71,242.71*1336,242.71,242.71*1336,?,?,?,4 from bo bo where bo.bostamp = 'aut6751a902696751abcb9f'
20241205@133438.1627 fagccbavhdc4rvldeno3orli33 Query : use flama_phc
20241205@133438.1668 fagccbavhdc4rvldeno3orli33 Query : declare @bostamp varchar(25) = 'aut6751a902696751abcb9f' ,@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 
20241205@133500.9570 fagccbavhdc4rvldeno3orli33 Query : use flama_phc
20241205@133500.9617 fagccbavhdc4rvldeno3orli33 Query : select 1 valor from bo where bo.bostamp = 'aut6751a902696751abcb9f'
20241205@133501.4770 fagccbavhdc4rvldeno3orli33 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) = 'aut6751a902696751abcb9f' 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 
