20241204@144220.7636 n8h52b29uigkq6cn731qmriud1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144220.7664 n8h52b29uigkq6cn731qmriud1 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675064653267506a4cb9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut675061462967506a4c7f' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241204@144220.7980 n8h52b29uigkq6cn731qmriud1 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675061462967506a4c7f','2408195','wait',39,'adm09112754980.682000002')
20241204@144220.8047 n8h52b29uigkq6cn731qmriud1 Query : use flama_phc
20241204@144220.8050 n8h52b29uigkq6cn731qmriud1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241204@144220.8079 n8h52b29uigkq6cn731qmriud1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3678';
20241204@144220.8138 n8h52b29uigkq6cn731qmriud1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3678';
20241204@144220.8187 n8h52b29uigkq6cn731qmriud1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3678';
20241204@144220.8221 n8h52b29uigkq6cn731qmriud1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3678';
20241204@144220.8698 6ubbk28hrgh3nm8maqaaq39dkl Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241204@144220.8709 6ubbk28hrgh3nm8maqaaq39dkl Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241204@144220.9946 6ubbk28hrgh3nm8maqaaq39dkl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3679';
20241204@144221.1400 6ubbk28hrgh3nm8maqaaq39dkl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3679';
20241204@144221.7700 6ubbk28hrgh3nm8maqaaq39dkl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3679';
20241204@144221.1100 6ubbk28hrgh3nm8maqaaq39dkl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3679';
20241204@144221.1680 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.1710 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241204@144221.2300 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.2330 6ubbk28hrgh3nm8maqaaq39dkl Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241204@144221.3180 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9005.00.1'
20241204@144221.4660 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408206 and bi.ref ='328.9005.00.1' and bi.lordem =1
20241204@144221.7740 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.7770 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241204@144221.8100 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.8130 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 1 valor from td where td.ndoc = 39
20241204@144221.8420 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.8450 6ubbk28hrgh3nm8maqaaq39dkl 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')
20241204@144221.8730 6ubbk28hrgh3nm8maqaaq39dkl 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
20241204@144221.9060 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.9090 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241204@144221.1030 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.1034 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241204@144221.1067 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.1070 6ubbk28hrgh3nm8maqaaq39dkl Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241204@144221.1144 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.1147 6ubbk28hrgh3nm8maqaaq39dkl Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241204@144221.1192 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.1194 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from td where ndoc = 39
20241204@144221.1206 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241204@144221.1218 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.1234 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241204@144221.1251 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.1265 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241204@144221.1290 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.1304 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241204@144221.1316 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241204@144221.1373 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241204@144221.1385 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.1400 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241204@144221.1414 6ubbk28hrgh3nm8maqaaq39dkl Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675065940067506a4d20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241204@144221.1584 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.1599 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241204@144221.1629 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241204@144221.1641 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241204@144221.1652 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241204@144221.1674 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241204@144221.1685 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241204@144221.1696 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241204@144221.1707 6ubbk28hrgh3nm8maqaaq39dkl Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675065940067506a4d20',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241204@144221.1958 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 fno valor from wsftdata order by fno desc
20241204@144221.1988 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.2004 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241204@144221.2024 6ubbk28hrgh3nm8maqaaq39dkl Query : select 'normal' from dummy
20241204@144221.2038 6ubbk28hrgh3nm8maqaaq39dkl Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675065940067506a4d20',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2194,102943,0,'2024-12-04',39,'euro',0,0,2024 ,?,?)
20241204@144221.2331 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.2335 6ubbk28hrgh3nm8maqaaq39dkl Query : select st.usalote valor from st where st.ref = '328.9005.00.1'
20241204@144221.2356 6ubbk28hrgh3nm8maqaaq39dkl 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.9005.00.1'
20241204@144221.2500 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.2515 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144221.2540 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.2554 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144221.2562 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144221.2573 6ubbk28hrgh3nm8maqaaq39dkl Query : select sestamp valor from se where ref ='328.9005.00.1' and lote = 'r2400092600a'
20241204@144221.2590 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.2604 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144221.2615 6ubbk28hrgh3nm8maqaaq39dkl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675063444267506a4d3f','aut675065940067506a4d20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144221.2619 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.2635 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144221.2665 6ubbk28hrgh3nm8maqaaq39dkl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675063444267506a4d3f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675065940067506a4d20' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241204@144221.2944 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.2958 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144221.2982 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.2997 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144221.3005 6ubbk28hrgh3nm8maqaaq39dkl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144221.3016 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.3030 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144221.3042 6ubbk28hrgh3nm8maqaaq39dkl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675068656267506a4d49','aut675065940067506a4d20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144221.3046 6ubbk28hrgh3nm8maqaaq39dkl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.3060 6ubbk28hrgh3nm8maqaaq39dkl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144221.3088 6ubbk28hrgh3nm8maqaaq39dkl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675068656267506a4d49',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675065940067506a4d20' ,0,0 ,2,23.00,20000,?,?,?)
20241204@144221.3349 6ubbk28hrgh3nm8maqaaq39dkl Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675065940067506a4d20','2408206','wait',39,'adm09112754980.682000002')
20241204@144221.3417 6ubbk28hrgh3nm8maqaaq39dkl Query : use flama_phc
20241204@144221.3420 6ubbk28hrgh3nm8maqaaq39dkl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241204@144221.3448 6ubbk28hrgh3nm8maqaaq39dkl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3679';
20241204@144221.3483 6ubbk28hrgh3nm8maqaaq39dkl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3679';
20241204@144221.3530 6ubbk28hrgh3nm8maqaaq39dkl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3679';
20241204@144221.3558 6ubbk28hrgh3nm8maqaaq39dkl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3679';
20241204@144221.4056 bud9bllks0rn2nf2o3sa85lm9l Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241204@144221.4066 bud9bllks0rn2nf2o3sa85lm9l Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241204@144221.4127 bud9bllks0rn2nf2o3sa85lm9l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3680';
20241204@144221.4183 bud9bllks0rn2nf2o3sa85lm9l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3680';
20241204@144221.4239 bud9bllks0rn2nf2o3sa85lm9l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3680';
20241204@144221.4268 bud9bllks0rn2nf2o3sa85lm9l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3680';
20241204@144221.4320 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.4323 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241204@144221.4381 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.4384 bud9bllks0rn2nf2o3sa85lm9l Query : select no, estab,szadrsdesc from szadrs where u_coddest=16
20241204@144221.4466 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20241204@144221.5820 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408209 and bi.ref ='304.421.00.04' and bi.lordem =2
20241204@144221.6159 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20241204@144221.6315 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408209 and bi.ref ='324.727.00.01' and bi.lordem =3
20241204@144221.6647 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20241204@144221.6873 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408209 and bi.ref ='324.2340.00.1' and bi.lordem =4
20241204@144221.7203 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20241204@144221.7223 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408209 and bi.ref ='324.2340.00.1' and bi.lordem =4
20241204@144221.7239 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20241204@144221.7258 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408209 and bi.ref ='324.2340.00.1' and bi.lordem =5
20241204@144221.7611 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1675.3015'
20241204@144221.7776 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408209 and bi.ref ='325.1675.3015' and bi.lordem =6
20241204@144221.8093 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20241204@144221.8234 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408209 and bi.ref ='324.1832.00.2' and bi.lordem =7
20241204@144221.8537 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20241204@144221.8558 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408209 and bi.ref ='324.1832.00.2' and bi.lordem =8
20241204@144221.8864 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.8867 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241204@144221.8901 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.8903 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 1 valor from td where td.ndoc = 39
20241204@144221.8932 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.8935 bud9bllks0rn2nf2o3sa85lm9l 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')
20241204@144221.8961 bud9bllks0rn2nf2o3sa85lm9l 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
20241204@144221.8994 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.8997 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 ~inactivo valor from cl where no = '100327' and estab = 0 order by inactivo desc
20241204@144221.9113 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.9116 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241204@144221.9146 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.9150 bud9bllks0rn2nf2o3sa85lm9l Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241204@144221.9191 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.9194 bud9bllks0rn2nf2o3sa85lm9l Query : select szadrsstamp valor from szadrs where szadrsdesc='discoteca juvenil, lda.'
20241204@144221.9243 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144221.9246 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from td where ndoc = 39
20241204@144221.9260 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241204@144221.9274 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.9290 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241204@144221.9309 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.9323 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241204@144221.9350 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.9364 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241204@144221.9378 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241204@144221.9433 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241204@144221.9446 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144221.9461 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241204@144221.9475 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241204@144221.9782 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.1900 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241204@144222.2240 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241204@144222.2360 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241204@144222.2470 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241204@144222.2580 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241204@144222.2700 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241204@144222.2810 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241204@144222.2930 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675067194567506a4de4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241204@144222.5640 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 fno valor from wsftdata order by fno desc
20241204@144222.5900 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.6060 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241204@144222.6300 bud9bllks0rn2nf2o3sa85lm9l Query : select 'normal' from dummy
20241204@144222.6450 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675067194567506a4de4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2195,100327,0,'2024-12-04',39,'euro',0,0,2024 ,?,?)
20241204@144222.9820 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144222.9860 bud9bllks0rn2nf2o3sa85lm9l Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20241204@144222.1008 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20241204@144222.1149 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.1164 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.1189 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.1203 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.1212 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.1224 bud9bllks0rn2nf2o3sa85lm9l Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '241670'
20241204@144222.1245 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.1259 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.1270 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675066414767506a4e1e','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.1274 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.1289 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.1316 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675066414767506a4e1e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241204@144222.1574 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.1590 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.1617 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.1631 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.1640 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.1652 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.1666 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.1677 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675062396667506a4e28','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.1681 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.1696 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.1728 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675062396667506a4e28',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,20000,?,?,?)
20241204@144222.1974 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144222.1976 bud9bllks0rn2nf2o3sa85lm9l Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20241204@144222.1998 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20241204@144222.2162 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.2178 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.2203 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.2217 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.2225 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.2237 bud9bllks0rn2nf2o3sa85lm9l Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20241204@144222.2250 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.2265 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.2276 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675068195867506a4e36','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.2279 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.2294 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.2320 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675068195867506a4e36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241204@144222.3513 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.4500 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.4527 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.4543 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.4551 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.4562 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.4576 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.4591 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675060801667506a4e6f','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.4595 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.4609 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.4638 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675060801667506a4e6f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,50000,?,?,?)
20241204@144222.4919 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144222.4922 bud9bllks0rn2nf2o3sa85lm9l Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241204@144222.4943 bud9bllks0rn2nf2o3sa85lm9l 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.2340.00.1'
20241204@144222.5093 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.5109 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.5137 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.5151 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.5159 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.5170 bud9bllks0rn2nf2o3sa85lm9l Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241204@144222.5190 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.5203 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.5214 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675064187367506a4e7e','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.5218 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.5232 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.5262 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675064187367506a4e7e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241204@144222.5513 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144222.5516 bud9bllks0rn2nf2o3sa85lm9l Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241204@144222.5536 bud9bllks0rn2nf2o3sa85lm9l 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.2340.00.1'
20241204@144222.5549 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.5564 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.5590 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.5604 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.5613 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.5625 bud9bllks0rn2nf2o3sa85lm9l Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241204@144222.5638 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.5652 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.5664 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675060660367506a4e89','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.5668 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.5682 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.5713 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675060660367506a4e89',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241204@144222.5986 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144222.5989 bud9bllks0rn2nf2o3sa85lm9l Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241204@144222.6009 bud9bllks0rn2nf2o3sa85lm9l 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.2340.00.1'
20241204@144222.6024 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.6042 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.6068 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.6083 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.6093 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.6105 bud9bllks0rn2nf2o3sa85lm9l Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241204@144222.6118 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.6133 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.6146 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675062987867506a4e95','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.6149 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.6165 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.6197 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675062987867506a4e95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241204@144222.6454 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144222.6457 bud9bllks0rn2nf2o3sa85lm9l Query : select st.usalote valor from st where st.ref = '325.1675.3015'
20241204@144222.6477 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '325.1675.3015'
20241204@144222.6622 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.6640 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.6666 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.6685 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.6697 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.6711 bud9bllks0rn2nf2o3sa85lm9l Query : select sestamp valor from se where ref ='325.1675.3015' and lote = '1303'
20241204@144222.6736 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.6752 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.6766 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675060344567506a4ea4','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.6770 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.6785 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.6814 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675060344567506a4ea4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241204@144222.7065 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144222.7068 bud9bllks0rn2nf2o3sa85lm9l Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241204@144222.7087 bud9bllks0rn2nf2o3sa85lm9l 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.1832.00.2'
20241204@144222.7225 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.7241 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.7266 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.7281 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.7290 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.7302 bud9bllks0rn2nf2o3sa85lm9l Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241204@144222.7315 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.7329 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.7343 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675060221367506a4eb2','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.7347 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.7361 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.7389 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675060221367506a4eb2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',11.000 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241204@144222.7646 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.7661 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.7687 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.7702 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.7710 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.7722 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.7740 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.7754 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675062452367506a4ebc','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.7758 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.7777 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.7805 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675062452367506a4ebc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,120000,?,?,?)
20241204@144222.8057 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144222.8060 bud9bllks0rn2nf2o3sa85lm9l Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241204@144222.8078 bud9bllks0rn2nf2o3sa85lm9l 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.1832.00.2'
20241204@144222.8092 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.8108 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.8133 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.8147 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.8156 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144222.8168 bud9bllks0rn2nf2o3sa85lm9l Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241204@144222.8180 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.8195 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144222.8206 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675064377967506a4ec7','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144222.8210 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.8224 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.8254 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675064377967506a4ec7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20241204@144222.9626 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.9645 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144222.9670 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144222.9704 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.3700 bud9bllks0rn2nf2o3sa85lm9l Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144223.8450 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8640 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.8770 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675066337367506a4f14','aut675067194567506a4de4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144223.8810 bud9bllks0rn2nf2o3sa85lm9l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8960 bud9bllks0rn2nf2o3sa85lm9l Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.9240 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675066337367506a4f14',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675067194567506a4de4' ,0,0 ,2,23.00,150000,?,?,?)
20241204@144223.1203 bud9bllks0rn2nf2o3sa85lm9l Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675067194567506a4de4','2408209','wait',39,'adm09112754980.682000002')
20241204@144223.1274 bud9bllks0rn2nf2o3sa85lm9l Query : use flama_phc
20241204@144223.1276 bud9bllks0rn2nf2o3sa85lm9l Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241204@144223.1305 bud9bllks0rn2nf2o3sa85lm9l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3680';
20241204@144223.1351 bud9bllks0rn2nf2o3sa85lm9l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3680';
20241204@144223.1403 bud9bllks0rn2nf2o3sa85lm9l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3680';
20241204@144223.1447 bud9bllks0rn2nf2o3sa85lm9l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3680';
20241204@144223.1983 7tsjc52n2c0l8088cpkjris6nl Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241204@144223.1994 7tsjc52n2c0l8088cpkjris6nl Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241204@144223.2061 7tsjc52n2c0l8088cpkjris6nl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3681';
20241204@144223.2119 7tsjc52n2c0l8088cpkjris6nl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3681';
20241204@144223.2193 7tsjc52n2c0l8088cpkjris6nl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3681';
20241204@144223.2222 7tsjc52n2c0l8088cpkjris6nl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3681';
20241204@144223.2274 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.2277 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241204@144223.2353 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.2360 7tsjc52n2c0l8088cpkjris6nl Query : select no, estab,szadrsdesc from szadrs where u_coddest=16
20241204@144223.2402 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241204@144223.2558 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408210 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241204@144223.2893 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241204@144223.2935 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408210 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241204@144223.2953 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241204@144223.2972 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408210 and bi.ref ='324.1831.00.2' and bi.lordem =2
20241204@144223.3290 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20241204@144223.3438 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408210 and bi.ref ='304.4320.00.1' and bi.lordem =3
20241204@144223.3780 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20241204@144223.3807 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 2408210 and bi.ref ='304.4320.00.1' and bi.lordem =3
20241204@144223.3826 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.3829 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241204@144223.3864 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.3869 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 1 valor from td where td.ndoc = 39
20241204@144223.3907 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.3910 7tsjc52n2c0l8088cpkjris6nl 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')
20241204@144223.3945 7tsjc52n2c0l8088cpkjris6nl 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
20241204@144223.3980 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.3985 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 ~inactivo valor from cl where no = '100327' and estab = 0 order by inactivo desc
20241204@144223.4025 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.4029 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241204@144223.4065 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.4068 7tsjc52n2c0l8088cpkjris6nl Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241204@144223.4110 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.4112 7tsjc52n2c0l8088cpkjris6nl Query : select szadrsstamp valor from szadrs where szadrsdesc='discoteca juvenil, lda.'
20241204@144223.4171 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.4174 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from td where ndoc = 39
20241204@144223.4192 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241204@144223.4205 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.4221 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241204@144223.4240 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.4266 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241204@144223.4297 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.4318 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241204@144223.4331 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241204@144223.4388 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241204@144223.4402 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.4417 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241204@144223.4432 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675069642167506a4f69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241204@144223.4611 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.4635 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241204@144223.4667 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241204@144223.4683 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241204@144223.4694 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241204@144223.4706 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241204@144223.4736 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241204@144223.4749 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241204@144223.4760 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675069642167506a4f69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241204@144223.5012 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 fno valor from wsftdata order by fno desc
20241204@144223.5038 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.5054 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241204@144223.5076 7tsjc52n2c0l8088cpkjris6nl Query : select 'normal' from dummy
20241204@144223.5093 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675069642167506a4f69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2196,100327,0,'2024-12-04',39,'euro',0,0,2024 ,?,?)
20241204@144223.5383 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.5386 7tsjc52n2c0l8088cpkjris6nl Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241204@144223.5411 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20241204@144223.5551 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.5567 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.5606 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.5630 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.5679 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144223.5707 7tsjc52n2c0l8088cpkjris6nl Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400922200a'
20241204@144223.5720 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.5747 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.5768 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675060575667506a4f8b','aut675069642167506a4f69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144223.5772 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.5789 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.5817 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675060575667506a4f8b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675069642167506a4f69' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241204@144223.6106 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.6124 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.6163 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.6180 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.6190 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144223.6205 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.6220 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.6231 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675061414867506a4f97','aut675069642167506a4f69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144223.6237 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.6256 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.6292 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675061414867506a4f97',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675069642167506a4f69' ,0,0 ,2,23.00,20000,?,?,?)
20241204@144223.6565 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.6568 7tsjc52n2c0l8088cpkjris6nl Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241204@144223.6586 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20241204@144223.6623 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.6645 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.6669 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.6684 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.6693 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144223.6709 7tsjc52n2c0l8088cpkjris6nl Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400922200a'
20241204@144223.6721 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.6736 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.6758 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675068000867506a4fa4','aut675069642167506a4f69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144223.6762 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.6779 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.6807 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675068000867506a4fa4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut675069642167506a4f69' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241204@144223.7287 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.7303 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.7328 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.7342 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.7350 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144223.7367 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.7381 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.7394 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675063015667506a4fb3','aut675069642167506a4f69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144223.7398 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.7412 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.7440 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675063015667506a4fb3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675069642167506a4f69' ,0,0 ,2,23.00,50000,?,?,?)
20241204@144223.7707 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.7710 7tsjc52n2c0l8088cpkjris6nl Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241204@144223.7734 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20241204@144223.7747 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.7762 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.7786 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.7805 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.7819 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144223.7831 7tsjc52n2c0l8088cpkjris6nl Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400922200a'
20241204@144223.7843 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.7858 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.7875 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675060702867506a4fbf','aut675069642167506a4f69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144223.7879 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.7893 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.7923 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675060702867506a4fbf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675069642167506a4f69' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241204@144223.8173 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8188 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.8214 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8227 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.8236 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144223.8248 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8264 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.8275 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675060548067506a4fc9','aut675069642167506a4f69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144223.8278 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8297 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.8323 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675060548067506a4fc9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675069642167506a4f69' ,0,0 ,2,23.00,80000,?,?,?)
20241204@144223.8567 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.8570 7tsjc52n2c0l8088cpkjris6nl Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20241204@144223.8589 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20241204@144223.8734 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8750 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.8774 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8797 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.8805 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144223.8821 7tsjc52n2c0l8088cpkjris6nl Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '241005'
20241204@144223.8842 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8856 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.8872 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675061075167506a4fd7','aut675069642167506a4f69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144223.8876 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.8901 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.8932 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675061075167506a4fd7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut675069642167506a4f69' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241204@144223.9197 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.9200 7tsjc52n2c0l8088cpkjris6nl Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20241204@144223.9220 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20241204@144223.9235 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.9251 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.9275 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.9290 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.9299 7tsjc52n2c0l8088cpkjris6nl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144223.9311 7tsjc52n2c0l8088cpkjris6nl Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '241347'
20241204@144223.9338 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.9352 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144223.9367 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675064227167506a4fe3','aut675069642167506a4f69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144223.9372 7tsjc52n2c0l8088cpkjris6nl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144223.9386 7tsjc52n2c0l8088cpkjris6nl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144223.9414 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675064227167506a4fe3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut675069642167506a4f69' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241204@144223.9683 7tsjc52n2c0l8088cpkjris6nl Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675069642167506a4f69','2408210','wait',39,'adm09112754980.682000002')
20241204@144223.9758 7tsjc52n2c0l8088cpkjris6nl Query : use flama_phc
20241204@144223.9762 7tsjc52n2c0l8088cpkjris6nl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241204@144223.9791 7tsjc52n2c0l8088cpkjris6nl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3681';
20241204@144223.9827 7tsjc52n2c0l8088cpkjris6nl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3681';
20241204@144223.9877 7tsjc52n2c0l8088cpkjris6nl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3681';
20241204@144223.9906 7tsjc52n2c0l8088cpkjris6nl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3681';
20241204@144224.4150 j1ph5dpodkn7occqit0bbgoev1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241204@144224.4260 j1ph5dpodkn7occqit0bbgoev1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241204@144224.4930 j1ph5dpodkn7occqit0bbgoev1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3682';
20241204@144224.5570 j1ph5dpodkn7occqit0bbgoev1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3682';
20241204@144224.6190 j1ph5dpodkn7occqit0bbgoev1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3682';
20241204@144224.6510 j1ph5dpodkn7occqit0bbgoev1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3682';
20241204@144224.7140 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.7170 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241204@144224.7780 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.7810 j1ph5dpodkn7occqit0bbgoev1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241204@144224.8240 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241204@144224.9830 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2326.00.1' and bi.lordem =1
20241204@144224.2958 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241204@144224.3055 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2326.00.1' and bi.lordem =1
20241204@144224.3072 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2317.00.1'
20241204@144224.3229 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2317.00.1' and bi.lordem =2
20241204@144224.3566 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2317.00.1'
20241204@144224.3584 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2317.00.1' and bi.lordem =2
20241204@144224.3600 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2317.00.1'
20241204@144224.3619 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2317.00.1' and bi.lordem =2
20241204@144224.3640 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2318.00.1'
20241204@144224.3796 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2318.00.1' and bi.lordem =3
20241204@144224.4120 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2300.00.1'
20241204@144224.4278 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2300.00.1' and bi.lordem =4
20241204@144224.4606 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2300.00.1'
20241204@144224.4627 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2300.00.1' and bi.lordem =4
20241204@144224.4645 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241204@144224.5063 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2301.00.3' and bi.lordem =5
20241204@144224.5399 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241204@144224.5419 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2301.00.3' and bi.lordem =5
20241204@144224.5436 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241204@144224.5456 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2301.00.3' and bi.lordem =5
20241204@144224.5472 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241204@144224.5491 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2301.00.3' and bi.lordem =5
20241204@144224.5510 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241204@144224.5529 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2301.00.3' and bi.lordem =5
20241204@144224.5547 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241204@144224.5568 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2301.00.3' and bi.lordem =5
20241204@144224.5585 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241204@144224.5606 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2301.00.3' and bi.lordem =5
20241204@144224.5624 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241204@144224.5645 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2301.00.3' and bi.lordem =5
20241204@144224.5663 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241204@144224.5840 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2362.00.1' and bi.lordem =6
20241204@144224.6221 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241204@144224.6241 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2362.00.1' and bi.lordem =6
20241204@144224.6258 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241204@144224.6280 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2362.00.1' and bi.lordem =6
20241204@144224.6296 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2366.00.1'
20241204@144224.6450 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2366.00.1' and bi.lordem =7
20241204@144224.6778 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241204@144224.6938 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2330.00.1' and bi.lordem =8
20241204@144224.7256 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241204@144224.7298 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2330.00.1' and bi.lordem =8
20241204@144224.7315 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241204@144224.7336 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2330.00.1' and bi.lordem =8
20241204@144224.7353 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241204@144224.7373 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2330.00.1' and bi.lordem =8
20241204@144224.7390 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241204@144224.7544 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2335.00.1' and bi.lordem =9
20241204@144224.8443 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241204@144224.8852 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2082 and bo.obrano = 408212. and bi.ref ='324.2335.00.1' and bi.lordem =9
20241204@144224.8874 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.8877 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241204@144224.8911 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.8914 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 1 valor from td where td.ndoc = 39
20241204@144224.8944 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.8946 j1ph5dpodkn7occqit0bbgoev1 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')
20241204@144224.8973 j1ph5dpodkn7occqit0bbgoev1 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
20241204@144224.9008 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.9011 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241204@144224.9039 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.9041 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241204@144224.9070 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.9072 j1ph5dpodkn7occqit0bbgoev1 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241204@144224.9109 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.9112 j1ph5dpodkn7occqit0bbgoev1 Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241204@144224.9156 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144224.9159 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from td where ndoc = 39
20241204@144224.9170 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241204@144224.9184 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144224.9200 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241204@144224.9220 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144224.9234 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241204@144224.9266 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144224.9281 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241204@144224.9293 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241204@144224.9360 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241204@144224.9372 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144224.9387 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241204@144224.9402 j1ph5dpodkn7occqit0bbgoev1 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675065969767506a50e2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241204@144224.9585 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144224.9601 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241204@144224.9633 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241204@144224.9645 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241204@144224.9657 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241204@144224.9668 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241204@144224.9680 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241204@144224.9693 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241204@144224.9704 j1ph5dpodkn7occqit0bbgoev1 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675065969767506a50e2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241204@144224.9963 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 fno valor from wsftdata order by fno desc
20241204@144224.9991 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144225.7000 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241204@144225.2800 j1ph5dpodkn7occqit0bbgoev1 Query : select 'normal' from dummy
20241204@144225.4500 j1ph5dpodkn7occqit0bbgoev1 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675065969767506a50e2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2197,102943,0,'2024-12-04',39,'euro',0,0,2024 ,?,?)
20241204@144225.3360 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144225.3390 j1ph5dpodkn7occqit0bbgoev1 Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241204@144225.3610 j1ph5dpodkn7occqit0bbgoev1 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.2326.00.1'
20241204@144225.5060 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144225.5230 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144225.5480 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144225.5620 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144225.5700 j1ph5dpodkn7occqit0bbgoev1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241204@144225.5810 j1ph5dpodkn7occqit0bbgoev1 Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2300567100a'
20241204@144225.5950 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144225.6090 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241204@144225.6200 j1ph5dpodkn7occqit0bbgoev1 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675062323467506a510e','aut675065969767506a50e2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241204@144225.6240 j1ph5dpodkn7occqit0bbgoev1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241204@144225.6380 j1ph5dpodkn7occqit0bbgoev1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241204@144225.6660 j1ph5dpodkn7occqit0bbgoev1 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675062323467506a510e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',126.000 ,'aut675065969767506a50e2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241204@144225.9300 j1ph5dpodkn7occqit0bbgoev1 Query : use flama_phc
20241204@144225.9330 j1ph5dpodkn7occqit0bbgoev1 Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
