20240412@080349.3489 deocbfqi0anpen4arqts379jiq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080349.3507 deocbfqi0anpen4arqts379jiq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080349.3534 deocbfqi0anpen4arqts379jiq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080349.3547 deocbfqi0anpen4arqts379jiq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080349.3551 deocbfqi0anpen4arqts379jiq Query : select sestamp valor from se where ref ='324.497.00.01' and lote = 'r2300022100a'
20240412@080349.3560 deocbfqi0anpen4arqts379jiq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080349.3570 deocbfqi0anpen4arqts379jiq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080349.3582 deocbfqi0anpen4arqts379jiq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080349.3628 deocbfqi0anpen4arqts379jiq Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d566556618dcd557',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6618d267506618dcd505' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240412@080349.3943 deocbfqi0anpen4arqts379jiq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080349.3970 deocbfqi0anpen4arqts379jiq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080349.3977 deocbfqi0anpen4arqts379jiq Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d566556618dcd557','aut6618d267506618dcd505' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080349.3983 deocbfqi0anpen4arqts379jiq Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6618d267506618dcd505','2402693','wait',39,'ari17112337378,753000005')
20240412@080349.4023 deocbfqi0anpen4arqts379jiq Query : use flama_phc
20240412@080349.4034 deocbfqi0anpen4arqts379jiq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240412@080349.4049 deocbfqi0anpen4arqts379jiq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1114';
20240412@080349.4090 deocbfqi0anpen4arqts379jiq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1114';
20240412@080349.4109 deocbfqi0anpen4arqts379jiq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1114';
20240412@080349.4140 deocbfqi0anpen4arqts379jiq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1114';
20240412@080349.4933 tlgd25bpvo568pb8sut55pm5a0 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240412@080349.4962 tlgd25bpvo568pb8sut55pm5a0 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240412@080349.5004 tlgd25bpvo568pb8sut55pm5a0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1115';
20240412@080349.5257 tlgd25bpvo568pb8sut55pm5a0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1115';
20240412@080349.5291 tlgd25bpvo568pb8sut55pm5a0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1115';
20240412@080349.5312 tlgd25bpvo568pb8sut55pm5a0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1115';
20240412@080349.5331 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.5335 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240412@080349.5352 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.5355 tlgd25bpvo568pb8sut55pm5a0 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240412@080349.5400 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.719.00.01'
20240412@080349.5602 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402698 and bi.ref ='324.719.00.01' and bi.lordem =1
20240412@080349.6102 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.6106 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240412@080349.6121 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.6125 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 1 valor from td where td.ndoc = 39
20240412@080349.6136 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.6140 tlgd25bpvo568pb8sut55pm5a0 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240412@080349.6151 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240412@080349.6167 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.6171 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240412@080349.6193 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.6196 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240412@080349.6207 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.6210 tlgd25bpvo568pb8sut55pm5a0 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240412@080349.6223 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.6227 tlgd25bpvo568pb8sut55pm5a0 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240412@080349.6239 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.6243 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from td where ndoc = 39
20240412@080349.6253 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240412@080349.6265 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080349.6279 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240412@080349.6296 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080349.6310 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240412@080349.6338 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080349.6352 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240412@080349.6362 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080349.6464 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080349.6477 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080349.6492 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240412@080349.6502 tlgd25bpvo568pb8sut55pm5a0 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6618d370936618dcd59b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240412@080349.6732 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080349.6748 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240412@080349.6779 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240412@080349.6785 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240412@080349.6792 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240412@080349.6797 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240412@080349.6802 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240412@080349.6809 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240412@080349.6814 tlgd25bpvo568pb8sut55pm5a0 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6618d370936618dcd59b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240412@080349.7111 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 fno valor from wsft039data order by fno desc
20240412@080349.7131 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080349.7149 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240412@080349.7170 tlgd25bpvo568pb8sut55pm5a0 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6618d370936618dcd59b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',865,100810,0,'2024-04-12',39,'euro',0,0,2024 ,'20240412','0833',?,?,?,?)
20240412@080349.7549 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.7554 tlgd25bpvo568pb8sut55pm5a0 Query : select st.usalote valor from st where st.ref = '324.719.00.01'
20240412@080349.7570 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.719.00.01'
20240412@080349.7755 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080349.7771 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080349.7803 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080349.7820 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080349.7828 tlgd25bpvo568pb8sut55pm5a0 Query : select sestamp valor from se where ref ='324.719.00.01' and lote = 'r2300383300a'
20240412@080349.7847 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080349.7859 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080349.8038 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080349.8133 tlgd25bpvo568pb8sut55pm5a0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d599186618dcd5bf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut6618d370936618dcd59b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240412@080349.8456 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080349.8474 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080349.8479 tlgd25bpvo568pb8sut55pm5a0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d599186618dcd5bf','aut6618d370936618dcd59b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080349.8485 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080349.8501 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080349.8535 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080349.8549 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080349.8553 tlgd25bpvo568pb8sut55pm5a0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080349.8566 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080349.8581 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080349.8603 tlgd25bpvo568pb8sut55pm5a0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d745516618dcd5d1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d370936618dcd59b' ,0,0 ,2,23.00,20000,?,?,?)
20240412@080349.8909 tlgd25bpvo568pb8sut55pm5a0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080349.8927 tlgd25bpvo568pb8sut55pm5a0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080349.8932 tlgd25bpvo568pb8sut55pm5a0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d745516618dcd5d1','aut6618d370936618dcd59b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080349.8937 tlgd25bpvo568pb8sut55pm5a0 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6618d370936618dcd59b','2402698','wait',39,'ari17112337378,753000005')
20240412@080349.8955 tlgd25bpvo568pb8sut55pm5a0 Query : use flama_phc
20240412@080349.8958 tlgd25bpvo568pb8sut55pm5a0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240412@080349.8969 tlgd25bpvo568pb8sut55pm5a0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1115';
20240412@080349.9039 tlgd25bpvo568pb8sut55pm5a0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1115';
20240412@080349.9268 tlgd25bpvo568pb8sut55pm5a0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1115';
20240412@080349.9291 tlgd25bpvo568pb8sut55pm5a0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1115';
20240412@080349.9697 lfc68fjutkg1293uf3hjcln8ic Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240412@080349.9711 lfc68fjutkg1293uf3hjcln8ic Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240412@080349.9740 lfc68fjutkg1293uf3hjcln8ic Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1116';
20240412@080349.9789 lfc68fjutkg1293uf3hjcln8ic Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1116';
20240412@080349.9810 lfc68fjutkg1293uf3hjcln8ic Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1116';
20240412@080350.1450 lfc68fjutkg1293uf3hjcln8ic Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1116';
20240412@080350.2410 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.2860 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240412@080350.5120 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.5560 lfc68fjutkg1293uf3hjcln8ic Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240412@080350.8180 lfc68fjutkg1293uf3hjcln8ic 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'
20240412@080350.1579 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402699 and bi.ref ='324.727.00.01' and bi.lordem =1
20240412@080350.2417 lfc68fjutkg1293uf3hjcln8ic 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'
20240412@080350.2734 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402699 and bi.ref ='324.727.00.01' and bi.lordem =1
20240412@080350.2817 lfc68fjutkg1293uf3hjcln8ic 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'
20240412@080350.3027 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402699 and bi.ref ='324.727.00.01' and bi.lordem =1
20240412@080350.3047 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.3050 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240412@080350.3081 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.3084 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 1 valor from td where td.ndoc = 39
20240412@080350.3320 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.3324 lfc68fjutkg1293uf3hjcln8ic Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240412@080350.3357 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240412@080350.3389 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.3431 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240412@080350.3582 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.3586 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240412@080350.3602 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.3605 lfc68fjutkg1293uf3hjcln8ic Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240412@080350.3777 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.3819 lfc68fjutkg1293uf3hjcln8ic Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240412@080350.3978 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080350.3982 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from td where ndoc = 39
20240412@080350.4073 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240412@080350.4243 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080350.4522 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240412@080350.4841 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080350.5350 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240412@080350.6233 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080350.6412 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240412@080350.6423 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080350.6525 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080350.6782 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080350.6818 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240412@080350.6971 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6618d988946618dcd69c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240412@080350.7378 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080350.7601 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240412@080350.8407 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240412@080350.8412 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240412@080350.8417 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240412@080350.8423 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240412@080350.8427 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240412@080350.8442 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240412@080350.8447 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6618d988946618dcd69c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240412@080350.9006 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 fno valor from wsft039data order by fno desc
20240412@080350.9206 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080350.9430 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240412@080350.9828 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6618d988946618dcd69c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',866,100810,0,'2024-04-12',39,'euro',0,0,2024 ,'20240412','0833',?,?,?,?)
20240412@080351.4210 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080351.4260 lfc68fjutkg1293uf3hjcln8ic Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240412@080351.6460 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240412@080351.1133 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080351.1359 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080351.1726 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080351.1903 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080351.1908 lfc68fjutkg1293uf3hjcln8ic Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240412@080351.1925 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080351.1942 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080351.2081 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080351.2251 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d151486618dcd72f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut6618d988946618dcd69c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240412@080351.2965 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080351.3190 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080351.3275 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d151486618dcd72f','aut6618d988946618dcd69c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080351.3322 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080351.3440 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080351.3629 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080351.3647 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080351.3652 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080351.3671 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080351.3849 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080351.4055 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d834486618dcd759',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d988946618dcd69c' ,0,0 ,2,23.00,20000,?,?,?)
20240412@080351.4682 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080351.5219 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080351.5308 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d834486618dcd759','aut6618d988946618dcd69c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080351.5356 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080351.5401 lfc68fjutkg1293uf3hjcln8ic Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240412@080351.5539 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240412@080351.5696 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080351.5712 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080351.5821 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080351.6261 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080351.6329 lfc68fjutkg1293uf3hjcln8ic Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240412@080351.6342 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080351.6579 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080351.6803 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080351.7210 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d328516618dcd7a0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',32.000 ,'aut6618d988946618dcd69c' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240412@080351.7843 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080351.8138 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080351.8537 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d328516618dcd7a0','aut6618d988946618dcd69c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080351.9227 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080351.9244 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080351.9768 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080352.6000 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080352.1430 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080352.1920 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080352.2860 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080352.3870 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d024016618dcd804',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d988946618dcd69c' ,0,0 ,2,23.00,50000,?,?,?)
20240412@080352.9250 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080352.9630 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080352.9680 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d024016618dcd804','aut6618d988946618dcd69c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080352.1062 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080352.1105 lfc68fjutkg1293uf3hjcln8ic Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240412@080352.1314 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240412@080352.1532 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080352.1736 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080352.2001 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080352.2016 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080352.2021 lfc68fjutkg1293uf3hjcln8ic Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240412@080352.2031 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080352.2228 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080352.2335 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080352.2654 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d160396618dcd836',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',120.000 ,'aut6618d988946618dcd69c' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240412@080352.3287 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080352.3496 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080352.3502 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d160396618dcd836','aut6618d988946618dcd69c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080352.3508 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080352.3659 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080352.3685 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080352.3704 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080352.3826 lfc68fjutkg1293uf3hjcln8ic Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080352.3988 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080352.4005 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080352.4615 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d080156618dcd861',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d988946618dcd69c' ,0,0 ,2,23.00,80000,?,?,?)
20240412@080352.5194 lfc68fjutkg1293uf3hjcln8ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080352.5362 lfc68fjutkg1293uf3hjcln8ic Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080352.5369 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d080156618dcd861','aut6618d988946618dcd69c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080352.5374 lfc68fjutkg1293uf3hjcln8ic Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6618d988946618dcd69c','2402699','wait',39,'ari17112337378,753000005')
20240412@080352.5390 lfc68fjutkg1293uf3hjcln8ic Query : use flama_phc
20240412@080352.5393 lfc68fjutkg1293uf3hjcln8ic Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240412@080352.5404 lfc68fjutkg1293uf3hjcln8ic Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1116';
20240412@080352.5431 lfc68fjutkg1293uf3hjcln8ic Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1116';
20240412@080352.5521 lfc68fjutkg1293uf3hjcln8ic Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1116';
20240412@080352.5866 lfc68fjutkg1293uf3hjcln8ic Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1116';
20240412@080352.6994 t4hglf1j7cro1t7tkqmp9aj2rf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240412@080352.7046 t4hglf1j7cro1t7tkqmp9aj2rf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240412@080352.7193 t4hglf1j7cro1t7tkqmp9aj2rf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1117';
20240412@080352.7249 t4hglf1j7cro1t7tkqmp9aj2rf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1117';
20240412@080352.7344 t4hglf1j7cro1t7tkqmp9aj2rf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1117';
20240412@080352.7557 t4hglf1j7cro1t7tkqmp9aj2rf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1117';
20240412@080352.7643 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080352.7741 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240412@080352.7989 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080352.8031 t4hglf1j7cro1t7tkqmp9aj2rf Query : select no, estab,szadrsdesc from szadrs where u_coddest=4784
20240412@080352.8399 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20240412@080352.8774 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402707 and bi.ref ='324.1834.00.1' and bi.lordem =1
20240412@080352.9356 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080352.9436 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240412@080352.9932 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080353.8000 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 1 valor from td where td.ndoc = 39
20240412@080353.1070 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080353.1112 t4hglf1j7cro1t7tkqmp9aj2rf Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240412@080353.1322 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240412@080353.1621 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080353.1643 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 ~inactivo valor from cl where no = '102410' and estab = 0 order by inactivo desc
20240412@080353.1906 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080353.1909 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240412@080353.1929 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080353.1932 t4hglf1j7cro1t7tkqmp9aj2rf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240412@080353.1947 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080353.1951 t4hglf1j7cro1t7tkqmp9aj2rf Query : select szadrsstamp valor from szadrs where szadrsdesc='102410 - media markt matosinhos - prod inform e el'
20240412@080353.1969 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080353.1981 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from td where ndoc = 39
20240412@080353.2160 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240412@080353.2281 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080353.2510 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240412@080353.2883 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080353.3119 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240412@080353.3371 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080353.3399 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240412@080353.3411 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080353.3966 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080353.3986 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080353.4043 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240412@080353.4061 t4hglf1j7cro1t7tkqmp9aj2rf Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6618d800466618dcd953' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240412@080353.4279 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080353.4300 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240412@080353.4364 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240412@080353.4370 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240412@080353.4375 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240412@080353.4379 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240412@080353.4384 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240412@080353.4389 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240412@080353.4521 t4hglf1j7cro1t7tkqmp9aj2rf Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6618d800466618dcd953',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240412@080353.5139 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 fno valor from wsft039data order by fno desc
20240412@080353.5163 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080353.5185 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240412@080353.5209 t4hglf1j7cro1t7tkqmp9aj2rf Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6618d800466618dcd953',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',867,102410,0,'2024-04-12',39,'euro',0,0,2024 ,'20240412','0833',?,?,?,?)
20240412@080353.5610 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080353.5617 t4hglf1j7cro1t7tkqmp9aj2rf Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20240412@080353.5648 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1834.00.1'
20240412@080353.5854 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080353.5871 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080353.5904 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080353.5932 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080353.5936 t4hglf1j7cro1t7tkqmp9aj2rf Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2300974200a'
20240412@080353.6017 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080353.6032 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080353.6047 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080353.6081 t4hglf1j7cro1t7tkqmp9aj2rf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d283556618dcd993',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6618d800466618dcd953' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240412@080353.6433 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080353.6453 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080353.6457 t4hglf1j7cro1t7tkqmp9aj2rf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d283556618dcd993','aut6618d800466618dcd953' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080353.6465 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080353.6575 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080353.6608 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080353.6651 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080353.6656 t4hglf1j7cro1t7tkqmp9aj2rf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080353.6668 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080353.6684 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080353.6715 t4hglf1j7cro1t7tkqmp9aj2rf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d278716618dcd9a2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d800466618dcd953' ,0,0 ,2,23.00,20000,?,?,?)
20240412@080353.7049 t4hglf1j7cro1t7tkqmp9aj2rf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080353.7273 t4hglf1j7cro1t7tkqmp9aj2rf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080353.7355 t4hglf1j7cro1t7tkqmp9aj2rf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d278716618dcd9a2','aut6618d800466618dcd953' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080353.7483 t4hglf1j7cro1t7tkqmp9aj2rf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6618d800466618dcd953','2402707','wait',39,'ari17112337378,753000005')
20240412@080353.7714 t4hglf1j7cro1t7tkqmp9aj2rf Query : use flama_phc
20240412@080353.7718 t4hglf1j7cro1t7tkqmp9aj2rf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240412@080353.7729 t4hglf1j7cro1t7tkqmp9aj2rf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1117';
20240412@080353.7821 t4hglf1j7cro1t7tkqmp9aj2rf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1117';
20240412@080353.7994 t4hglf1j7cro1t7tkqmp9aj2rf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1117';
20240412@080353.8194 t4hglf1j7cro1t7tkqmp9aj2rf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1117';
20240412@080353.8933 i9cebdkn8bvth3enmq5c9absst Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240412@080353.8949 i9cebdkn8bvth3enmq5c9absst Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240412@080353.8988 i9cebdkn8bvth3enmq5c9absst Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1118';
20240412@080353.9033 i9cebdkn8bvth3enmq5c9absst Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1118';
20240412@080353.9049 i9cebdkn8bvth3enmq5c9absst Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1118';
20240412@080353.9063 i9cebdkn8bvth3enmq5c9absst Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1118';
20240412@080353.9116 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080353.9120 i9cebdkn8bvth3enmq5c9absst Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240412@080353.9132 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080353.9135 i9cebdkn8bvth3enmq5c9absst Query : select no, estab,szadrsdesc from szadrs where u_coddest=416
20240412@080353.9593 i9cebdkn8bvth3enmq5c9absst Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1646.00.1'
20240412@080353.9768 i9cebdkn8bvth3enmq5c9absst Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402709 and bi.ref ='324.1646.00.1' and bi.lordem =1
20240412@080354.2780 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.2820 i9cebdkn8bvth3enmq5c9absst Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240412@080354.4540 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.4680 i9cebdkn8bvth3enmq5c9absst Query : select top 1 1 valor from td where td.ndoc = 39
20240412@080354.7730 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.8180 i9cebdkn8bvth3enmq5c9absst Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240412@080354.1039 i9cebdkn8bvth3enmq5c9absst Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240412@080354.1494 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.1539 i9cebdkn8bvth3enmq5c9absst Query : select top 1 ~inactivo valor from cl where no = '102079' and estab = 0 order by inactivo desc
20240412@080354.1923 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.1967 i9cebdkn8bvth3enmq5c9absst Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240412@080354.2012 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.2018 i9cebdkn8bvth3enmq5c9absst Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240412@080354.2031 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.2034 i9cebdkn8bvth3enmq5c9absst Query : select szadrsstamp valor from szadrs where szadrsdesc='bragajav, lda.'
20240412@080354.2050 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.2053 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from td where ndoc = 39
20240412@080354.2063 i9cebdkn8bvth3enmq5c9absst Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240412@080354.2076 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080354.2090 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240412@080354.2106 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080354.2120 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240412@080354.2201 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080354.2217 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240412@080354.2249 i9cebdkn8bvth3enmq5c9absst Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080354.2399 i9cebdkn8bvth3enmq5c9absst Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080354.2410 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080354.2450 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240412@080354.2517 i9cebdkn8bvth3enmq5c9absst Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6618d487616618dcda36' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240412@080354.2775 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080354.2841 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240412@080354.2907 i9cebdkn8bvth3enmq5c9absst Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240412@080354.2912 i9cebdkn8bvth3enmq5c9absst Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240412@080354.2940 i9cebdkn8bvth3enmq5c9absst Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240412@080354.2946 i9cebdkn8bvth3enmq5c9absst Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240412@080354.2972 i9cebdkn8bvth3enmq5c9absst Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240412@080354.2977 i9cebdkn8bvth3enmq5c9absst Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240412@080354.2981 i9cebdkn8bvth3enmq5c9absst Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6618d487616618dcda36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240412@080354.3339 i9cebdkn8bvth3enmq5c9absst Query : select top 1 fno valor from wsft039data order by fno desc
20240412@080354.3381 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080354.3418 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240412@080354.3455 i9cebdkn8bvth3enmq5c9absst Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6618d487616618dcda36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',868,102079,0,'2024-04-12',39,'euro',0,0,2024 ,'20240412','0833',?,?,?,?)
20240412@080354.3905 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.3933 i9cebdkn8bvth3enmq5c9absst Query : select st.usalote valor from st where st.ref = '324.1646.00.1'
20240412@080354.3982 i9cebdkn8bvth3enmq5c9absst Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1646.00.1'
20240412@080354.4209 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080354.4256 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080354.5998 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080354.6014 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080354.6042 i9cebdkn8bvth3enmq5c9absst Query : select sestamp valor from se where ref ='324.1646.00.1' and lote = 'r2101259200a'
20240412@080354.6099 i9cebdkn8bvth3enmq5c9absst Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080354.6134 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080354.6148 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080354.6193 i9cebdkn8bvth3enmq5c9absst Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d129796618dcda95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6618d487616618dcda36' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240412@080354.6617 i9cebdkn8bvth3enmq5c9absst Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080354.6727 i9cebdkn8bvth3enmq5c9absst Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080354.6750 i9cebdkn8bvth3enmq5c9absst Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d129796618dcda95','aut6618d487616618dcda36' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080354.6756 i9cebdkn8bvth3enmq5c9absst Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6618d487616618dcda36','2402709','wait',39,'ari17112337378,753000005')
20240412@080354.6798 i9cebdkn8bvth3enmq5c9absst Query : use flama_phc
20240412@080354.6824 i9cebdkn8bvth3enmq5c9absst Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240412@080354.6838 i9cebdkn8bvth3enmq5c9absst Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1118';
20240412@080354.6910 i9cebdkn8bvth3enmq5c9absst Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1118';
20240412@080354.6926 i9cebdkn8bvth3enmq5c9absst Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1118';
20240412@080354.6971 i9cebdkn8bvth3enmq5c9absst Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1118';
20240412@080354.7450 skjnqp8hdjnt9g8majkj8rii0u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240412@080354.7464 skjnqp8hdjnt9g8majkj8rii0u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240412@080354.7516 skjnqp8hdjnt9g8majkj8rii0u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1119';
20240412@080354.7576 skjnqp8hdjnt9g8majkj8rii0u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1119';
20240412@080354.7593 skjnqp8hdjnt9g8majkj8rii0u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1119';
20240412@080354.7626 skjnqp8hdjnt9g8majkj8rii0u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1119';
20240412@080354.7641 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080354.7645 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240412@080354.7657 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080354.7661 skjnqp8hdjnt9g8majkj8rii0u Query : select no, estab,szadrsdesc from szadrs where u_coddest=1100
20240412@080354.7752 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240412@080354.8250 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.645.00.01' and bi.lordem =1
20240412@080354.8853 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240412@080354.9073 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.646.00.01' and bi.lordem =2
20240412@080354.9442 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240412@080354.9457 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.646.00.01' and bi.lordem =3
20240412@080354.9865 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20240412@080355.4000 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.691.00.01' and bi.lordem =4
20240412@080355.4370 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20240412@080355.4530 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.691.00.01' and bi.lordem =4
20240412@080355.4590 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20240412@080355.7040 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.1816.00.1' and bi.lordem =5
20240412@080355.1128 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20240412@080355.1139 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.691.00.01' and bi.lordem =6
20240412@080355.1485 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1884.00.1'
20240412@080355.1681 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.1884.00.1' and bi.lordem =7
20240412@080355.2598 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1884.00.1'
20240412@080355.2610 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.1884.00.1' and bi.lordem =8
20240412@080355.2981 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20240412@080355.3312 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.1803.00.1' and bi.lordem =9
20240412@080355.3762 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240412@080355.4009 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402710 and bi.ref ='324.1833.00.2' and bi.lordem =10
20240412@080355.4349 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.4353 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240412@080355.4367 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.4370 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 1 valor from td where td.ndoc = 39
20240412@080355.4382 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.4385 skjnqp8hdjnt9g8majkj8rii0u Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240412@080355.4396 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240412@080355.4410 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.4413 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 ~inactivo valor from cl where no = '101830' and estab = 0 order by inactivo desc
20240412@080355.4529 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.4533 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240412@080355.4546 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.4549 skjnqp8hdjnt9g8majkj8rii0u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240412@080355.4560 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.4563 skjnqp8hdjnt9g8majkj8rii0u Query : select szadrsstamp valor from szadrs where szadrsdesc='ribeiro & vilarinho,lda-electro s.mamede'
20240412@080355.4752 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.4758 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from td where ndoc = 39
20240412@080355.4772 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240412@080355.4789 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080355.4807 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240412@080355.4828 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080355.4841 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240412@080355.4867 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080355.4881 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240412@080355.4892 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080355.5000 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240412@080355.5012 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240412@080355.5033 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240412@080355.5044 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240412@080355.5240 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240412@080355.5256 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240412@080355.5287 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240412@080355.5292 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240412@080355.5297 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240412@080355.5302 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240412@080355.5306 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240412@080355.5311 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240412@080355.5316 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6618d848086618dcdb77',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240412@080355.5611 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 fno valor from wsft039data order by fno desc
20240412@080355.5629 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240412@080355.5642 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240412@080355.5658 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6618d848086618dcdb77',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',869,101830,0,'2024-04-12',39,'euro',0,0,2024 ,'20240412','0833',?,?,?,?)
20240412@080355.5997 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.6001 skjnqp8hdjnt9g8majkj8rii0u Query : select st.usalote valor from st where st.ref = '324.645.00.01'
20240412@080355.6014 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.645.00.01'
20240412@080355.6177 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.6200 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080355.6232 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.6246 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080355.6251 skjnqp8hdjnt9g8majkj8rii0u Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2301259100a'
20240412@080355.6262 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080355.6273 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.6285 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080355.6309 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d296136618dcdb99',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240412@080355.6606 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.6623 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080355.6627 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d296136618dcdb99','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080355.6637 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.6649 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080355.6693 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.6707 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080355.6711 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080355.6722 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.6734 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080355.6758 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d451626618dcdba4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,20000,?,?,?)
20240412@080355.7038 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.7053 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080355.7058 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d451626618dcdba4','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080355.7064 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.7068 skjnqp8hdjnt9g8majkj8rii0u Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240412@080355.7080 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20240412@080355.7264 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.7278 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080355.7304 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.7320 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080355.7326 skjnqp8hdjnt9g8majkj8rii0u Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2301259100a'
20240412@080355.7357 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080355.7368 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.7383 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080355.7408 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d961396618dcdbb3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240412@080355.7713 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.7729 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080355.7733 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d961396618dcdbb3','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080355.7738 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.7751 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080355.7779 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.7792 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080355.7797 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080355.7807 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.7822 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080355.7846 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d963806618dcdbbe',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,50000,?,?,?)
20240412@080355.8160 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.8198 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080355.8204 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d963806618dcdbbe','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080355.8210 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.8215 skjnqp8hdjnt9g8majkj8rii0u Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240412@080355.8229 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20240412@080355.8242 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.8263 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080355.8294 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.8310 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080355.8320 skjnqp8hdjnt9g8majkj8rii0u Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2301259100a'
20240412@080355.8332 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080355.8344 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.8364 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080355.8393 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d867246618dcdbcb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240412@080355.8703 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.8721 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080355.8726 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d867246618dcdbcb','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080355.8732 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.8749 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080355.8781 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.8794 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080355.8799 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080355.8808 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.8824 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080355.8858 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d012326618dcdbd7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,80000,?,?,?)
20240412@080355.9251 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.9379 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080355.9384 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d012326618dcdbd7','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080355.9389 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080355.9393 skjnqp8hdjnt9g8majkj8rii0u Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240412@080355.9405 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.691.00.01'
20240412@080355.9579 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.9595 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080355.9622 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080355.9634 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080355.9638 skjnqp8hdjnt9g8majkj8rii0u Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2301201200a'
20240412@080355.9648 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080355.9696 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080355.9802 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080355.9833 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d801976618dcdbec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240412@080356.1270 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.1430 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.1470 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d801976618dcdbec','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.1530 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.1660 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080356.2000 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.2120 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080356.2170 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080356.2270 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.2520 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080356.2810 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d997476618dcdc05',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,110000,?,?,?)
20240412@080356.5780 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.5950 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.5990 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d997476618dcdc05','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.6040 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080356.6070 skjnqp8hdjnt9g8majkj8rii0u Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240412@080356.6200 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.691.00.01'
20240412@080356.6320 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.6510 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080356.6830 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.6970 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080356.7020 skjnqp8hdjnt9g8majkj8rii0u Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2301201200a'
20240412@080356.7110 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080356.7210 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.7490 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080356.7750 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d747726618dcdc11',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240412@080356.1117 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.1142 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.1147 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d747726618dcdc11','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.1153 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.1190 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080356.1224 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.1243 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080356.1248 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080356.1258 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.1288 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080356.1343 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d252856618dcdc1e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,140000,?,?,?)
20240412@080356.1702 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.1742 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.1747 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d252856618dcdc1e','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.1753 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080356.1756 skjnqp8hdjnt9g8majkj8rii0u Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240412@080356.1775 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20240412@080356.1980 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.2249 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080356.2281 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.2296 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080356.2301 skjnqp8hdjnt9g8majkj8rii0u Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2301097200a'
20240412@080356.2317 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080356.2328 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.2341 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080356.2366 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d439516618dcdc38',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20240412@080356.2681 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.2696 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.2701 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d439516618dcdc38','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.2706 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.2718 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080356.2742 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.2755 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080356.2759 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080356.2775 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.2789 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080356.2811 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d611256618dcdc43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,170000,?,?,?)
20240412@080356.3104 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.3119 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.3123 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d611256618dcdc43','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.3127 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080356.3130 skjnqp8hdjnt9g8majkj8rii0u Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240412@080356.3140 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.691.00.01'
20240412@080356.3151 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.3164 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080356.3186 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.3199 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080356.3202 skjnqp8hdjnt9g8majkj8rii0u Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2301201200a'
20240412@080356.3212 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080356.3221 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.3233 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080356.3261 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d406056618dcdc4e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20240412@080356.3544 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.3752 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.3757 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d406056618dcdc4e','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.3763 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.3780 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080356.3817 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.3831 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080356.3836 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080356.3846 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.3859 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080356.3927 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d246856618dcdc5d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,200000,?,?,?)
20240412@080356.4281 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.4303 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.4308 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d246856618dcdc5d','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.4341 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080356.4344 skjnqp8hdjnt9g8majkj8rii0u Query : select st.usalote valor from st where st.ref = '324.1884.00.1'
20240412@080356.4364 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1884.00.1'
20240412@080356.4559 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.4595 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080356.4728 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.4829 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080356.4861 skjnqp8hdjnt9g8majkj8rii0u Query : select sestamp valor from se where ref ='324.1884.00.1' and lote = 'r2301208100a'
20240412@080356.4881 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080356.4891 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.4905 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080356.4950 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6618d172216618dcdc77',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20240412@080356.5324 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.5364 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.5458 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d172216618dcdc77','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.5466 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.5500 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240412@080356.5607 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.5637 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240412@080356.5653 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240412@080356.5665 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240412@080356.5689 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240412@080356.5717 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6618d828806618dcdc8a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6618d848086618dcdb77' ,0,0 ,2,23.00,230000,?,?,?)
20240412@080356.6039 skjnqp8hdjnt9g8majkj8rii0u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240412@080356.6089 skjnqp8hdjnt9g8majkj8rii0u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240412@080356.6105 skjnqp8hdjnt9g8majkj8rii0u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6618d828806618dcdc8a','aut6618d848086618dcdb77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240412@080356.6109 skjnqp8hdjnt9g8majkj8rii0u Query : use flama_phc
20240412@080356.6113 skjnqp8hdjnt9g8majkj8rii0u Query : select st.usalote valor from st where st.ref = '324.1884.00.1'
20240412@080356.6130 skjnqp8hdjnt9g8majkj8rii0u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1884.00.1'
