20241028@172041.6335 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172041.6364 8vh06lv3et1rkin4veurs457us Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc28883671fc7e999',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',48.000 ,'aut671fc99215671fc7e90f' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241028@172041.6631 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.6648 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172041.6671 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.6686 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172041.6694 8vh06lv3et1rkin4veurs457us Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172041.6705 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.6719 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172041.6730 8vh06lv3et1rkin4veurs457us Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc84583671fc7e9a3','aut671fc99215671fc7e90f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172041.6734 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.6748 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172041.6775 8vh06lv3et1rkin4veurs457us Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671fc84583671fc7e9a3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut671fc99215671fc7e90f' ,0,0 ,2,23.00,110000,?,?,?)
20241028@172041.7008 8vh06lv3et1rkin4veurs457us Query : use flama_phc
20241028@172041.7011 8vh06lv3et1rkin4veurs457us Query : select st.usalote valor from st where st.ref = '324.1416.00.1'
20241028@172041.7040 8vh06lv3et1rkin4veurs457us 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.1416.00.1'
20241028@172041.7053 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.7068 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172041.7092 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.7106 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172041.7114 8vh06lv3et1rkin4veurs457us Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172041.7126 8vh06lv3et1rkin4veurs457us Query : select sestamp valor from se where ref ='324.1416.00.1' and lote = 'r2400079200a'
20241028@172041.7138 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.7152 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172041.7164 8vh06lv3et1rkin4veurs457us Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc69468671fc7e9ae','aut671fc99215671fc7e90f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172041.7168 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.7183 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172041.7209 8vh06lv3et1rkin4veurs457us Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc69468671fc7e9ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',48.000 ,'aut671fc99215671fc7e90f' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241028@172041.7901 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.8606 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172041.8634 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.8649 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172041.8657 8vh06lv3et1rkin4veurs457us Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172041.8669 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.8685 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172041.8696 8vh06lv3et1rkin4veurs457us Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc33555671fc7e9d3','aut671fc99215671fc7e90f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172041.8701 8vh06lv3et1rkin4veurs457us Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172041.8715 8vh06lv3et1rkin4veurs457us Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172041.8741 8vh06lv3et1rkin4veurs457us Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671fc33555671fc7e9d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut671fc99215671fc7e90f' ,0,0 ,2,23.00,140000,?,?,?)
20241028@172041.8991 8vh06lv3et1rkin4veurs457us Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut671fc99215671fc7e90f','2407008','wait',39,'adm09112754980.682000002')
20241028@172041.9117 8vh06lv3et1rkin4veurs457us Query : use flama_phc
20241028@172041.9121 8vh06lv3et1rkin4veurs457us Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241028@172041.9153 8vh06lv3et1rkin4veurs457us Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2945';
20241028@172041.9190 8vh06lv3et1rkin4veurs457us Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2945';
20241028@172041.9238 8vh06lv3et1rkin4veurs457us Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2945';
20241028@172041.9264 8vh06lv3et1rkin4veurs457us Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2945';
20241028@172041.9784 2npk2k4ugr6u5epfejnuflk312 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241028@172041.9796 2npk2k4ugr6u5epfejnuflk312 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241028@172041.9852 2npk2k4ugr6u5epfejnuflk312 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2946';
20241028@172041.9923 2npk2k4ugr6u5epfejnuflk312 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2946';
20241028@172041.9986 2npk2k4ugr6u5epfejnuflk312 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2946';
20241028@172042.1500 2npk2k4ugr6u5epfejnuflk312 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2946';
20241028@172042.7100 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.7400 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241028@172042.1370 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.1400 2npk2k4ugr6u5epfejnuflk312 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241028@172042.1860 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2041.00.1'
20241028@172042.3400 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407009 and bi.ref ='324.2041.00.1' and bi.lordem =1
20241028@172042.6530 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.6560 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241028@172042.7050 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.7080 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 1 valor from td where td.ndoc = 39
20241028@172042.7370 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.7400 2npk2k4ugr6u5epfejnuflk312 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')
20241028@172042.7690 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241028@172042.8030 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.8050 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241028@172042.8330 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.8360 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241028@172042.8680 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.8710 2npk2k4ugr6u5epfejnuflk312 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241028@172042.9090 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.9110 2npk2k4ugr6u5epfejnuflk312 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241028@172042.9540 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.9570 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from td where ndoc = 39
20241028@172042.9690 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241028@172042.9830 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.1000 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241028@172042.1018 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.1033 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241028@172042.1061 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.1075 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241028@172042.1094 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241028@172042.1155 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241028@172042.1167 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.1182 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241028@172042.1198 2npk2k4ugr6u5epfejnuflk312 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut671fc48989671fc7ea1a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241028@172042.1364 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.1380 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241028@172042.1414 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241028@172042.1426 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241028@172042.1438 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241028@172042.1450 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241028@172042.1461 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241028@172042.1472 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241028@172042.1484 2npk2k4ugr6u5epfejnuflk312 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut671fc48989671fc7ea1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241028@172042.1719 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 fno valor from wsftdata order by fno desc
20241028@172042.1743 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.1758 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241028@172042.1780 2npk2k4ugr6u5epfejnuflk312 Query : select 'normal' from dummy
20241028@172042.1794 2npk2k4ugr6u5epfejnuflk312 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut671fc48989671fc7ea1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1524,100810,0,'2024-10-28',39,'euro',0,0,2024 ,?,?)
20241028@172042.2340 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.2381 2npk2k4ugr6u5epfejnuflk312 Query : select st.usalote valor from st where st.ref = '324.2041.00.1'
20241028@172042.3205 2npk2k4ugr6u5epfejnuflk312 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.2041.00.1'
20241028@172042.3351 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.3366 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172042.3393 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.3407 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172042.3415 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172042.3427 2npk2k4ugr6u5epfejnuflk312 Query : select sestamp valor from se where ref ='324.2041.00.1' and lote = 'r2100232100a'
20241028@172042.3454 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.3467 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172042.3479 2npk2k4ugr6u5epfejnuflk312 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc39838671fc7ea54','aut671fc48989671fc7ea1a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172042.3483 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.3497 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172042.3523 2npk2k4ugr6u5epfejnuflk312 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc39838671fc7ea54',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',108.000 ,'aut671fc48989671fc7ea1a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241028@172042.3833 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.3850 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172042.3876 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.3891 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172042.3899 2npk2k4ugr6u5epfejnuflk312 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172042.3914 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.3929 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172042.3941 2npk2k4ugr6u5epfejnuflk312 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc43019671fc7ea5f','aut671fc48989671fc7ea1a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172042.3945 2npk2k4ugr6u5epfejnuflk312 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.3960 2npk2k4ugr6u5epfejnuflk312 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172042.3989 2npk2k4ugr6u5epfejnuflk312 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671fc43019671fc7ea5f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut671fc48989671fc7ea1a' ,0,0 ,2,23.00,20000,?,?,?)
20241028@172042.4234 2npk2k4ugr6u5epfejnuflk312 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut671fc48989671fc7ea1a','2407009','wait',39,'adm09112754980.682000002')
20241028@172042.4305 2npk2k4ugr6u5epfejnuflk312 Query : use flama_phc
20241028@172042.4308 2npk2k4ugr6u5epfejnuflk312 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241028@172042.4341 2npk2k4ugr6u5epfejnuflk312 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2946';
20241028@172042.4376 2npk2k4ugr6u5epfejnuflk312 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2946';
20241028@172042.4423 2npk2k4ugr6u5epfejnuflk312 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2946';
20241028@172042.4450 2npk2k4ugr6u5epfejnuflk312 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2946';
20241028@172042.4992 710kq3niruad0hvqgr7taqrds5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241028@172042.5004 710kq3niruad0hvqgr7taqrds5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241028@172042.5063 710kq3niruad0hvqgr7taqrds5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2947';
20241028@172042.5126 710kq3niruad0hvqgr7taqrds5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2947';
20241028@172042.5187 710kq3niruad0hvqgr7taqrds5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2947';
20241028@172042.5215 710kq3niruad0hvqgr7taqrds5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2947';
20241028@172042.5264 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.5267 710kq3niruad0hvqgr7taqrds5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241028@172042.5335 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.5338 710kq3niruad0hvqgr7taqrds5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241028@172042.5380 710kq3niruad0hvqgr7taqrds5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20241028@172042.5518 710kq3niruad0hvqgr7taqrds5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407010 and bi.ref ='324.945.00.01' and bi.lordem =1
20241028@172042.5817 710kq3niruad0hvqgr7taqrds5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20241028@172042.5850 710kq3niruad0hvqgr7taqrds5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407010 and bi.ref ='324.945.00.01' and bi.lordem =1
20241028@172042.5866 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.5870 710kq3niruad0hvqgr7taqrds5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241028@172042.5901 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.5904 710kq3niruad0hvqgr7taqrds5 Query : select top 1 1 valor from td where td.ndoc = 39
20241028@172042.5933 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.5936 710kq3niruad0hvqgr7taqrds5 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')
20241028@172042.5964 710kq3niruad0hvqgr7taqrds5 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241028@172042.5998 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.6001 710kq3niruad0hvqgr7taqrds5 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241028@172042.6040 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.6043 710kq3niruad0hvqgr7taqrds5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241028@172042.6074 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.6077 710kq3niruad0hvqgr7taqrds5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241028@172042.6125 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.6128 710kq3niruad0hvqgr7taqrds5 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241028@172042.6176 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.6179 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from td where ndoc = 39
20241028@172042.6191 710kq3niruad0hvqgr7taqrds5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241028@172042.6204 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.6220 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241028@172042.6238 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.6257 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241028@172042.6285 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.6299 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241028@172042.6311 710kq3niruad0hvqgr7taqrds5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241028@172042.6372 710kq3niruad0hvqgr7taqrds5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241028@172042.6385 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.6398 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241028@172042.6416 710kq3niruad0hvqgr7taqrds5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut671fc56818671fc7ea9a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241028@172042.6612 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.6631 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241028@172042.6663 710kq3niruad0hvqgr7taqrds5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241028@172042.6674 710kq3niruad0hvqgr7taqrds5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241028@172042.6685 710kq3niruad0hvqgr7taqrds5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241028@172042.6696 710kq3niruad0hvqgr7taqrds5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241028@172042.6707 710kq3niruad0hvqgr7taqrds5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241028@172042.6718 710kq3niruad0hvqgr7taqrds5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241028@172042.6741 710kq3niruad0hvqgr7taqrds5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut671fc56818671fc7ea9a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241028@172042.6977 710kq3niruad0hvqgr7taqrds5 Query : select top 1 fno valor from wsftdata order by fno desc
20241028@172042.7000 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.7016 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241028@172042.7038 710kq3niruad0hvqgr7taqrds5 Query : select 'normal' from dummy
20241028@172042.7052 710kq3niruad0hvqgr7taqrds5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut671fc56818671fc7ea9a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1525,100810,0,'2024-10-28',39,'euro',0,0,2024 ,?,?)
20241028@172042.7338 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.7341 710kq3niruad0hvqgr7taqrds5 Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20241028@172042.7362 710kq3niruad0hvqgr7taqrds5 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.945.00.01'
20241028@172042.7492 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.7507 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172042.7532 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.7546 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172042.7554 710kq3niruad0hvqgr7taqrds5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172042.7565 710kq3niruad0hvqgr7taqrds5 Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2400091100a'
20241028@172042.7590 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.7604 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172042.7615 710kq3niruad0hvqgr7taqrds5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc83650671fc7eab9','aut671fc56818671fc7ea9a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172042.7619 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.7633 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172042.7664 710kq3niruad0hvqgr7taqrds5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc83650671fc7eab9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',68.000 ,'aut671fc56818671fc7ea9a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241028@172042.7909 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.7912 710kq3niruad0hvqgr7taqrds5 Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20241028@172042.7932 710kq3niruad0hvqgr7taqrds5 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.945.00.01'
20241028@172042.7945 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.7976 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172042.8000 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.8013 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172042.8022 710kq3niruad0hvqgr7taqrds5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172042.8034 710kq3niruad0hvqgr7taqrds5 Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2400091100a'
20241028@172042.8046 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.8060 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172042.8072 710kq3niruad0hvqgr7taqrds5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc42897671fc7eac4','aut671fc56818671fc7ea9a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172042.8076 710kq3niruad0hvqgr7taqrds5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172042.8091 710kq3niruad0hvqgr7taqrds5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172042.8118 710kq3niruad0hvqgr7taqrds5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc42897671fc7eac4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut671fc56818671fc7ea9a' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241028@172042.8361 710kq3niruad0hvqgr7taqrds5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut671fc56818671fc7ea9a','2407010','wait',39,'adm09112754980.682000002')
20241028@172042.8446 710kq3niruad0hvqgr7taqrds5 Query : use flama_phc
20241028@172042.8451 710kq3niruad0hvqgr7taqrds5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241028@172042.8480 710kq3niruad0hvqgr7taqrds5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2947';
20241028@172042.8513 710kq3niruad0hvqgr7taqrds5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2947';
20241028@172042.8562 710kq3niruad0hvqgr7taqrds5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2947';
20241028@172042.8592 710kq3niruad0hvqgr7taqrds5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2947';
20241028@172042.9053 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241028@172042.9066 n6n9c3c84ksc1cpqg15fe5tfef Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241028@172042.9132 n6n9c3c84ksc1cpqg15fe5tfef Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2948';
20241028@172042.9189 n6n9c3c84ksc1cpqg15fe5tfef Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2948';
20241028@172042.9245 n6n9c3c84ksc1cpqg15fe5tfef Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2948';
20241028@172042.9271 n6n9c3c84ksc1cpqg15fe5tfef Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2948';
20241028@172042.9333 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172042.9336 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241028@172042.9400 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172042.9403 n6n9c3c84ksc1cpqg15fe5tfef Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241028@172042.9444 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.729.00.01'
20241028@172042.9578 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407011 and bi.ref ='324.729.00.01' and bi.lordem =1
20241028@172042.9876 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.729.00.01'
20241028@172042.9895 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407011 and bi.ref ='324.729.00.01' and bi.lordem =1
20241028@172042.9912 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.729.00.01'
20241028@172042.9930 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407011 and bi.ref ='324.729.00.01' and bi.lordem =1
20241028@172042.9947 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.729.00.01'
20241028@172042.9966 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407011 and bi.ref ='324.729.00.01' and bi.lordem =1
20241028@172042.9983 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.729.00.01'
20241028@172043.2000 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407011 and bi.ref ='324.729.00.01' and bi.lordem =1
20241028@172043.1900 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.729.00.01'
20241028@172043.3800 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407011 and bi.ref ='324.729.00.01' and bi.lordem =1
20241028@172043.5500 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.729.00.01'
20241028@172043.7300 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407011 and bi.ref ='324.729.00.01' and bi.lordem =1
20241028@172043.8800 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.729.00.01'
20241028@172043.1060 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407011 and bi.ref ='324.729.00.01' and bi.lordem =1
20241028@172043.1220 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.729.00.01'
20241028@172043.1410 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407011 and bi.ref ='324.729.00.01' and bi.lordem =1
20241028@172043.1580 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.1610 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241028@172043.1950 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.1980 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 1 valor from td where td.ndoc = 39
20241028@172043.2280 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.2310 n6n9c3c84ksc1cpqg15fe5tfef 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')
20241028@172043.2580 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241028@172043.2910 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.2940 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241028@172043.3230 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.3260 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241028@172043.3550 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.3580 n6n9c3c84ksc1cpqg15fe5tfef Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241028@172043.4150 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.4180 n6n9c3c84ksc1cpqg15fe5tfef Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241028@172043.4630 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.4650 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from td where ndoc = 39
20241028@172043.4770 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241028@172043.4910 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5060 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241028@172043.5260 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5400 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241028@172043.5680 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5820 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241028@172043.5940 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241028@172043.6550 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241028@172043.6670 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6810 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241028@172043.6960 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241028@172043.8640 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.8790 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241028@172043.9110 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241028@172043.9230 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241028@172043.9340 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241028@172043.9460 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241028@172043.9600 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241028@172043.9720 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241028@172043.9830 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut671fc84594671fc7eb0e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241028@172043.1240 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 fno valor from wsftdata order by fno desc
20241028@172043.1265 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.1280 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241028@172043.1301 n6n9c3c84ksc1cpqg15fe5tfef Query : select 'normal' from dummy
20241028@172043.1316 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut671fc84594671fc7eb0e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1526,100810,0,'2024-10-28',39,'euro',0,0,2024 ,?,?)
20241028@172043.1606 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.1609 n6n9c3c84ksc1cpqg15fe5tfef Query : select st.usalote valor from st where st.ref = '324.729.00.01'
20241028@172043.1638 n6n9c3c84ksc1cpqg15fe5tfef 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.729.00.01'
20241028@172043.1785 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.1800 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.1825 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.1839 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.1847 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.1859 n6n9c3c84ksc1cpqg15fe5tfef Query : select sestamp valor from se where ref ='324.729.00.01' and lote = 'r2400238100a'
20241028@172043.1872 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.1886 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.1897 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc88120671fc7eb2d','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.1902 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.1916 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.1944 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc88120671fc7eb2d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241028@172043.2195 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.2212 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.2238 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.2252 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.2262 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.2274 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.2289 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.2300 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc58734671fc7eb37','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.2304 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.2319 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.2348 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671fc58734671fc7eb37',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,20000,?,?,?)
20241028@172043.2582 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.2585 n6n9c3c84ksc1cpqg15fe5tfef Query : select st.usalote valor from st where st.ref = '324.729.00.01'
20241028@172043.2605 n6n9c3c84ksc1cpqg15fe5tfef 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.729.00.01'
20241028@172043.2627 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.2648 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.2675 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.3579 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.3839 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.3858 n6n9c3c84ksc1cpqg15fe5tfef Query : select sestamp valor from se where ref ='324.729.00.01' and lote = 'r2400238100a'
20241028@172043.3874 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.3902 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.3916 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc83253671fc7eb5e','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.3920 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.3934 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.3961 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc83253671fc7eb5e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',88.000 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241028@172043.4223 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.4238 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.4264 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.4278 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.4286 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.4298 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.4330 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.4346 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc39411671fc7eb68','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.4350 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.4366 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.4392 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671fc39411671fc7eb68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,50000,?,?,?)
20241028@172043.4638 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.4641 n6n9c3c84ksc1cpqg15fe5tfef Query : select st.usalote valor from st where st.ref = '324.729.00.01'
20241028@172043.4660 n6n9c3c84ksc1cpqg15fe5tfef 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.729.00.01'
20241028@172043.4673 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.4688 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.4713 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.4727 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.4735 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.4746 n6n9c3c84ksc1cpqg15fe5tfef Query : select sestamp valor from se where ref ='324.729.00.01' and lote = 'r2400238100a'
20241028@172043.4759 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.4773 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.4784 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc49878671fc7eb74','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.4788 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.4801 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.4833 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc49878671fc7eb74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',88.000 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241028@172043.5097 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5114 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.5141 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5159 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.5167 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.5179 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5193 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.5205 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc59375671fc7eb7e','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.5209 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5223 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.5250 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671fc59375671fc7eb7e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,80000,?,?,?)
20241028@172043.5507 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.5510 n6n9c3c84ksc1cpqg15fe5tfef Query : select st.usalote valor from st where st.ref = '324.729.00.01'
20241028@172043.5528 n6n9c3c84ksc1cpqg15fe5tfef 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.729.00.01'
20241028@172043.5541 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5558 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.5582 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5596 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.5604 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.5616 n6n9c3c84ksc1cpqg15fe5tfef Query : select sestamp valor from se where ref ='324.729.00.01' and lote = 'r2400238100a'
20241028@172043.5628 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5643 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.5654 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc03401671fc7eb89','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.5659 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5672 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.5699 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc03401671fc7eb89',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',88.000 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241028@172043.5953 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.5968 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.5996 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6025 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.6033 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.6045 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6059 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.6070 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc93363671fc7eb93','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.6074 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6088 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.6116 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671fc93363671fc7eb93',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,110000,?,?,?)
20241028@172043.6357 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.6360 n6n9c3c84ksc1cpqg15fe5tfef Query : select st.usalote valor from st where st.ref = '324.729.00.01'
20241028@172043.6379 n6n9c3c84ksc1cpqg15fe5tfef 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.729.00.01'
20241028@172043.6392 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6409 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.6433 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6447 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.6455 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.6466 n6n9c3c84ksc1cpqg15fe5tfef Query : select sestamp valor from se where ref ='324.729.00.01' and lote = 'r2400238100a'
20241028@172043.6478 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6491 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.6503 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc42582671fc7eb9e','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.6507 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6520 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.6546 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc42582671fc7eb9e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',88.000 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241028@172043.6804 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6820 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.6844 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6858 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.6866 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.6878 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6891 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.6902 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc27082671fc7eba7','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.6907 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.6920 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.6947 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671fc27082671fc7eba7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,140000,?,?,?)
20241028@172043.7197 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.7200 n6n9c3c84ksc1cpqg15fe5tfef Query : select st.usalote valor from st where st.ref = '324.729.00.01'
20241028@172043.7220 n6n9c3c84ksc1cpqg15fe5tfef 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.729.00.01'
20241028@172043.7233 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.7249 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.7273 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.7290 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.7299 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.7311 n6n9c3c84ksc1cpqg15fe5tfef Query : select sestamp valor from se where ref ='324.729.00.01' and lote = 'r2400238100a'
20241028@172043.7323 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.7337 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.7348 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc03956671fc7ebb2','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.7352 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.7366 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.7394 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc03956671fc7ebb2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241028@172043.7682 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.7698 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.7725 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.7739 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.7747 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.7765 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.7780 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.7791 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc47661671fc7ebbd','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.7796 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.7812 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.7843 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671fc47661671fc7ebbd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,170000,?,?,?)
20241028@172043.8110 n6n9c3c84ksc1cpqg15fe5tfef Query : use flama_phc
20241028@172043.8115 n6n9c3c84ksc1cpqg15fe5tfef Query : select st.usalote valor from st where st.ref = '324.729.00.01'
20241028@172043.8134 n6n9c3c84ksc1cpqg15fe5tfef 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.729.00.01'
20241028@172043.8148 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.8165 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.8191 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.8206 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.8216 n6n9c3c84ksc1cpqg15fe5tfef Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241028@172043.8228 n6n9c3c84ksc1cpqg15fe5tfef Query : select sestamp valor from se where ref ='324.729.00.01' and lote = 'r2400238100a'
20241028@172043.8241 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.8256 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241028@172043.8269 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671fc41331671fc7ebc9','aut671fc84594671fc7eb0e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241028@172043.8274 n6n9c3c84ksc1cpqg15fe5tfef Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241028@172043.8293 n6n9c3c84ksc1cpqg15fe5tfef Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241028@172043.8336 n6n9c3c84ksc1cpqg15fe5tfef Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671fc41331671fc7ebc9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut671fc84594671fc7eb0e' ,0,0 ,2,23.00,190000,?,?,?,?,?)
