20250313@181022.7041 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.7062 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181022.7080 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d318571767d31f8ea7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 12.000, 12.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,390000 ,32,32*200.48,32,32*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,32*12.000,32*12.000*200.48 ,10.120000,10.120000*200.48 ,10.120000,10.120000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,32,32*200.48,32*12.000,32*12.000*200.48,'av25031042967,994000039 ',32,32*12.000,32,32*12.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181022.7368 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.7373 ib0rra0bb3uckgo6gnras85cap Query : select st.usalote valor from st where st.ref = '324.1706.00.1'
20250313@181022.7389 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.7392 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.1706.00.1'
20250313@181022.7409 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.7413 ib0rra0bb3uckgo6gnras85cap Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1706.00.1' and sa.armazem = 133 
20250313@181022.7481 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.7484 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.1706.00.1'
20250313@181022.7505 ib0rra0bb3uckgo6gnras85cap 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.1706.00.1'
20250313@181022.7648 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.7666 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181022.7680 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.7695 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181022.7705 ib0rra0bb3uckgo6gnras85cap Query : select sestamp valor from se where ref ='324.1706.00.1' and lote = 'r2400926300a'
20250313@181022.7720 ib0rra0bb3uckgo6gnras85cap Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@181022.7732 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.7748 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181022.7761 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d312759567d31f8ebc','aut67d315582467d31f8a46',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181022.7945 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.7965 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181022.7982 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d312759567d31f8ebc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,400000 ,38.4,38.4*200.48,38.4,38.4*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,38.4*6.000,38.4*6.000*200.48 ,13.115000,13.115000*200.48 ,13.115000,13.115000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,38.4,38.4*200.48,38.4*6.000,38.4*6.000*200.48,'av25031042974,282000040 ',38.4,38.4*6.000,38.4,38.4*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181022.8291 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.8297 ib0rra0bb3uckgo6gnras85cap Query : select st.usalote valor from st where st.ref = '324.644.00.01'
20250313@181022.8313 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.8316 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.644.00.01'
20250313@181022.8334 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.8337 ib0rra0bb3uckgo6gnras85cap Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.644.00.01' and sa.armazem = 133 
20250313@181022.8417 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.8420 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.644.00.01'
20250313@181022.8441 ib0rra0bb3uckgo6gnras85cap Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.644.00.01'
20250313@181022.8597 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.8617 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181022.8630 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.8645 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181022.8654 ib0rra0bb3uckgo6gnras85cap Query : select sestamp valor from se where ref ='324.644.00.01' and lote = 'r2400749200a'
20250313@181022.8669 ib0rra0bb3uckgo6gnras85cap Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@181022.8682 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.8699 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181022.8712 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d312090967d31f8ed3','aut67d315582467d31f8a46',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181022.8882 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.8905 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181022.8923 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d312090967d31f8ed3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 3.000, 3.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,410000 ,76.8,76.8*200.48,76.8,76.8*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,76.8*3.000,76.8*3.000*200.48 ,26.104000,26.104000*200.48 ,26.104000,26.104000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,76.8,76.8*200.48,76.8*3.000,76.8*3.000*200.48,'av25031042988,266000041 ',76.8,76.8*3.000,76.8,76.8*3.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181022.9329 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.9335 ib0rra0bb3uckgo6gnras85cap Query : select st.usalote valor from st where st.ref = '324.648.00.01'
20250313@181022.9353 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.9356 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.648.00.01'
20250313@181022.9374 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.9377 ib0rra0bb3uckgo6gnras85cap Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.648.00.01' and sa.armazem = 133 
20250313@181022.9510 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181022.9513 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.648.00.01'
20250313@181022.9533 ib0rra0bb3uckgo6gnras85cap 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.648.00.01'
20250313@181022.9687 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.9704 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181022.9717 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.9734 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181022.9742 ib0rra0bb3uckgo6gnras85cap Query : select sestamp valor from se where ref ='324.648.00.01' and lote = 'r2400750200a'
20250313@181022.9760 ib0rra0bb3uckgo6gnras85cap Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@181022.9773 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.9790 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181022.9802 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d317625167d31f8eee','aut67d315582467d31f8a46',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181022.9970 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181022.9992 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181023.1100 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d317625167d31f8eee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 3.000, 3.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,420000 ,83.2,83.2*200.48,83.2,83.2*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,83.2*3.000,83.2*3.000*200.48 ,29.112000,29.112000*200.48 ,29.112000,29.112000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,83.2,83.2*200.48,83.2*3.000,83.2*3.000*200.48,'av25031042995,084000042 ',83.2,83.2*3.000,83.2,83.2*3.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181023.3210 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181023.3270 ib0rra0bb3uckgo6gnras85cap Query : select st.usalote valor from st where st.ref = '324.678.00.01'
20250313@181023.3460 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181023.3490 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.678.00.01'
20250313@181023.3690 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181023.3720 ib0rra0bb3uckgo6gnras85cap Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.678.00.01' and sa.armazem = 133 
20250313@181023.4500 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181023.4530 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.678.00.01'
20250313@181023.4750 ib0rra0bb3uckgo6gnras85cap 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.678.00.01'
20250313@181023.6260 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181023.6450 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181023.6590 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181023.6750 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181023.6840 ib0rra0bb3uckgo6gnras85cap Query : select sestamp valor from se where ref ='324.678.00.01' and lote = 'r2400745200a'
20250313@181023.6990 ib0rra0bb3uckgo6gnras85cap Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@181023.7120 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181023.7310 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181023.7430 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d313991067d31f8f11','aut67d315582467d31f8a46',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181023.8980 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181023.9170 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181023.9760 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d313991067d31f8f11',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 3.000, 3.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,430000 ,128,128*200.48,128,128*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,128*3.000,128*3.000*200.48 ,54.481000,54.481000*200.48 ,54.481000,54.481000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,128,128*200.48,128*3.000,128*3.000*200.48,'av25031043001,701000043 ',128,128*3.000,128,128*3.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181023.1274 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181023.1280 ib0rra0bb3uckgo6gnras85cap Query : select st.usalote valor from st where st.ref = '324.719.00.02'
20250313@181023.1300 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181023.1303 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.719.00.02'
20250313@181023.1322 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181023.1325 ib0rra0bb3uckgo6gnras85cap Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.719.00.02' and sa.armazem = 133 
20250313@181023.2822 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181023.2825 ib0rra0bb3uckgo6gnras85cap Query : select st.stns valor from st where st.ref = '324.719.00.02'
20250313@181023.2847 ib0rra0bb3uckgo6gnras85cap Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.719.00.02'
20250313@181023.2994 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181023.3014 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181023.3029 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181023.3045 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181023.3055 ib0rra0bb3uckgo6gnras85cap Query : select sestamp valor from se where ref ='324.719.00.02' and lote = 'r2400693100a'
20250313@181023.3071 ib0rra0bb3uckgo6gnras85cap Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@181023.3085 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181023.3101 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@181023.3116 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d318522067d31f8f4b','aut67d315582467d31f8a46',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181023.3287 ib0rra0bb3uckgo6gnras85cap Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@181023.3306 ib0rra0bb3uckgo6gnras85cap Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@181023.3324 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d318522067d31f8f4b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 8.000, 8.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,440000 ,16,16*200.48,16,16*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,16*8.000,16*8.000*200.48 ,6.370000,6.370000*200.48 ,6.370000,6.370000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,16,16*200.48,16*8.000,16*8.000*200.48,'av25031043014,768000044 ',16,16*8.000,16,16*8.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d315582467d31f8a46'
20250313@181023.3725 ib0rra0bb3uckgo6gnras85cap Query : insert into wsbocreationlog (initialstamp,externalid,creationstatus,documenttypeid,idustamp,transactionid) values ('aut67d315582467d31f8a46','','wait',5,'adm12071144683,938000003','')
20250313@181023.6112 ib0rra0bb3uckgo6gnras85cap Query : use flama_phc
20250313@181023.6118 ib0rra0bb3uckgo6gnras85cap Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250313@181023.6294 ib0rra0bb3uckgo6gnras85cap Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5906';
20250313@181023.6366 ib0rra0bb3uckgo6gnras85cap Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5906';
20250313@181908.6949 j7e2bimm0ufrre1perrhikvft9 Query : use flama_phc
20250313@181908.6955 j7e2bimm0ufrre1perrhikvft9 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250313@181908.7045 j7e2bimm0ufrre1perrhikvft9 Query : use flama_phc
20250313@181908.7048 j7e2bimm0ufrre1perrhikvft9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250313@182513.1414 3i3tlee0676baa8iogkh6lfm43 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182513.1426 3i3tlee0676baa8iogkh6lfm43 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182513.1514 3i3tlee0676baa8iogkh6lfm43 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5907';
20250313@182513.1592 3i3tlee0676baa8iogkh6lfm43 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5907';
20250313@182513.1664 3i3tlee0676baa8iogkh6lfm43 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5907';
20250313@182513.1701 3i3tlee0676baa8iogkh6lfm43 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5907';
20250313@182513.1764 3i3tlee0676baa8iogkh6lfm43 Query : use flama_phc
20250313@182513.1767 3i3tlee0676baa8iogkh6lfm43 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@182513.1834 3i3tlee0676baa8iogkh6lfm43 Query : use flama_phc
20250313@182513.1837 3i3tlee0676baa8iogkh6lfm43 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4537
20250313@182513.1927 3i3tlee0676baa8iogkh6lfm43 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501738 
20250313@182513.2322 3i3tlee0676baa8iogkh6lfm43 Query : use flama_phc
20250313@182513.2325 3i3tlee0676baa8iogkh6lfm43 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@182513.2358 3i3tlee0676baa8iogkh6lfm43 Query : use flama_phc
20250313@182513.2361 3i3tlee0676baa8iogkh6lfm43 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@182513.2423 3i3tlee0676baa8iogkh6lfm43 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@182513.2470 3i3tlee0676baa8iogkh6lfm43 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5907';
20250313@182513.2524 3i3tlee0676baa8iogkh6lfm43 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5907';
20250313@182513.3022 4qdml2o7gm1ave6st2hp0babbv Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182513.3033 4qdml2o7gm1ave6st2hp0babbv Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182513.3105 4qdml2o7gm1ave6st2hp0babbv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5908';
20250313@182513.3177 4qdml2o7gm1ave6st2hp0babbv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5908';
20250313@182513.3249 4qdml2o7gm1ave6st2hp0babbv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5908';
20250313@182513.3291 4qdml2o7gm1ave6st2hp0babbv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5908';
20250313@182513.3364 4qdml2o7gm1ave6st2hp0babbv Query : use flama_phc
20250313@182513.3369 4qdml2o7gm1ave6st2hp0babbv Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@182513.3436 4qdml2o7gm1ave6st2hp0babbv Query : use flama_phc
20250313@182513.3440 4qdml2o7gm1ave6st2hp0babbv Query : select no, estab,szadrsdesc from szadrs where u_coddest=4197
20250313@182513.3524 4qdml2o7gm1ave6st2hp0babbv Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501740 
20250313@182513.4126 4qdml2o7gm1ave6st2hp0babbv Query : use flama_phc
20250313@182513.4131 4qdml2o7gm1ave6st2hp0babbv Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@182513.4169 4qdml2o7gm1ave6st2hp0babbv Query : use flama_phc
20250313@182513.4172 4qdml2o7gm1ave6st2hp0babbv Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@182513.4189 4qdml2o7gm1ave6st2hp0babbv Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@182513.4217 4qdml2o7gm1ave6st2hp0babbv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5908';
20250313@182513.4264 4qdml2o7gm1ave6st2hp0babbv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5908';
20250313@182513.4798 c4tnm3evbk9h0mcuglma2i6jqs Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182513.4809 c4tnm3evbk9h0mcuglma2i6jqs Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182513.4885 c4tnm3evbk9h0mcuglma2i6jqs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5909';
20250313@182513.4996 c4tnm3evbk9h0mcuglma2i6jqs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5909';
20250313@182513.5070 c4tnm3evbk9h0mcuglma2i6jqs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5909';
20250313@182513.5109 c4tnm3evbk9h0mcuglma2i6jqs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5909';
20250313@182513.5179 c4tnm3evbk9h0mcuglma2i6jqs Query : use flama_phc
20250313@182513.5182 c4tnm3evbk9h0mcuglma2i6jqs Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@182513.5249 c4tnm3evbk9h0mcuglma2i6jqs Query : use flama_phc
20250313@182513.5254 c4tnm3evbk9h0mcuglma2i6jqs Query : select no, estab,szadrsdesc from szadrs where u_coddest=210
20250313@182513.5341 c4tnm3evbk9h0mcuglma2i6jqs Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501741 
20250313@182513.5720 c4tnm3evbk9h0mcuglma2i6jqs Query : use flama_phc
20250313@182513.5723 c4tnm3evbk9h0mcuglma2i6jqs Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@182513.5754 c4tnm3evbk9h0mcuglma2i6jqs Query : use flama_phc
20250313@182513.5757 c4tnm3evbk9h0mcuglma2i6jqs Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@182513.5773 c4tnm3evbk9h0mcuglma2i6jqs Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@182513.5799 c4tnm3evbk9h0mcuglma2i6jqs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5909';
20250313@182513.5844 c4tnm3evbk9h0mcuglma2i6jqs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5909';
20250313@182513.6346 6gb3l0q8hk62hceunkqet19pem Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182513.6357 6gb3l0q8hk62hceunkqet19pem Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182513.6432 6gb3l0q8hk62hceunkqet19pem Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5910';
20250313@182513.6503 6gb3l0q8hk62hceunkqet19pem Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5910';
20250313@182513.6573 6gb3l0q8hk62hceunkqet19pem Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5910';
20250313@182513.6613 6gb3l0q8hk62hceunkqet19pem Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5910';
20250313@182513.6702 6gb3l0q8hk62hceunkqet19pem Query : use flama_phc
20250313@182513.6708 6gb3l0q8hk62hceunkqet19pem Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@182513.6787 6gb3l0q8hk62hceunkqet19pem Query : use flama_phc
20250313@182513.6790 6gb3l0q8hk62hceunkqet19pem Query : select no, estab,szadrsdesc from szadrs where u_coddest=2136
20250313@182513.6877 6gb3l0q8hk62hceunkqet19pem Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501744 
20250313@182513.7271 6gb3l0q8hk62hceunkqet19pem Query : use flama_phc
20250313@182513.7274 6gb3l0q8hk62hceunkqet19pem Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@182513.7306 6gb3l0q8hk62hceunkqet19pem Query : use flama_phc
20250313@182513.7309 6gb3l0q8hk62hceunkqet19pem Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@182513.7327 6gb3l0q8hk62hceunkqet19pem Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@182513.7351 6gb3l0q8hk62hceunkqet19pem Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5910';
20250313@182513.7396 6gb3l0q8hk62hceunkqet19pem Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5910';
20250313@182513.7929 khjb8hv26q6nbgil5dk1r1jg7q Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182513.7941 khjb8hv26q6nbgil5dk1r1jg7q Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182513.8013 khjb8hv26q6nbgil5dk1r1jg7q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5911';
20250313@182513.8082 khjb8hv26q6nbgil5dk1r1jg7q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5911';
20250313@182513.8154 khjb8hv26q6nbgil5dk1r1jg7q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5911';
20250313@182513.8191 khjb8hv26q6nbgil5dk1r1jg7q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5911';
20250313@182513.8279 khjb8hv26q6nbgil5dk1r1jg7q Query : use flama_phc
20250313@182513.8282 khjb8hv26q6nbgil5dk1r1jg7q Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@182514.3580 khjb8hv26q6nbgil5dk1r1jg7q Query : use flama_phc
20250313@182514.3620 khjb8hv26q6nbgil5dk1r1jg7q Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20250313@182514.4490 khjb8hv26q6nbgil5dk1r1jg7q Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501747 
20250313@182514.9760 khjb8hv26q6nbgil5dk1r1jg7q Query : use flama_phc
20250313@182514.9790 khjb8hv26q6nbgil5dk1r1jg7q Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@182514.1009 khjb8hv26q6nbgil5dk1r1jg7q Query : use flama_phc
20250313@182514.1013 khjb8hv26q6nbgil5dk1r1jg7q Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@182514.1030 khjb8hv26q6nbgil5dk1r1jg7q Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@182514.1053 khjb8hv26q6nbgil5dk1r1jg7q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5911';
20250313@182514.1100 khjb8hv26q6nbgil5dk1r1jg7q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5911';
20250313@182514.1622 u8ebgu4s2lfkbtqb2mu5ub48rg Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182514.1633 u8ebgu4s2lfkbtqb2mu5ub48rg Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182514.1714 u8ebgu4s2lfkbtqb2mu5ub48rg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5912';
20250313@182514.1786 u8ebgu4s2lfkbtqb2mu5ub48rg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5912';
20250313@182514.1866 u8ebgu4s2lfkbtqb2mu5ub48rg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5912';
20250313@182514.3115 u8ebgu4s2lfkbtqb2mu5ub48rg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5912';
20250313@182514.4061 3cda1chsbd3kh551b70hca3u7c Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182514.4072 3cda1chsbd3kh551b70hca3u7c Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182514.4147 3cda1chsbd3kh551b70hca3u7c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5913';
20250313@182514.4216 3cda1chsbd3kh551b70hca3u7c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5913';
20250313@182514.4293 3cda1chsbd3kh551b70hca3u7c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5913';
20250313@182514.4329 3cda1chsbd3kh551b70hca3u7c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5913';
20250313@182514.4388 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.4391 3cda1chsbd3kh551b70hca3u7c Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@182514.4467 3cda1chsbd3kh551b70hca3u7c Query : select no, estab,szadrsdesc from szadrs where u_coddest=2
20250313@182514.4514 3cda1chsbd3kh551b70hca3u7c Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1647.00.1'
20250313@182514.4623 3cda1chsbd3kh551b70hca3u7c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000637 and bi.ref ='324.1647.00.1' and bi.lordem =10000
20250313@182514.4961 3cda1chsbd3kh551b70hca3u7c 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 = 'az25031261692,453000001 ' 
20250313@182514.5534 3cda1chsbd3kh551b70hca3u7c Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1648.00.1'
20250313@182514.5647 3cda1chsbd3kh551b70hca3u7c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000637 and bi.ref ='324.1648.00.1' and bi.lordem =20000
20250313@182514.5971 3cda1chsbd3kh551b70hca3u7c 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 = 'az25031261707,714000002 ' 
20250313@182514.6374 3cda1chsbd3kh551b70hca3u7c Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1644.00.1'
20250313@182514.6480 3cda1chsbd3kh551b70hca3u7c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000637 and bi.ref ='324.1644.00.1' and bi.lordem =30000
20250313@182514.6800 3cda1chsbd3kh551b70hca3u7c 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 = 'az25031261712,714000003 ' 
20250313@182514.7108 3cda1chsbd3kh551b70hca3u7c Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1645.00.1'
20250313@182514.7213 3cda1chsbd3kh551b70hca3u7c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000637 and bi.ref ='324.1645.00.1' and bi.lordem =40000
20250313@182514.7550 3cda1chsbd3kh551b70hca3u7c 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 = 'az25031261717,083000004 ' 
20250313@182514.7868 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.7871 3cda1chsbd3kh551b70hca3u7c Query : select top 1 1 valor from ts where ts.ndos = 5
20250313@182514.7902 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.7905 3cda1chsbd3kh551b70hca3u7c 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')
20250313@182514.7933 3cda1chsbd3kh551b70hca3u7c Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20250313@182514.7970 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.7973 3cda1chsbd3kh551b70hca3u7c Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20250313@182514.8014 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.8017 3cda1chsbd3kh551b70hca3u7c Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@182514.8061 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.8064 3cda1chsbd3kh551b70hca3u7c Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20250313@182514.8168 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.8171 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from ts where ndos = 5
20250313@182514.8187 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.8204 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20250313@182514.8219 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.8234 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20250313@182514.8244 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.8269 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20250313@182514.8278 3cda1chsbd3kh551b70hca3u7c Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20250313@182514.8294 3cda1chsbd3kh551b70hca3u7c Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250313@182514.8325 3cda1chsbd3kh551b70hca3u7c Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250313@182514.8339 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.8348 3cda1chsbd3kh551b70hca3u7c Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20250313@182514.8366 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.8381 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20250313@182514.8406 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67d320870667d3230acb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250313@182514.8410 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.8424 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20250313@182514.8435 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut67d320870667d3230acb','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20250313','18:55',?,?)
20250313@182514.8617 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.8634 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20250313@182514.8650 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut67d320870667d3230acb','trf entre armazéns a','2025-03-13',5,111,?,?,?,?,?,?,?,?,2025, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20250313@182514.9027 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.9030 3cda1chsbd3kh551b70hca3u7c Query : select st.usalote valor from st where st.ref = '324.1647.00.1'
20250313@182514.9044 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.9048 3cda1chsbd3kh551b70hca3u7c Query : select st.stns valor from st where st.ref = '324.1647.00.1'
20250313@182514.9066 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.9069 3cda1chsbd3kh551b70hca3u7c Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1647.00.1' and sa.armazem = 133 
20250313@182514.9138 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.9141 3cda1chsbd3kh551b70hca3u7c Query : select st.stns valor from st where st.ref = '324.1647.00.1'
20250313@182514.9165 3cda1chsbd3kh551b70hca3u7c 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.1647.00.1'
20250313@182514.9289 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.9306 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182514.9318 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.9332 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182514.9340 3cda1chsbd3kh551b70hca3u7c Query : select sestamp valor from se where ref ='324.1647.00.1' and lote = 'r2401145200a'
20250313@182514.9361 3cda1chsbd3kh551b70hca3u7c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182514.9373 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.9388 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182514.9400 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d323691867d3230ae4','aut67d320870667d3230acb',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d320870667d3230acb'
20250313@182514.9554 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182514.9572 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182514.9590 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d323691867d3230ae4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 20.000, 20.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,10,10*200.48,10,10*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,10*20.000,10*20.000*200.48 ,59.261000,59.261000*200.48 ,59.261000,59.261000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,10,10*200.48,10*20.000,10*20.000*200.48,'az25031261692,453000001 ',10,10*20.000,10,10*20.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d320870667d3230acb'
20250313@182514.9870 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.9874 3cda1chsbd3kh551b70hca3u7c Query : select st.usalote valor from st where st.ref = '324.1648.00.1'
20250313@182514.9888 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.9891 3cda1chsbd3kh551b70hca3u7c Query : select st.stns valor from st where st.ref = '324.1648.00.1'
20250313@182514.9908 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.9911 3cda1chsbd3kh551b70hca3u7c Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1648.00.1' and sa.armazem = 133 
20250313@182514.9980 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182514.9983 3cda1chsbd3kh551b70hca3u7c Query : select st.stns valor from st where st.ref = '324.1648.00.1'
20250313@182515.2000 3cda1chsbd3kh551b70hca3u7c 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.1648.00.1'
20250313@182515.1410 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.1580 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182515.1710 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.1850 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182515.1950 3cda1chsbd3kh551b70hca3u7c Query : select sestamp valor from se where ref ='324.1648.00.1' and lote = 'r2401145300a'
20250313@182515.2160 3cda1chsbd3kh551b70hca3u7c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182515.2310 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.2470 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182515.2610 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d327844167d3230b05','aut67d320870667d3230acb',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d320870667d3230acb'
20250313@182515.4090 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.4280 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182515.4450 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d327844167d3230b05',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 20.000, 20.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,20000 ,10,10*200.48,10,10*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,10*20.000,10*20.000*200.48 ,67.187000,67.187000*200.48 ,67.187000,67.187000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,10,10*200.48,10*20.000,10*20.000*200.48,'az25031261707,714000002 ',10,10*20.000,10,10*20.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d320870667d3230acb'
20250313@182515.7310 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182515.7500 3cda1chsbd3kh551b70hca3u7c Query : select st.usalote valor from st where st.ref = '324.1644.00.1'
20250313@182515.7650 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182515.7680 3cda1chsbd3kh551b70hca3u7c Query : select st.stns valor from st where st.ref = '324.1644.00.1'
20250313@182515.7840 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182515.7870 3cda1chsbd3kh551b70hca3u7c Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1644.00.1' and sa.armazem = 133 
20250313@182515.8690 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182515.8730 3cda1chsbd3kh551b70hca3u7c Query : select st.stns valor from st where st.ref = '324.1644.00.1'
20250313@182515.8940 3cda1chsbd3kh551b70hca3u7c 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.1644.00.1'
20250313@182515.1026 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.1042 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182515.1057 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.1076 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182515.1087 3cda1chsbd3kh551b70hca3u7c Query : select sestamp valor from se where ref ='324.1644.00.1' and lote = 'r2401145100a'
20250313@182515.1101 3cda1chsbd3kh551b70hca3u7c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182515.1115 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.1132 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182515.1149 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d320280467d3230b1b','aut67d320870667d3230acb',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d320870667d3230acb'
20250313@182515.1398 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.1456 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182515.1473 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d320280467d3230b1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 20.000, 20.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,30000 ,10,10*200.48,10,10*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,10*20.000,10*20.000*200.48 ,30.391000,30.391000*200.48 ,30.391000,30.391000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,10,10*200.48,10*20.000,10*20.000*200.48,'az25031261712,714000003 ',10,10*20.000,10,10*20.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d320870667d3230acb'
20250313@182515.2010 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182515.2734 3cda1chsbd3kh551b70hca3u7c Query : select st.usalote valor from st where st.ref = '324.1645.00.1'
20250313@182515.2754 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182515.2757 3cda1chsbd3kh551b70hca3u7c Query : select st.stns valor from st where st.ref = '324.1645.00.1'
20250313@182515.2773 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182515.2776 3cda1chsbd3kh551b70hca3u7c Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1645.00.1' and sa.armazem = 133 
20250313@182515.2874 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182515.2878 3cda1chsbd3kh551b70hca3u7c Query : select st.stns valor from st where st.ref = '324.1645.00.1'
20250313@182515.2909 3cda1chsbd3kh551b70hca3u7c 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.1645.00.1'
20250313@182515.3076 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.3093 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182515.3114 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.3132 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182515.3142 3cda1chsbd3kh551b70hca3u7c Query : select sestamp valor from se where ref ='324.1645.00.1' and lote = 'r2401146100a'
20250313@182515.3164 3cda1chsbd3kh551b70hca3u7c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182515.3177 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.3193 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182515.3206 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d325199767d3230b4d','aut67d320870667d3230acb',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d320870667d3230acb'
20250313@182515.3384 3cda1chsbd3kh551b70hca3u7c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182515.3405 3cda1chsbd3kh551b70hca3u7c Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182515.3422 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d325199767d3230b4d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 20.000, 20.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,40000 ,10,10*200.48,10,10*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,10*20.000,10*20.000*200.48 ,50.080000,50.080000*200.48 ,50.080000,50.080000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,10,10*200.48,10*20.000,10*20.000*200.48,'az25031261717,083000004 ',10,10*20.000,10,10*20.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d320870667d3230acb'
20250313@182515.3738 3cda1chsbd3kh551b70hca3u7c Query : insert into wsbocreationlog (initialstamp,externalid,creationstatus,documenttypeid,idustamp,transactionid) values ('aut67d320870667d3230acb','','wait',5,'adm12071144683,938000003','')
20250313@182515.3815 3cda1chsbd3kh551b70hca3u7c Query : use flama_phc
20250313@182515.3819 3cda1chsbd3kh551b70hca3u7c Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250313@182515.3885 3cda1chsbd3kh551b70hca3u7c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5913';
20250313@182515.3940 3cda1chsbd3kh551b70hca3u7c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5913';
20250313@182515.4614 gknoi9ke0hg6oapbifhj0l6bnv Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182515.4634 gknoi9ke0hg6oapbifhj0l6bnv Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182515.4734 gknoi9ke0hg6oapbifhj0l6bnv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5914';
20250313@182515.4884 gknoi9ke0hg6oapbifhj0l6bnv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5914';
20250313@182515.4984 gknoi9ke0hg6oapbifhj0l6bnv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5914';
20250313@182515.5033 gknoi9ke0hg6oapbifhj0l6bnv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5914';
20250313@182515.5366 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182515.5379 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182515.5474 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5915';
20250313@182515.5796 g56en5hhgdjqm6gl0mkkhi4ef7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5915';
20250313@182515.5974 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5915';
20250313@182515.6032 g56en5hhgdjqm6gl0mkkhi4ef7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5915';
20250313@182515.6104 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182515.6108 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@182515.6169 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2
20250313@182515.6226 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '305.21851.022'
20250313@182515.6352 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000651 and bi.ref ='305.21851.022' and bi.lordem =10000
20250313@182515.6721 g56en5hhgdjqm6gl0mkkhi4ef7 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 = 'az25031357304,314000001 ' 
20250313@182515.7065 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '328.9075.00.1'
20250313@182515.7194 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000651 and bi.ref ='328.9075.00.1' and bi.lordem =20000
20250313@182515.7850 g56en5hhgdjqm6gl0mkkhi4ef7 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 = 'az25031357373,700000002 ' 
20250313@182515.8208 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.966.00.01'
20250313@182515.8339 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000651 and bi.ref ='324.966.00.01' and bi.lordem =30000
20250313@182515.9811 g56en5hhgdjqm6gl0mkkhi4ef7 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 = 'az25031357381,508000003 ' 
20250313@182516.1830 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.966.00.01'
20250313@182516.2050 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000651 and bi.ref ='324.966.00.01' and bi.lordem =30000
20250313@182516.2330 g56en5hhgdjqm6gl0mkkhi4ef7 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 = 'az25031357381,508000003 ' 
20250313@182516.2640 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.2680 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 1 valor from ts where ts.ndos = 5
20250313@182516.3010 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.3050 g56en5hhgdjqm6gl0mkkhi4ef7 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')
20250313@182516.3380 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20250313@182516.3800 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.3840 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20250313@182516.4250 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.4280 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@182516.4700 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.4730 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20250313@182516.5250 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.5280 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from ts where ndos = 5
20250313@182516.5410 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.5600 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20250313@182516.5740 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.5890 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20250313@182516.5980 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.6160 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20250313@182516.6260 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20250313@182516.6470 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250313@182516.6800 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250313@182516.6990 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.7070 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20250313@182516.7290 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.7510 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20250313@182516.7680 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67d326545067d3230c11',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250313@182516.7750 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.8030 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20250313@182516.8200 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut67d326545067d3230c11','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20250313','18:55',?,?)
20250313@182516.1065 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.1086 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20250313@182516.1104 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut67d326545067d3230c11','trf entre armazéns a','2025-03-13',5,112,?,?,?,?,?,?,?,?,2025, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20250313@182516.1530 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.1534 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.usalote valor from st where st.ref = '305.21851.022'
20250313@182516.1555 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.1558 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.stns valor from st where st.ref = '305.21851.022'
20250313@182516.1576 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.1579 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '305.21851.022' and sa.armazem = 133 
20250313@182516.1659 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.1661 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.stns valor from st where st.ref = '305.21851.022'
20250313@182516.1692 g56en5hhgdjqm6gl0mkkhi4ef7 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 = '305.21851.022'
20250313@182516.1856 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.1875 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182516.1889 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.1905 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182516.1915 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select sestamp valor from se where ref ='305.21851.022' and lote = '241926'
20250313@182516.1930 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182516.1946 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.1962 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182516.1975 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d329775867d3230c2f','aut67d326545067d3230c11',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d326545067d3230c11'
20250313@182516.2160 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.2181 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182516.2201 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d329775867d3230c2f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 15.000, 15.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,16,16*200.48,16,16*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,16*15.000,16*15.000*200.48 ,1.514000,1.514000*200.48 ,1.514000,1.514000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,16,16*200.48,16*15.000,16*15.000*200.48,'az25031357304,314000001 ',16,16*15.000,16,16*15.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d326545067d3230c11'
20250313@182516.2728 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.2768 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.usalote valor from st where st.ref = '328.9075.00.1'
20250313@182516.2794 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.2798 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.stns valor from st where st.ref = '328.9075.00.1'
20250313@182516.2817 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.2820 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '328.9075.00.1' and sa.armazem = 133 
20250313@182516.2911 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.2915 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.stns valor from st where st.ref = '328.9075.00.1'
20250313@182516.2938 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9075.00.1'
20250313@182516.3095 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.3115 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182516.3130 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.3148 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182516.3160 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select sestamp valor from se where ref ='328.9075.00.1' and lote = 'r2400212150a'
20250313@182516.3188 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182516.3203 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.3220 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182516.3234 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d320372567d3230c4e','aut67d326545067d3230c11',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d326545067d3230c11'
20250313@182516.3413 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.3438 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182516.3460 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d320372567d3230c4e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,20000 ,160,160*200.48,160,160*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,160*4.000,160*4.000*200.48 ,78.369000,78.369000*200.48 ,78.369000,78.369000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,160,160*200.48,160*4.000,160*4.000*200.48,'az25031357373,700000002 ',160,160*4.000,160,160*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d326545067d3230c11'
20250313@182516.3779 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.3784 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20250313@182516.3802 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.3805 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.stns valor from st where st.ref = '324.966.00.01'
20250313@182516.3824 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.3827 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.966.00.01' and sa.armazem = 133 
20250313@182516.3912 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.3915 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.stns valor from st where st.ref = '324.966.00.01'
20250313@182516.3936 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.966.00.01'
20250313@182516.4267 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.4379 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182516.4439 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.4457 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182516.4467 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2401239200a'
20250313@182516.4482 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182516.4496 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.4512 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182516.4526 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d321083867d3230c6d','aut67d326545067d3230c11',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d326545067d3230c11'
20250313@182516.4824 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.4896 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182516.4914 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d321083867d3230c6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 16.000, 16.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,30000 ,32,32*200.48,32,32*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,32*16.000,32*16.000*200.48 ,11.329000,11.329000*200.48 ,11.329000,11.329000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,32,32*200.48,32*16.000,32*16.000*200.48,'az25031357381,508000003 ',32,32*16.000,32,32*16.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d326545067d3230c11'
20250313@182516.5314 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.5319 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20250313@182516.5337 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.5340 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.stns valor from st where st.ref = '324.966.00.01'
20250313@182516.5359 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.5511 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.966.00.01' and sa.armazem = 133 
20250313@182516.5545 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.5549 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select st.stns valor from st where st.ref = '324.966.00.01'
20250313@182516.5569 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.966.00.01'
20250313@182516.5584 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.5603 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182516.5761 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.5782 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182516.5791 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2401239200a'
20250313@182516.5806 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182516.5819 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.5833 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182516.5847 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d321904667d3230c8e','aut67d326545067d3230c11',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d326545067d3230c11'
20250313@182516.6356 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182516.6627 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182516.6685 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d321904667d3230c8e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,40000 ,32,32*200.48,32,32*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,32*4.000,32*4.000*200.48 ,11.329000,11.329000*200.48 ,11.329000,11.329000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,32,32*200.48,32*4.000,32*4.000*200.48,'az25031357381,508000003 ',32,32*4.000,32,32*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d326545067d3230c11'
20250313@182516.7084 g56en5hhgdjqm6gl0mkkhi4ef7 Query : insert into wsbocreationlog (initialstamp,externalid,creationstatus,documenttypeid,idustamp,transactionid) values ('aut67d326545067d3230c11','','wait',5,'adm12071144683,938000003','')
20250313@182516.7164 g56en5hhgdjqm6gl0mkkhi4ef7 Query : use flama_phc
20250313@182516.7167 g56en5hhgdjqm6gl0mkkhi4ef7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250313@182516.7230 g56en5hhgdjqm6gl0mkkhi4ef7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5915';
20250313@182516.7286 g56en5hhgdjqm6gl0mkkhi4ef7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5915';
20250313@182516.9543 9o5if5qmock4c7j9pli9v5peff Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182516.9587 9o5if5qmock4c7j9pli9v5peff Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182516.9770 9o5if5qmock4c7j9pli9v5peff Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5916';
20250313@182516.9868 9o5if5qmock4c7j9pli9v5peff Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5916';
20250313@182516.9956 9o5if5qmock4c7j9pli9v5peff Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5916';
20250313@182517.2820 9o5if5qmock4c7j9pli9v5peff Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5916';
20250313@182517.9120 vdhmfjnh63n58qvou2eo2an7br Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@182517.9230 vdhmfjnh63n58qvou2eo2an7br Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@182517.1009 vdhmfjnh63n58qvou2eo2an7br Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5917';
20250313@182517.1085 vdhmfjnh63n58qvou2eo2an7br Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5917';
20250313@182517.1161 vdhmfjnh63n58qvou2eo2an7br Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5917';
20250313@182517.1203 vdhmfjnh63n58qvou2eo2an7br Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5917';
20250313@182517.1262 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182517.1266 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@182517.1330 vdhmfjnh63n58qvou2eo2an7br Query : select no, estab,szadrsdesc from szadrs where u_coddest=23
20250313@182517.1430 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4840.00.1'
20250313@182517.1552 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.4840.00.1' and bi.lordem =10000
20250313@182517.1923 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031361794,565000001 ' 
20250313@182517.2245 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1803.00.1'
20250313@182517.2363 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.1803.00.1' and bi.lordem =20000
20250313@182517.2718 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031361837,220000002 ' 
20250313@182517.3054 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1803.00.1'
20250313@182517.3102 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.1803.00.1' and bi.lordem =20000
20250313@182517.3126 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031361837,220000002 ' 
20250313@182517.3153 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1539.00.1'
20250313@182517.3266 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.1539.00.1' and bi.lordem =30000
20250313@182517.3622 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031361880,026000003 ' 
20250313@182517.3960 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1538.00.1'
20250313@182517.4070 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.1538.00.1' and bi.lordem =40000
20250313@182517.4402 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031361893,841000004 ' 
20250313@182517.4737 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1537.00.1'
20250313@182517.4866 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.1537.00.1' and bi.lordem =50000
20250313@182517.5274 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031361913,139000005 ' 
20250313@182517.5634 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.966.00.01'
20250313@182517.5654 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.966.00.01' and bi.lordem =60000
20250313@182517.6246 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031361956,108000006 ' 
20250313@182517.6952 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4911.00.1'
20250313@182517.7306 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.4911.00.1' and bi.lordem =70000
20250313@182517.8065 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031362180,135000007 ' 
20250313@182517.8413 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2237.00.1'
20250313@182517.8534 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.2237.00.1' and bi.lordem =80000
20250313@182518.2760 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031362205,558000008 ' 
20250313@182518.8260 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2237.00.1'
20250313@182518.8480 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000013 and bi.ref ='324.2237.00.1' and bi.lordem =80000
20250313@182518.8760 vdhmfjnh63n58qvou2eo2an7br 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 = 'pll25031362205,558000008 ' 
20250313@182518.9080 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.9110 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 1 valor from ts where ts.ndos = 5
20250313@182518.9440 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.9480 vdhmfjnh63n58qvou2eo2an7br 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')
20250313@182518.9820 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20250313@182518.1019 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.1023 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 ~inactivo valor from fl where no = '100999' and estab = 0 order by inactivo desc
20250313@182518.1163 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.1167 vdhmfjnh63n58qvou2eo2an7br Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@182518.1211 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.1214 vdhmfjnh63n58qvou2eo2an7br Query : select szadrsstamp valor from szadrs where szadrsdesc='flama-fab.louÇas e electrodomesticos,sa'
20250313@182518.1268 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.1271 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from ts where ndos = 5
20250313@182518.1286 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.1306 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20250313@182518.1319 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.1334 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20250313@182518.1343 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.1359 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20250313@182518.1368 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20250313@182518.1384 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250313@182518.1415 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250313@182518.1430 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.1437 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100999' and estab=0
20250313@182518.1557 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.1577 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20250313@182518.1589 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67d329744867d3230e22',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250313@182518.1600 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.1617 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20250313@182518.1628 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut67d329744867d3230e22','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20250313','18:55',?,?)
20250313@182518.1855 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.1879 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20250313@182518.1900 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut67d329744867d3230e22','trf entre armazéns a','2025-03-13',5,113,?,?,?,?,?,?,?,?,2025, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20250313@182518.2308 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.2312 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.4840.00.1'
20250313@182518.2338 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.2342 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.4840.00.1'
20250313@182518.2370 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.2374 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.4840.00.1' and sa.armazem = 133 
20250313@182518.2454 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.2457 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.4840.00.1'
20250313@182518.2482 vdhmfjnh63n58qvou2eo2an7br 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.4840.00.1'
20250313@182518.2639 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.2659 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.2673 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.2689 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.2699 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.4840.00.1' and lote = 'r2400950200a'
20250313@182518.2713 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182518.2726 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.2742 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.2754 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d325140767d3230e42','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.2957 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.2978 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.2994 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d325140767d3230e42',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,79.99,79.99*200.48,79.99,79.99*200.48 ,0,0,'un ','' ,bo.marcada,1 ,79.99*4.000,79.99*4.000*200.48 ,19.550000,19.550000*200.48 ,19.550000,19.550000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,79.99,79.99*200.48,79.99*4.000,79.99*4.000*200.48,'pll25031361794,565000001 ',79.99,79.99*4.000,79.99,79.99*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.3317 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.3322 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20250313@182518.3338 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.3341 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1803.00.1'
20250313@182518.3357 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.3360 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1803.00.1' and sa.armazem = 133 
20250313@182518.3433 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.3436 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1803.00.1'
20250313@182518.3458 vdhmfjnh63n58qvou2eo2an7br 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'
20250313@182518.3610 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.3627 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.3641 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.3656 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.3664 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2400705200a'
20250313@182518.3679 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182518.3691 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.3706 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.3876 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d327966167d3230e5a','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.4124 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.4145 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.4163 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d327966167d3230e5a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,20000 ,94.99,94.99*200.48,94.99,94.99*200.48 ,0,0,'un ','' ,bo.marcada,1 ,94.99*6.000,94.99*6.000*200.48 ,32.849000,32.849000*200.48 ,32.849000,32.849000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,94.99,94.99*200.48,94.99*6.000,94.99*6.000*200.48,'pll25031361837,220000002 ',94.99,94.99*6.000,94.99,94.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.4558 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.4563 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20250313@182518.4578 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.4581 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1803.00.1'
20250313@182518.4597 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.4600 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1803.00.1' and sa.armazem = 133 
20250313@182518.4636 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.4640 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1803.00.1'
20250313@182518.4659 vdhmfjnh63n58qvou2eo2an7br 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'
20250313@182518.4674 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.4691 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.4706 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.4721 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.4730 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2400705200a'
20250313@182518.4744 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182518.4758 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.4774 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.4785 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d326702267d3230e74','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.4976 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.4997 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.5014 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d326702267d3230e74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 2.000, 2.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,30000 ,94.99,94.99*200.48,94.99,94.99*200.48 ,0,0,'un ','' ,bo.marcada,1 ,94.99*2.000,94.99*2.000*200.48 ,32.849000,32.849000*200.48 ,32.849000,32.849000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,94.99,94.99*200.48,94.99*2.000,94.99*2.000*200.48,'pll25031361837,220000002 ',94.99,94.99*2.000,94.99,94.99*2.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.5560 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.5565 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.1539.00.1'
20250313@182518.5581 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.5584 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1539.00.1'
20250313@182518.5600 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.5603 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1539.00.1' and sa.armazem = 133 
20250313@182518.5679 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.5682 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1539.00.1'
20250313@182518.5704 vdhmfjnh63n58qvou2eo2an7br 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.1539.00.1'
20250313@182518.5858 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.5876 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.5891 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.5911 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.5921 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.1539.00.1' and lote = 'r2401467400a'
20250313@182518.5937 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182518.5956 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.5973 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.5987 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d326438767d3230e91','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.6177 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.6201 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.6221 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d326438767d3230e91',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,40000 ,159.99,159.99*200.48,159.99,159.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,159.99*6.000,159.99*6.000*200.48 ,29.730000,29.730000*200.48 ,29.730000,29.730000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,159.99,159.99*200.48,159.99*6.000,159.99*6.000*200.48,'pll25031361880,026000003 ',159.99,159.99*6.000,159.99,159.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.6540 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.6545 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.1538.00.1'
