20240724@195659.2788 1cgmoc36k63hsmtn6qai32ac9v Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240724@195659.2800 1cgmoc36k63hsmtn6qai32ac9v Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240724@195659.2811 1cgmoc36k63hsmtn6qai32ac9v Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240724@195659.2823 1cgmoc36k63hsmtn6qai32ac9v Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240724@195659.2834 1cgmoc36k63hsmtn6qai32ac9v Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240724@195659.2845 1cgmoc36k63hsmtn6qai32ac9v Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a141691766a14e7b3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240724@195659.3056 1cgmoc36k63hsmtn6qai32ac9v Query : select top 1 fno valor from wsftdata order by fno desc
20240724@195659.3071 1cgmoc36k63hsmtn6qai32ac9v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195659.3086 1cgmoc36k63hsmtn6qai32ac9v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240724@195659.3108 1cgmoc36k63hsmtn6qai32ac9v Query : select 'normal' from dummy
20240724@195659.3123 1cgmoc36k63hsmtn6qai32ac9v Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a141691766a14e7b3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20,101889,0,'2024-07-24',39,'euro',0,0,2024 ,?,?)
20240724@195659.3369 1cgmoc36k63hsmtn6qai32ac9v Query : use flama_phc
20240724@195659.3373 1cgmoc36k63hsmtn6qai32ac9v Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20240724@195659.3395 1cgmoc36k63hsmtn6qai32ac9v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20240724@195659.3519 1cgmoc36k63hsmtn6qai32ac9v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195659.3535 1cgmoc36k63hsmtn6qai32ac9v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195659.3562 1cgmoc36k63hsmtn6qai32ac9v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195659.3580 1cgmoc36k63hsmtn6qai32ac9v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195659.3588 1cgmoc36k63hsmtn6qai32ac9v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195659.3601 1cgmoc36k63hsmtn6qai32ac9v Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20240724@195659.3615 1cgmoc36k63hsmtn6qai32ac9v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195659.3630 1cgmoc36k63hsmtn6qai32ac9v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195659.3641 1cgmoc36k63hsmtn6qai32ac9v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a140179466a14e7b58','aut66a141691766a14e7b3a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195659.3646 1cgmoc36k63hsmtn6qai32ac9v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195659.3660 1cgmoc36k63hsmtn6qai32ac9v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195659.3689 1cgmoc36k63hsmtn6qai32ac9v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a140179466a14e7b58',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',66.000 ,'aut66a141691766a14e7b3a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240724@195659.3899 1cgmoc36k63hsmtn6qai32ac9v Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a141691766a14e7b3a','2404946','wait',39,'adm09112754980.682000002')
20240724@195659.3980 1cgmoc36k63hsmtn6qai32ac9v Query : use flama_phc
20240724@195659.3984 1cgmoc36k63hsmtn6qai32ac9v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240724@195659.4016 1cgmoc36k63hsmtn6qai32ac9v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1163';
20240724@195659.4043 1cgmoc36k63hsmtn6qai32ac9v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1163';
20240724@195659.4081 1cgmoc36k63hsmtn6qai32ac9v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1163';
20240724@195659.4104 1cgmoc36k63hsmtn6qai32ac9v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1163';
20240724@195659.4599 bu24n1kg243i5l9v0akgp95tu9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240724@195659.4611 bu24n1kg243i5l9v0akgp95tu9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240724@195659.4664 bu24n1kg243i5l9v0akgp95tu9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1164';
20240724@195659.4715 bu24n1kg243i5l9v0akgp95tu9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1164';
20240724@195659.4765 bu24n1kg243i5l9v0akgp95tu9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1164';
20240724@195659.4787 bu24n1kg243i5l9v0akgp95tu9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1164';
20240724@195659.4837 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.4840 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240724@195659.4905 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.4908 bu24n1kg243i5l9v0akgp95tu9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2448
20240724@195659.4948 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4743.00.1'
20240724@195659.5058 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404948 and bi.ref ='324.4743.00.1' and bi.lordem =1
20240724@195659.5361 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20240724@195659.5382 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404948 and bi.ref ='324.1608.00.1' and bi.lordem =2
20240724@195659.5659 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240724@195659.5779 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404948 and bi.ref ='324.4990.00.1' and bi.lordem =3
20240724@195659.6055 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2028.00.2'
20240724@195659.6171 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404948 and bi.ref ='324.2028.00.2' and bi.lordem =4
20240724@195659.6449 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5500.00.1'
20240724@195659.7914 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404948 and bi.ref ='324.5500.00.1' and bi.lordem =5
20240724@195659.8203 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240724@195659.8308 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404948 and bi.ref ='324.2031.00.1' and bi.lordem =6
20240724@195659.8564 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5501.00.1'
20240724@195659.8664 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404948 and bi.ref ='324.5501.00.1' and bi.lordem =7
20240724@195659.9508 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.9513 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240724@195659.9550 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.9553 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 1 valor from td where td.ndoc = 39
20240724@195659.9589 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.9592 bu24n1kg243i5l9v0akgp95tu9 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240724@195659.9622 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240724@195659.9659 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.9662 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 ~inactivo valor from cl where no = '101889' and estab = 0 order by inactivo desc
20240724@195659.9693 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.9696 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240724@195659.9728 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.9731 bu24n1kg243i5l9v0akgp95tu9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240724@195659.9775 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.9779 bu24n1kg243i5l9v0akgp95tu9 Query : select szadrsstamp valor from szadrs where szadrsdesc='cooplecnorte,crl'
20240724@195659.9827 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195659.9830 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from td where ndoc = 39
20240724@195659.9848 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240724@195659.9864 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195659.9882 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240724@195659.9903 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195659.9922 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240724@195659.9951 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195659.9965 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240724@195659.9978 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240724@195700.5100 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240724@195700.6400 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.8000 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240724@195700.9500 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240724@195700.2430 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.2610 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240724@195700.2970 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240724@195700.3090 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240724@195700.3210 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240724@195700.3320 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240724@195700.3440 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240724@195700.3550 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240724@195700.3670 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a147190066a14e7bf3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240724@195700.5880 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 fno valor from wsftdata order by fno desc
20240724@195700.6040 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.6200 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240724@195700.6440 bu24n1kg243i5l9v0akgp95tu9 Query : select 'normal' from dummy
20240724@195700.6590 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a147190066a14e7bf3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',21,101889,0,'2024-07-24',39,'euro',0,0,2024 ,?,?)
20240724@195700.9640 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195700.9670 bu24n1kg243i5l9v0akgp95tu9 Query : select st.usalote valor from st where st.ref = '324.4743.00.1'
20240724@195700.9920 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4743.00.1'
20240724@195700.1126 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.1142 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.1169 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.1183 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.1192 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195700.1205 bu24n1kg243i5l9v0akgp95tu9 Query : select sestamp valor from se where ref ='324.4743.00.1' and lote = 'r2200085100a'
20240724@195700.1241 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.1258 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.1270 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a140609866a14e7c1e','aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195700.1274 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.1289 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.1316 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a140609866a14e7c1e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66a147190066a14e7bf3' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240724@195700.1556 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195700.1560 bu24n1kg243i5l9v0akgp95tu9 Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20240724@195700.1581 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1608.00.1'
20240724@195700.1594 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.1611 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.1637 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.1651 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.1660 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195700.1674 bu24n1kg243i5l9v0akgp95tu9 Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2200658200a'
20240724@195700.1687 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.1701 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.1713 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a146451466a14e7c29','aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195700.1718 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.1733 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.1763 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a146451466a14e7c29',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a147190066a14e7bf3' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240724@195700.2005 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195700.2009 bu24n1kg243i5l9v0akgp95tu9 Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20240724@195700.2030 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4990.00.1'
20240724@195700.2136 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.2152 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.2178 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.2192 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.2201 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195700.2213 bu24n1kg243i5l9v0akgp95tu9 Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20240724@195700.2227 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.2241 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.2253 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a143640366a14e7c36','aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195700.2258 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.2273 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.2301 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a143640366a14e7c36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66a147190066a14e7bf3' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240724@195700.2543 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195700.2546 bu24n1kg243i5l9v0akgp95tu9 Query : select st.usalote valor from st where st.ref = '324.2028.00.2'
20240724@195700.2568 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2028.00.2'
20240724@195700.2675 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.2692 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.2718 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.2733 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.2741 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195700.2753 bu24n1kg243i5l9v0akgp95tu9 Query : select sestamp valor from se where ref ='324.2028.00.2' and lote = 'r2100875100a'
20240724@195700.2769 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.2795 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.2820 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a142670366a14e7c43','aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195700.2825 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.2841 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.2870 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a142670366a14e7c43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66a147190066a14e7bf3' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240724@195700.3102 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.3118 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.3145 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.3159 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.3167 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195700.3180 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.3194 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.3208 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a142916366a14e7c4d','aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195700.3213 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.3227 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.3254 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a142916366a14e7c4d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a147190066a14e7bf3' ,0,0 ,2,23.00,50000,?,?,?)
20240724@195700.3462 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195700.3465 bu24n1kg243i5l9v0akgp95tu9 Query : select st.usalote valor from st where st.ref = '324.5500.00.1'
20240724@195700.3485 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5500.00.1'
20240724@195700.3594 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.3611 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.3637 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.3651 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.3659 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195700.3671 bu24n1kg243i5l9v0akgp95tu9 Query : select sestamp valor from se where ref ='324.5500.00.1' and lote = 'r2301223200a'
20240724@195700.3684 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.3698 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.3709 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a146850866a14e7c59','aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195700.3713 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.3741 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.3768 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a146850866a14e7c59',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66a147190066a14e7bf3' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240724@195700.3998 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195700.4001 bu24n1kg243i5l9v0akgp95tu9 Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240724@195700.4025 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2031.00.1'
20240724@195700.4141 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.4157 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.4182 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.4195 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.4204 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195700.4215 bu24n1kg243i5l9v0akgp95tu9 Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240724@195700.4235 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.4249 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.4691 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a145513066a14e7c67','aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195700.4836 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.4905 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.4933 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a145513066a14e7c67',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a147190066a14e7bf3' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240724@195700.5168 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.5183 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.5207 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.5221 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.5230 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195700.5242 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.5256 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.5269 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a143325266a14e7c7f','aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195700.5274 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.5288 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.5314 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a143325266a14e7c7f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a147190066a14e7bf3' ,0,0 ,2,23.00,90000,?,?,?)
20240724@195700.5532 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195700.5535 bu24n1kg243i5l9v0akgp95tu9 Query : select st.usalote valor from st where st.ref = '324.5501.00.1'
20240724@195700.5554 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5501.00.1'
20240724@195700.5664 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.5682 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.5721 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.5739 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.5749 bu24n1kg243i5l9v0akgp95tu9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195700.5767 bu24n1kg243i5l9v0akgp95tu9 Query : select sestamp valor from se where ref ='324.5501.00.1' and lote = 'r2300908100a'
20240724@195700.5783 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.5797 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195700.5810 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a146831766a14e7c8d','aut66a147190066a14e7bf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195700.5814 bu24n1kg243i5l9v0akgp95tu9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195700.5829 bu24n1kg243i5l9v0akgp95tu9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195700.5856 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a146831766a14e7c8d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66a147190066a14e7bf3' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20240724@195700.6076 bu24n1kg243i5l9v0akgp95tu9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a147190066a14e7bf3','2404948','wait',39,'adm09112754980.682000002')
20240724@195700.6166 bu24n1kg243i5l9v0akgp95tu9 Query : use flama_phc
20240724@195700.6170 bu24n1kg243i5l9v0akgp95tu9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240724@195700.6219 bu24n1kg243i5l9v0akgp95tu9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1164';
20240724@195700.6248 bu24n1kg243i5l9v0akgp95tu9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1164';
20240724@195700.7593 bu24n1kg243i5l9v0akgp95tu9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1164';
20240724@195700.7625 bu24n1kg243i5l9v0akgp95tu9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1164';
20240724@195700.8666 8j4nviltcdqqij91akrg71vdqa Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240724@195700.8679 8j4nviltcdqqij91akrg71vdqa Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240724@195700.8744 8j4nviltcdqqij91akrg71vdqa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1165';
20240724@195700.8795 8j4nviltcdqqij91akrg71vdqa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1165';
20240724@195700.8847 8j4nviltcdqqij91akrg71vdqa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1165';
20240724@195700.8872 8j4nviltcdqqij91akrg71vdqa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1165';
20240724@195700.8919 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195700.8922 8j4nviltcdqqij91akrg71vdqa Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240724@195700.8992 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195700.8995 8j4nviltcdqqij91akrg71vdqa Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240724@195700.9051 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9071 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9344 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9364 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9382 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9402 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9419 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9438 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9468 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9487 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9503 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9522 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9541 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9560 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9577 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9597 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9615 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9634 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9650 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9671 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9688 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9707 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9726 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9745 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9762 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9793 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9809 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9829 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9845 8j4nviltcdqqij91akrg71vdqa Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20240724@195700.9865 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404949 and bi.ref ='324.1805.00.1' and bi.lordem =1
20240724@195700.9882 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195700.9885 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240724@195700.9920 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195700.9923 8j4nviltcdqqij91akrg71vdqa Query : select top 1 1 valor from td where td.ndoc = 39
20240724@195700.9961 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195700.9964 8j4nviltcdqqij91akrg71vdqa Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240724@195701.6670 8j4nviltcdqqij91akrg71vdqa Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240724@195701.7040 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.7070 8j4nviltcdqqij91akrg71vdqa Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240724@195701.7390 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.7420 8j4nviltcdqqij91akrg71vdqa Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240724@195701.7750 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.7780 8j4nviltcdqqij91akrg71vdqa Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240724@195701.8200 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.8240 8j4nviltcdqqij91akrg71vdqa Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240724@195701.8700 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.8740 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from td where ndoc = 39
20240724@195701.8870 8j4nviltcdqqij91akrg71vdqa Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240724@195701.9020 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9220 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240724@195701.9420 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9590 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240724@195701.9950 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.1010 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240724@195701.1024 8j4nviltcdqqij91akrg71vdqa Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240724@195701.1117 8j4nviltcdqqij91akrg71vdqa Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240724@195701.1145 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.1164 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240724@195701.1183 8j4nviltcdqqij91akrg71vdqa Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240724@195701.1403 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.1422 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240724@195701.1459 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240724@195701.1473 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240724@195701.1486 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240724@195701.1499 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240724@195701.1514 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240724@195701.1530 8j4nviltcdqqij91akrg71vdqa Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240724@195701.1543 8j4nviltcdqqij91akrg71vdqa Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a144173866a14e7d19',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240724@195701.1755 8j4nviltcdqqij91akrg71vdqa Query : select top 1 fno valor from wsftdata order by fno desc
20240724@195701.1776 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.1792 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240724@195701.1817 8j4nviltcdqqij91akrg71vdqa Query : select 'normal' from dummy
20240724@195701.1835 8j4nviltcdqqij91akrg71vdqa Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a144173866a14e7d19',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',22,100810,0,'2024-07-24',39,'euro',0,0,2024 ,?,?)
20240724@195701.2090 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.2093 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.2114 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.2142 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.2160 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.2190 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.2206 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.2216 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.2231 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.2245 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.2261 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.2287 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a140530066a14e7d36','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.2292 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.2309 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.2340 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a140530066a14e7d36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240724@195701.2608 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.2611 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.2644 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.2659 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.2677 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.2716 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.2731 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.2740 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.2768 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.2780 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.2795 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.2806 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a141917566a14e7d43','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.2810 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.2826 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.2861 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a141917566a14e7d43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240724@195701.3104 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.3108 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.3128 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.3155 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.3185 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.3211 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.3226 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.3235 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.3262 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.3277 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.3293 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.3305 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a142131466a14e7d50','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.3309 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.3324 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.3354 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a142131466a14e7d50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240724@195701.3580 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.3583 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.3603 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.3617 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.3634 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.3661 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.3675 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.3684 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.3696 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.3709 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.3724 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.3735 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a148441466a14e7d5a','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.3739 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.3754 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.3784 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a148441466a14e7d5a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240724@195701.4039 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.4042 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.4063 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.4077 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.4093 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.4119 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.4135 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.4144 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.4156 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.4169 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.4184 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.4196 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a140780466a14e7d65','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.4200 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.4215 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.4245 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a140780466a14e7d65',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240724@195701.4471 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.4474 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.4494 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.4508 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.4524 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.4552 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.4567 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.4581 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.4594 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.4607 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.4622 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.4635 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a146094566a14e7d70','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.4639 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.4654 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.4686 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a146094566a14e7d70',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240724@195701.5656 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.5995 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.6120 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.6149 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.6166 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.6194 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.6211 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.6220 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.6235 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.6256 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.6273 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.6285 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a141420766a14e7d98','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.6290 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.6305 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.6334 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a141420766a14e7d98',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240724@195701.6796 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.6809 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.7510 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.7524 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.7540 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.7565 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.7579 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.7588 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.7600 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.7613 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.7627 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.7639 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a144914466a14e7db9','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.7643 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.7658 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.7687 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a144914466a14e7db9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240724@195701.7900 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.7903 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.7921 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.7934 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.7949 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.7973 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.7988 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.7997 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.8009 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.8021 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8036 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.8047 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a147233966a14e7dc3','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.8051 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8066 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.8105 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a147233966a14e7dc3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20240724@195701.8333 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.8336 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.8356 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.8375 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8391 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.8418 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8432 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.8441 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.8454 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.8468 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8482 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.8494 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a145033666a14e7dce','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.8498 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8512 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.8540 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a145033666a14e7dce',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240724@195701.8778 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.8781 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.8801 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.8828 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8844 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.8870 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8884 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.8893 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.8906 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.8931 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8945 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.8958 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a141917266a14e7dda','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.8962 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.8990 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.9021 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a141917266a14e7dda',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20240724@195701.9292 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.9295 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.9315 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.9334 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9351 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.9379 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9393 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.9402 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.9415 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.9428 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9442 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.9454 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a144448366a14e7de6','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.9458 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9475 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.9504 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a144448366a14e7de6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20240724@195701.9767 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195701.9770 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195701.9791 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195701.9806 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9822 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.9847 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9861 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.9870 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195701.9882 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195701.9896 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9910 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195701.9922 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a146293266a14e7df1','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195701.9926 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195701.9941 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195701.9969 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a146293266a14e7df1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240724@195702.1830 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195702.1860 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195702.2060 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195702.2190 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195702.2340 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195702.2870 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195702.3020 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195702.3110 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195702.3240 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195702.3370 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195702.3520 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195702.3650 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a149705666a14e7e08','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195702.3700 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195702.3840 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195702.4130 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a149705666a14e7e08',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20240724@195702.9620 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195702.9650 8j4nviltcdqqij91akrg71vdqa Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195702.9860 8j4nviltcdqqij91akrg71vdqa Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195702.1000 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195702.1016 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195702.1041 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195702.1056 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195702.1064 8j4nviltcdqqij91akrg71vdqa Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195702.1076 8j4nviltcdqqij91akrg71vdqa Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195702.1089 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195702.1104 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240724@195702.1116 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a149158366a14e7e1a','aut66a144173866a14e7d19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240724@195702.1120 8j4nviltcdqqij91akrg71vdqa Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195702.1136 8j4nviltcdqqij91akrg71vdqa Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240724@195702.1174 8j4nviltcdqqij91akrg71vdqa Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a149158366a14e7e1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut66a144173866a14e7d19' ,0,0 ,2,23.00,150000,?,?,?,?,?)
20240724@195702.1835 8j4nviltcdqqij91akrg71vdqa Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a144173866a14e7d19','2404949','wait',39,'adm09112754980.682000002')
20240724@195702.2076 8j4nviltcdqqij91akrg71vdqa Query : use flama_phc
20240724@195702.2079 8j4nviltcdqqij91akrg71vdqa Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240724@195702.2124 8j4nviltcdqqij91akrg71vdqa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1165';
20240724@195702.2154 8j4nviltcdqqij91akrg71vdqa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1165';
20240724@195702.2193 8j4nviltcdqqij91akrg71vdqa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1165';
20240724@195702.2219 8j4nviltcdqqij91akrg71vdqa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1165';
20240724@195702.3676 hqiaeo430ian6t0d52lgg7a0t5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240724@195702.3688 hqiaeo430ian6t0d52lgg7a0t5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240724@195702.3739 hqiaeo430ian6t0d52lgg7a0t5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1166';
20240724@195702.3793 hqiaeo430ian6t0d52lgg7a0t5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1166';
20240724@195702.3844 hqiaeo430ian6t0d52lgg7a0t5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1166';
20240724@195702.3871 hqiaeo430ian6t0d52lgg7a0t5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1166';
20240724@195702.4810 7rs9cmm6tv2ukttdr7865vc9el Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240724@195702.4822 7rs9cmm6tv2ukttdr7865vc9el Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240724@195702.4873 7rs9cmm6tv2ukttdr7865vc9el Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1167';
20240724@195702.4925 7rs9cmm6tv2ukttdr7865vc9el Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1167';
20240724@195702.4974 7rs9cmm6tv2ukttdr7865vc9el Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1167';
20240724@195702.4996 7rs9cmm6tv2ukttdr7865vc9el Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1167';
20240724@195702.5032 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195702.5040 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240724@195702.5106 7rs9cmm6tv2ukttdr7865vc9el Query : select no, estab,szadrsdesc from szadrs where u_coddest=2
20240724@195702.5178 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '304.421.00.04'
20240724@195702.5267 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='304.421.00.04' and bi.lordem =10000
20240724@195702.6294 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072454980,176000001 ' 
20240724@195702.6771 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1805.00.1'
20240724@195702.6850 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.1805.00.1' and bi.lordem =20000
20240724@195702.7136 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455031,690000002 ' 
20240724@195702.7417 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1824.00.1'
20240724@195702.8678 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.1824.00.1' and bi.lordem =30000
20240724@195702.8959 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455059,183000003 ' 
20240724@195702.9212 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1871.00.1'
20240724@195702.9291 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.1871.00.1' and bi.lordem =40000
20240724@195702.9560 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455075,030000004 ' 
20240724@195702.9834 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1871.00.1'
20240724@195702.9855 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.1871.00.1' and bi.lordem =40000
20240724@195702.9878 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455075,030000004 ' 
20240724@195702.9898 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1871.00.1'
20240724@195702.9920 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.1871.00.1' and bi.lordem =40000
20240724@195702.9941 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455075,030000004 ' 
20240724@195702.9962 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1884.00.1'
20240724@195703.4200 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.1884.00.1' and bi.lordem =50000
20240724@195703.3080 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455096,858000005 ' 
20240724@195703.5490 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1884.00.1'
20240724@195703.5710 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.1884.00.1' and bi.lordem =50000
20240724@195703.5920 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455096,858000005 ' 
20240724@195703.6120 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4902.00.1'
20240724@195703.6930 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.4902.00.1' and bi.lordem =60000
20240724@195703.9790 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455110,161000006 ' 
20240724@195703.1315 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.691.00.01'
20240724@195703.1397 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.691.00.01' and bi.lordem =70000
20240724@195703.1668 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455128,490000007 ' 
20240724@195703.2529 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.692.00.01'
20240724@195703.2615 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.692.00.01' and bi.lordem =80000
20240724@195703.2892 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455146,462000008 ' 
20240724@195703.3138 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.692.00.01'
20240724@195703.3159 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.692.00.01' and bi.lordem =80000
20240724@195703.3183 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455146,462000008 ' 
20240724@195703.3203 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.729.00.01'
20240724@195703.3285 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.729.00.01' and bi.lordem =90000
20240724@195703.3568 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455184,888000009 ' 
20240724@195703.3835 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.728.00.01'
20240724@195703.3920 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.728.00.01' and bi.lordem =100000
20240724@195703.4210 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455202,912000010 ' 
20240724@195703.4448 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.958.00.01'
20240724@195703.4528 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.958.00.01' and bi.lordem =110000
20240724@195703.4787 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455213,888000011 ' 
20240724@195703.5024 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1847.00.1'
20240724@195703.5103 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.1847.00.1' and bi.lordem =120000
20240724@195703.5388 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455229,957000012 ' 
20240724@195703.5649 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.657.00.01'
20240724@195703.5678 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2024 and bo.obrano = 0001582 and bi.ref ='324.657.00.01' and bi.lordem =130000
20240724@195703.5944 7rs9cmm6tv2ukttdr7865vc9el Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'az24072455248,696000013 ' 
20240724@195703.6198 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.6202 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 1 valor from ts where ts.ndos = 5
20240724@195703.6290 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.6293 7rs9cmm6tv2ukttdr7865vc9el Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240724@195703.6329 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20240724@195703.6453 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.6456 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20240724@195703.6559 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.6563 7rs9cmm6tv2ukttdr7865vc9el Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240724@195703.6606 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.6610 7rs9cmm6tv2ukttdr7865vc9el Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20240724@195703.6662 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.6665 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from ts where ndos = 5
20240724@195703.6681 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195703.6699 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20240724@195703.6713 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195703.6729 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20240724@195703.6740 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195703.6756 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20240724@195703.6766 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20240724@195703.6875 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240724@195703.6955 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240724@195703.7017 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.7024 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20240724@195703.7090 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195703.7108 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20240724@195703.7122 7rs9cmm6tv2ukttdr7865vc9el Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a146755166a14e7fab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240724@195703.7178 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195703.7195 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20240724@195703.7209 7rs9cmm6tv2ukttdr7865vc9el Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut66a146755166a14e7fab','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20240724','20:27',?,?)
20240724@195703.7555 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195703.7573 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20240724@195703.7592 7rs9cmm6tv2ukttdr7865vc9el Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut66a146755166a14e7fab','trf entre armazéns a','2024-07-24',5,401,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20240724@195703.8080 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.8083 7rs9cmm6tv2ukttdr7865vc9el Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240724@195703.8120 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.8123 7rs9cmm6tv2ukttdr7865vc9el Query : select st.stns valor from st where st.ref = '304.421.00.04'
20240724@195703.8231 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.8234 7rs9cmm6tv2ukttdr7865vc9el Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '304.421.00.04' and sa.armazem = 133 
20240724@195703.8308 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195703.8311 7rs9cmm6tv2ukttdr7865vc9el Query : select st.stns valor from st where st.ref = '304.421.00.04'
20240724@195703.8341 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240724@195703.8480 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195703.8500 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240724@195703.8518 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195703.8536 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240724@195703.8547 7rs9cmm6tv2ukttdr7865vc9el Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240724@195703.8563 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195703.8580 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195703.8598 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240724@195703.9856 7rs9cmm6tv2ukttdr7865vc9el Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66a148378666a14e7fd1','aut66a146755166a14e7fab',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66a146755166a14e7fab'
20240724@195704.1058 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195704.1354 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240724@195704.1373 7rs9cmm6tv2ukttdr7865vc9el Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66a148378666a14e7fd1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 12.000, 12.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,25.6,25.6*200.48,25.6,25.6*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,25.6*12.000,25.6*12.000*200.48 ,10.323000,10.323000*200.48 ,10.323000,10.323000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,25.6,25.6*200.48,25.6*12.000,25.6*12.000*200.48,'az24072454980,176000001 ',25.6,25.6*12.000,25.6,25.6*12.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66a146755166a14e7fab'
20240724@195704.1837 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195704.1842 7rs9cmm6tv2ukttdr7865vc9el Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240724@195704.1858 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195704.1861 7rs9cmm6tv2ukttdr7865vc9el Query : select st.stns valor from st where st.ref = '324.1805.00.1'
20240724@195704.1880 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195704.1883 7rs9cmm6tv2ukttdr7865vc9el Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1805.00.1' and sa.armazem = 133 
20240724@195704.1948 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195704.1951 7rs9cmm6tv2ukttdr7865vc9el Query : select st.stns valor from st where st.ref = '324.1805.00.1'
20240724@195704.1969 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1805.00.1'
20240724@195704.1983 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195704.1998 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240724@195704.2010 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195704.2024 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240724@195704.2033 7rs9cmm6tv2ukttdr7865vc9el Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400290200a'
20240724@195704.2045 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240724@195704.2059 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195704.2074 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240724@195704.2086 7rs9cmm6tv2ukttdr7865vc9el Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66a149040966a14e8032','aut66a146755166a14e7fab',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66a146755166a14e7fab'
20240724@195704.2198 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195704.2214 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240724@195704.2231 7rs9cmm6tv2ukttdr7865vc9el Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66a149040966a14e8032',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 5.000, 5.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,20000 ,75,75*200.48,75,75*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,75*5.000,75*5.000*200.48 ,32.073000,32.073000*200.48 ,32.073000,32.073000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,75,75*200.48,75*5.000,75*5.000*200.48,'az24072455031,690000002 ',75,75*5.000,75,75*5.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66a146755166a14e7fab'
20240724@195704.2467 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195704.2471 7rs9cmm6tv2ukttdr7865vc9el Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240724@195704.2485 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195704.2488 7rs9cmm6tv2ukttdr7865vc9el Query : select st.stns valor from st where st.ref = '324.1824.00.1'
20240724@195704.2505 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195704.2508 7rs9cmm6tv2ukttdr7865vc9el Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1824.00.1' and sa.armazem = 133 
20240724@195704.2571 7rs9cmm6tv2ukttdr7865vc9el Query : use flama_phc
20240724@195704.2574 7rs9cmm6tv2ukttdr7865vc9el Query : select st.stns valor from st where st.ref = '324.1824.00.1'
20240724@195704.2593 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240724@195704.2607 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195704.2626 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240724@195704.2639 7rs9cmm6tv2ukttdr7865vc9el Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240724@195704.2655 7rs9cmm6tv2ukttdr7865vc9el Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240724@195704.2665 7rs9cmm6tv2ukttdr7865vc9el Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240724@195704.2678 7rs9cmm6tv2ukttdr7865vc9el Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
