20240806@172809.1259 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240806@172809.1272 qu2rjflpkugv91efdfecs98l7m Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240806@172809.1341 qu2rjflpkugv91efdfecs98l7m Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240806@172809.1355 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.1369 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240806@172809.1386 qu2rjflpkugv91efdfecs98l7m Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66b240998266b24f191f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240806@172809.1577 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.1594 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240806@172809.1628 qu2rjflpkugv91efdfecs98l7m Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240806@172809.1642 qu2rjflpkugv91efdfecs98l7m Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240806@172809.1654 qu2rjflpkugv91efdfecs98l7m Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240806@172809.1665 qu2rjflpkugv91efdfecs98l7m Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240806@172809.1677 qu2rjflpkugv91efdfecs98l7m Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240806@172809.1689 qu2rjflpkugv91efdfecs98l7m Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240806@172809.1701 qu2rjflpkugv91efdfecs98l7m Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66b240998266b24f191f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240806@172809.1938 qu2rjflpkugv91efdfecs98l7m Query : select top 1 fno valor from wsftdata order by fno desc
20240806@172809.1954 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.1970 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240806@172809.1993 qu2rjflpkugv91efdfecs98l7m Query : select 'normal' from dummy
20240806@172809.2008 qu2rjflpkugv91efdfecs98l7m Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66b240998266b24f191f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',227,199510,0,'2024-08-06',39,'euro',0,0,2024 ,?,?)
20240806@172809.2320 qu2rjflpkugv91efdfecs98l7m Query : use flama_phc
20240806@172809.2323 qu2rjflpkugv91efdfecs98l7m Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240806@172809.2348 qu2rjflpkugv91efdfecs98l7m 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.958.00.01'
20240806@172809.2494 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.2510 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172809.2537 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.2610 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172809.2620 qu2rjflpkugv91efdfecs98l7m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172809.2633 qu2rjflpkugv91efdfecs98l7m Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240806@172809.2647 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.2662 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172809.2674 qu2rjflpkugv91efdfecs98l7m Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b243406266b24f1940','aut66b240998266b24f191f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172809.2678 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.2693 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172809.2724 qu2rjflpkugv91efdfecs98l7m Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b243406266b24f1940',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',32.000 ,'aut66b240998266b24f191f' ,0,0 ,2,23.00,10000,?,?,?,?)
20240806@172809.2979 qu2rjflpkugv91efdfecs98l7m Query : use flama_phc
20240806@172809.2982 qu2rjflpkugv91efdfecs98l7m Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240806@172809.3002 qu2rjflpkugv91efdfecs98l7m 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.958.00.01'
20240806@172809.3016 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.3032 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172809.3059 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.3074 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172809.3086 qu2rjflpkugv91efdfecs98l7m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172809.3376 qu2rjflpkugv91efdfecs98l7m Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240806@172809.3445 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.3464 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172809.3476 qu2rjflpkugv91efdfecs98l7m Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b244208666b24f1954','aut66b240998266b24f191f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172809.3480 qu2rjflpkugv91efdfecs98l7m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.3495 qu2rjflpkugv91efdfecs98l7m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172809.3523 qu2rjflpkugv91efdfecs98l7m Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b244208666b24f1954',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66b240998266b24f191f' ,0,0 ,2,23.00,20000,?,?,?,?)
20240806@172809.3934 qu2rjflpkugv91efdfecs98l7m Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66b240998266b24f191f','2405248','wait',39,'adm09112754980.682000002')
20240806@172809.4217 qu2rjflpkugv91efdfecs98l7m Query : use flama_phc
20240806@172809.4220 qu2rjflpkugv91efdfecs98l7m Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240806@172809.4256 qu2rjflpkugv91efdfecs98l7m Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1403';
20240806@172809.4281 qu2rjflpkugv91efdfecs98l7m Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1403';
20240806@172809.4314 qu2rjflpkugv91efdfecs98l7m Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1403';
20240806@172809.4337 qu2rjflpkugv91efdfecs98l7m Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1403';
20240806@172809.6811 cejsd27403vm5p2fca514usg7i Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240806@172809.6822 cejsd27403vm5p2fca514usg7i Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240806@172809.6872 cejsd27403vm5p2fca514usg7i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1404';
20240806@172809.6923 cejsd27403vm5p2fca514usg7i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1404';
20240806@172809.6971 cejsd27403vm5p2fca514usg7i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1404';
20240806@172809.6993 cejsd27403vm5p2fca514usg7i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1404';
20240806@172809.7045 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.7048 cejsd27403vm5p2fca514usg7i Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240806@172809.7113 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.7116 cejsd27403vm5p2fca514usg7i Query : select no, estab,szadrsdesc from szadrs where u_coddest=16
20240806@172809.7198 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172809.7218 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172809.7286 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172809.7306 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172809.7327 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172809.7349 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172809.7369 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172809.7389 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172809.7409 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240806@172809.7428 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240806@172809.7449 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240806@172809.7469 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240806@172809.7627 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240806@172809.7648 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240806@172809.7666 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240806@172809.7801 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240806@172809.7819 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240806@172809.7839 cejsd27403vm5p2fca514usg7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240806@172809.7859 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.7861 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240806@172809.7894 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.7897 cejsd27403vm5p2fca514usg7i Query : select top 1 1 valor from td where td.ndoc = 39
20240806@172809.7925 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.7928 cejsd27403vm5p2fca514usg7i 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')
20240806@172809.7955 cejsd27403vm5p2fca514usg7i 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
20240806@172809.8314 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.8317 cejsd27403vm5p2fca514usg7i Query : select top 1 ~inactivo valor from cl where no = '100327' and estab = 0 order by inactivo desc
20240806@172809.8437 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.8440 cejsd27403vm5p2fca514usg7i Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240806@172809.8473 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.8476 cejsd27403vm5p2fca514usg7i Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240806@172809.8515 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.8517 cejsd27403vm5p2fca514usg7i Query : select szadrsstamp valor from szadrs where szadrsdesc='discoteca juvenil, lda.'
20240806@172809.8563 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.8566 cejsd27403vm5p2fca514usg7i Query : select 1 valor from td where ndoc = 39
20240806@172809.8579 cejsd27403vm5p2fca514usg7i Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240806@172809.8592 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.8608 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240806@172809.8627 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.8642 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240806@172809.8670 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.8685 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240806@172809.8697 cejsd27403vm5p2fca514usg7i Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240806@172809.8767 cejsd27403vm5p2fca514usg7i Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240806@172809.8781 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.8795 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240806@172809.8811 cejsd27403vm5p2fca514usg7i Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240806@172809.8991 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.9006 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240806@172809.9038 cejsd27403vm5p2fca514usg7i Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240806@172809.9050 cejsd27403vm5p2fca514usg7i Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240806@172809.9062 cejsd27403vm5p2fca514usg7i Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240806@172809.9074 cejsd27403vm5p2fca514usg7i Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240806@172809.9086 cejsd27403vm5p2fca514usg7i Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240806@172809.9098 cejsd27403vm5p2fca514usg7i Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240806@172809.9110 cejsd27403vm5p2fca514usg7i Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66b245200666b24f19d4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240806@172809.9350 cejsd27403vm5p2fca514usg7i Query : select top 1 fno valor from wsftdata order by fno desc
20240806@172809.9367 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.9386 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240806@172809.9409 cejsd27403vm5p2fca514usg7i Query : select 'normal' from dummy
20240806@172809.9425 cejsd27403vm5p2fca514usg7i Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66b245200666b24f19d4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',228,100327,0,'2024-08-06',39,'euro',0,0,2024 ,?,?)
20240806@172809.9853 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172809.9856 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172809.9878 cejsd27403vm5p2fca514usg7i 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'
20240806@172809.9893 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.9913 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172809.9941 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172809.9955 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172809.9965 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172809.9979 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172809.9992 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7000 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.2000 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b248639466b24f19f3','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.2400 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4000 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.7000 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b248639466b24f19f3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,10000,?,?,?,?)
20240806@172810.3290 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3450 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.3720 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3860 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.3950 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.4080 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4230 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.4340 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b243017366b24f1a09','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.4380 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4520 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.4800 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b243017366b24f1a09',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,20000,?,?,?)
20240806@172810.7110 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172810.7140 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172810.7330 cejsd27403vm5p2fca514usg7i 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'
20240806@172810.7460 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7610 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.7860 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.8000 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.8090 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.9420 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172810.1046 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.1147 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.1159 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b243601566b24f1a19','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.1164 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.1181 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.1210 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b243601566b24f1a19',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,40000,?,?,?,?)
20240806@172810.1467 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.1482 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.1531 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.1546 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.1555 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.1567 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.1582 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.1594 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b245228866b24f1a26','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.1598 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.1613 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.1640 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b245228866b24f1a26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,50000,?,?,?)
20240806@172810.1896 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172810.1899 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172810.1918 cejsd27403vm5p2fca514usg7i 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'
20240806@172810.1933 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.1948 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.1979 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.1993 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.2002 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.2014 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172810.2026 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2041 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.2054 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b248498366b24f1a31','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.2058 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2072 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.2100 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b248498366b24f1a31',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,70000,?,?,?,?)
20240806@172810.2347 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2364 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.2391 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2408 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.2416 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.2429 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2443 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.2455 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b240593366b24f1a3b','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.2459 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2473 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.2501 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b240593366b24f1a3b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,80000,?,?,?)
20240806@172810.2737 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172810.2741 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172810.2760 cejsd27403vm5p2fca514usg7i 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'
20240806@172810.2774 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2790 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.2815 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2830 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.2838 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.2850 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172810.2863 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2877 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.2888 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b249926666b24f1a45','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.2892 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.2906 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.2934 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b249926666b24f1a45',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,100000,?,?,?,?)
20240806@172810.3179 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3196 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.3222 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3236 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.3245 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.3257 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3271 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.3284 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b240467766b24f1a4f','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.3288 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3302 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.3331 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b240467766b24f1a4f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,110000,?,?,?)
20240806@172810.3615 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172810.3619 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172810.3639 cejsd27403vm5p2fca514usg7i 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'
20240806@172810.3653 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3668 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.3695 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3710 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.3718 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.3731 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172810.3744 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3759 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.3770 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b240338766b24f1a5b','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.3774 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.3789 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.3816 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b240338766b24f1a5b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,130000,?,?,?,?)
20240806@172810.4082 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4099 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.4129 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4146 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.4155 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.4169 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4186 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.4200 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b240318266b24f1a65','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.4204 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4223 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.4254 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b240318266b24f1a65',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,140000,?,?,?)
20240806@172810.4534 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172810.4537 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172810.4558 cejsd27403vm5p2fca514usg7i 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'
20240806@172810.4573 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4590 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.4617 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4633 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.4641 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.4654 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172810.4668 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4686 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.4698 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b240323066b24f1a71','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.4702 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.4717 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.4748 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b240323066b24f1a71',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,160000,?,?,?,?)
20240806@172810.6078 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.6100 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.6130 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.6146 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.6154 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.6168 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.6185 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.6198 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b249237466b24f1a96','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.6203 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.6219 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.6249 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b249237466b24f1a96',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,170000,?,?,?)
20240806@172810.6520 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172810.6523 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172810.6544 cejsd27403vm5p2fca514usg7i 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'
20240806@172810.6562 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.6583 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.6613 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.6630 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.6640 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.6653 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172810.6668 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.6684 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.6697 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b246638866b24f1aa2','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.6702 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.6718 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.6754 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b246638866b24f1aa2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,190000,?,?,?,?)
20240806@172810.7032 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7053 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.7085 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7101 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.7111 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.7125 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7141 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.7154 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b243915866b24f1aad','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.7159 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7178 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.7212 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b243915866b24f1aad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,200000,?,?,?)
20240806@172810.7522 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172810.7526 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172810.7547 cejsd27403vm5p2fca514usg7i 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'
20240806@172810.7561 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7580 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.7612 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7632 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.7642 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.7658 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172810.7673 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7695 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.7709 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b241282366b24f1abb','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.7714 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.7731 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.7765 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b241282366b24f1abb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,220000,?,?,?,?)
20240806@172810.8097 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.8117 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.8151 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.8646 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.9062 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172810.9173 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.9191 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172810.9206 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b247669566b24f1adf','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172810.9213 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172810.9233 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172810.9274 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b247669566b24f1adf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,230000,?,?,?)
20240806@172810.9818 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172810.9823 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240806@172810.9848 cejsd27403vm5p2fca514usg7i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240806@172810.9994 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1200 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.5300 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.7200 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.8400 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.9800 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240806@172811.1140 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1380 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.1560 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b244769666b24f1b02','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.1610 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1810 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.2200 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b244769666b24f1b02',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,250000,?,?,?,?)
20240806@172811.5030 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5230 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.5550 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5730 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.5830 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.5980 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.6140 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.6270 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b243457466b24f1b0e','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.6320 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.6480 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.6820 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b243457466b24f1b0e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,260000,?,?,?)
20240806@172811.9550 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172811.9590 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240806@172811.9820 cejsd27403vm5p2fca514usg7i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240806@172811.9980 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1388 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.1420 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1437 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.1447 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.1461 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240806@172811.1477 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1493 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.1507 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b247354266b24f1b24','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.1511 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1528 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.1559 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b247354266b24f1b24',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,280000,?,?,?,?)
20240806@172811.1849 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1870 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.1905 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1926 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.1937 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.1952 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.1971 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.1986 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b246894066b24f1b2f','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.1991 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.2010 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.2042 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b246894066b24f1b2f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,290000,?,?,?)
20240806@172811.2303 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172811.2307 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240806@172811.2326 cejsd27403vm5p2fca514usg7i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240806@172811.2340 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.2356 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.2383 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.2399 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.2408 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.2435 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240806@172811.2451 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.2467 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.2481 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b246339666b24f1b3b','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.2486 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.2501 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.2532 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b246339666b24f1b3b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,310000,?,?,?,?)
20240806@172811.2926 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.2945 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.2976 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.2992 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.3002 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.3019 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.3034 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.3047 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b241705866b24f1b49','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.3051 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.3066 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.3096 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b241705866b24f1b49',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,320000,?,?,?)
20240806@172811.3367 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172811.3371 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240806@172811.3393 cejsd27403vm5p2fca514usg7i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240806@172811.3553 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.3570 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.3603 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.3619 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.3628 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.3640 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301271100a'
20240806@172811.3654 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.3669 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.3682 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b242491066b24f1b59','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.3686 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.3700 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.3729 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b242491066b24f1b59',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,340000,?,?,?,?)
20240806@172811.3992 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.4010 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.4040 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.4057 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.4070 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.4087 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.4103 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.4117 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b248409666b24f1b63','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.4122 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.4140 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.4170 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b248409666b24f1b63',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,350000,?,?,?)
20240806@172811.4475 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172811.4479 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240806@172811.4500 cejsd27403vm5p2fca514usg7i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240806@172811.4514 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.4533 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.4562 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.4577 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.4586 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.4598 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301271100a'
20240806@172811.4611 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.4627 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.4639 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b248204766b24f1b70','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.4643 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.4659 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.4705 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b248204766b24f1b70',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,370000,?,?,?,?)
20240806@172811.4971 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.4990 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.5016 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5045 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.5054 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.5065 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5082 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.5093 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b241856966b24f1b7b','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.5097 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5112 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.5140 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b241856966b24f1b7b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,380000,?,?,?)
20240806@172811.5394 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172811.5398 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240806@172811.5417 cejsd27403vm5p2fca514usg7i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240806@172811.5431 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5448 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.5473 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5488 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.5497 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.5509 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301271100a'
20240806@172811.5522 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5537 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.5549 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b242657466b24f1b86','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.5553 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5568 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.5597 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b242657466b24f1b86',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,400000,?,?,?,?)
20240806@172811.5853 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5869 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.5902 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5916 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.5928 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.5941 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5956 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.5967 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b243170866b24f1b91','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.5971 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.5987 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.6015 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b243170866b24f1b91',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,410000,?,?,?)
20240806@172811.6270 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172811.6273 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240806@172811.6295 cejsd27403vm5p2fca514usg7i 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.1833.00.2'
20240806@172811.6439 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.6455 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.6484 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.6500 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.6509 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.6524 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240806@172811.6538 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.6554 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.6567 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b246188466b24f1b9f','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.6571 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.6586 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.6617 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b246188466b24f1b9f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,430000,?,?,?,?)
20240806@172811.6866 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172811.6869 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240806@172811.6890 cejsd27403vm5p2fca514usg7i 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.1833.00.2'
20240806@172811.6904 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.6921 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.6948 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.6965 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.6974 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.6987 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240806@172811.7000 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.7018 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.7031 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b245129566b24f1baa','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.7035 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.7051 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.7081 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b245129566b24f1baa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,440000,?,?,?,?)
20240806@172811.7324 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172811.7327 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240806@172811.7350 cejsd27403vm5p2fca514usg7i 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.1833.00.2'
20240806@172811.7365 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.7382 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.7432 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.7447 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.7456 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172811.7473 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301256100a'
20240806@172811.9873 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.9893 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172811.9905 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b241225366b24f1bf1','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172811.9910 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172811.9924 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172811.9952 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b241225366b24f1bf1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,450000,?,?,?,?)
20240806@172812.5600 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172812.5640 cejsd27403vm5p2fca514usg7i Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240806@172812.5850 cejsd27403vm5p2fca514usg7i 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.1833.00.2'
20240806@172812.5990 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6160 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.6410 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6560 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.6640 cejsd27403vm5p2fca514usg7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172812.6770 cejsd27403vm5p2fca514usg7i Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240806@172812.6900 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.7050 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.7170 cejsd27403vm5p2fca514usg7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b249528166b24f1c10','aut66b245200666b24f19d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172812.7220 cejsd27403vm5p2fca514usg7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.7370 cejsd27403vm5p2fca514usg7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.7650 cejsd27403vm5p2fca514usg7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b249528166b24f1c10',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66b245200666b24f19d4' ,0,0 ,2,23.00,460000,?,?,?,?)
20240806@172812.1023 cejsd27403vm5p2fca514usg7i Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66b245200666b24f19d4','2405249','wait',39,'adm09112754980.682000002')
20240806@172812.1102 cejsd27403vm5p2fca514usg7i Query : use flama_phc
20240806@172812.1105 cejsd27403vm5p2fca514usg7i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240806@172812.1136 cejsd27403vm5p2fca514usg7i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1404';
20240806@172812.1160 cejsd27403vm5p2fca514usg7i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1404';
20240806@172812.1196 cejsd27403vm5p2fca514usg7i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1404';
20240806@172812.1220 cejsd27403vm5p2fca514usg7i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1404';
20240806@172812.2872 hmf2hkmmdq086d45lqe512cuqi Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240806@172812.2884 hmf2hkmmdq086d45lqe512cuqi Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240806@172812.2931 hmf2hkmmdq086d45lqe512cuqi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1405';
20240806@172812.2982 hmf2hkmmdq086d45lqe512cuqi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1405';
20240806@172812.3034 hmf2hkmmdq086d45lqe512cuqi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1405';
20240806@172812.3057 hmf2hkmmdq086d45lqe512cuqi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1405';
20240806@172812.3102 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3105 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240806@172812.3168 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3171 hmf2hkmmdq086d45lqe512cuqi Query : select no, estab,szadrsdesc from szadrs where u_coddest=1086
20240806@172812.3253 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172812.3273 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240806@172812.3293 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3296 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240806@172812.3334 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3337 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 1 valor from td where td.ndoc = 39
20240806@172812.3368 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3371 hmf2hkmmdq086d45lqe512cuqi 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')
20240806@172812.3400 hmf2hkmmdq086d45lqe512cuqi 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
20240806@172812.3437 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3441 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 ~inactivo valor from cl where no = '101648' and estab = 0 order by inactivo desc
20240806@172812.3568 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3571 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240806@172812.3605 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3609 hmf2hkmmdq086d45lqe512cuqi Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240806@172812.3653 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3656 hmf2hkmmdq086d45lqe512cuqi Query : select szadrsstamp valor from szadrs where szadrsdesc='adÃo moveis electrodomesticos,lda'
20240806@172812.3703 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.3706 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from td where ndoc = 39
20240806@172812.3718 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240806@172812.3732 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.3749 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240806@172812.3768 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.3784 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240806@172812.3814 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.3831 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240806@172812.3843 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240806@172812.3912 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240806@172812.3927 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.3941 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240806@172812.3959 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66b249007666b24f1c5d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240806@172812.4149 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.4167 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240806@172812.4202 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240806@172812.4214 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240806@172812.4228 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240806@172812.4241 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240806@172812.4252 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240806@172812.4265 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240806@172812.4277 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66b249007666b24f1c5d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240806@172812.4587 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 fno valor from wsftdata order by fno desc
20240806@172812.4605 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.4630 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240806@172812.4659 hmf2hkmmdq086d45lqe512cuqi Query : select 'normal' from dummy
20240806@172812.4676 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66b249007666b24f1c5d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',229,101648,0,'2024-08-06',39,'euro',0,0,2024 ,?,?)
20240806@172812.4999 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.5002 hmf2hkmmdq086d45lqe512cuqi Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172812.5024 hmf2hkmmdq086d45lqe512cuqi 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'
20240806@172812.5040 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.5057 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.5083 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.5098 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.5106 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172812.5118 hmf2hkmmdq086d45lqe512cuqi Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172812.5131 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.5145 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.5157 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b247274466b24f1c7d','aut66b249007666b24f1c5d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172812.5161 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.5176 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.5205 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b247274466b24f1c7d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut66b249007666b24f1c5d' ,0,0 ,2,23.00,10000,?,?,?,?)
20240806@172812.5631 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.5647 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.5673 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.5689 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.5698 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172812.5710 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.5725 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.5737 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b248231166b24f1c8b','aut66b249007666b24f1c5d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172812.5741 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.5755 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.5782 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b248231166b24f1c8b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b249007666b24f1c5d' ,0,0 ,2,23.00,20000,?,?,?)
20240806@172812.6044 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.6082 hmf2hkmmdq086d45lqe512cuqi Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240806@172812.6105 hmf2hkmmdq086d45lqe512cuqi 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'
20240806@172812.6122 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6141 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.6284 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6299 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.6308 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172812.6320 hmf2hkmmdq086d45lqe512cuqi Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240806@172812.6332 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6347 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.6358 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b240206966b24f1c9a','aut66b249007666b24f1c5d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172812.6363 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6377 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.6410 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66b240206966b24f1c9a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66b249007666b24f1c5d' ,0,0 ,2,23.00,40000,?,?,?,?)
20240806@172812.6749 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6765 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.6792 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6807 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.6815 hmf2hkmmdq086d45lqe512cuqi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240806@172812.6828 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6843 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240806@172812.6854 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66b240502066b24f1ca6','aut66b249007666b24f1c5d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240806@172812.6858 hmf2hkmmdq086d45lqe512cuqi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172812.6873 hmf2hkmmdq086d45lqe512cuqi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240806@172812.6902 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66b240502066b24f1ca6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66b249007666b24f1c5d' ,0,0 ,2,23.00,50000,?,?,?)
20240806@172812.7143 hmf2hkmmdq086d45lqe512cuqi Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66b249007666b24f1c5d','2405251','wait',39,'adm09112754980.682000002')
20240806@172812.7229 hmf2hkmmdq086d45lqe512cuqi Query : use flama_phc
20240806@172812.7232 hmf2hkmmdq086d45lqe512cuqi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240806@172812.7261 hmf2hkmmdq086d45lqe512cuqi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1405';
20240806@172812.7287 hmf2hkmmdq086d45lqe512cuqi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1405';
20240806@172812.7325 hmf2hkmmdq086d45lqe512cuqi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1405';
20240806@172812.7350 hmf2hkmmdq086d45lqe512cuqi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1405';
20240806@172812.7910 oe8ls1vsfi8tuejpdmfanms9u4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240806@172812.7922 oe8ls1vsfi8tuejpdmfanms9u4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240806@172812.7972 oe8ls1vsfi8tuejpdmfanms9u4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1406';
20240806@172812.8022 oe8ls1vsfi8tuejpdmfanms9u4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1406';
20240806@172812.8071 oe8ls1vsfi8tuejpdmfanms9u4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1406';
20240806@172812.8096 oe8ls1vsfi8tuejpdmfanms9u4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1406';
20240806@172812.8159 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172812.8163 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240806@172812.8232 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172812.8235 oe8ls1vsfi8tuejpdmfanms9u4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=8962
20240806@172812.8313 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1884.00.1'
20240806@172812.8466 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1905.0001'
20240806@172812.8602 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20240806@172812.8728 oe8ls1vsfi8tuejpdmfanms9u4 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'
20240806@172812.8859 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240806@172812.9016 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1528.00.1'
20240806@172812.9193 oe8ls1vsfi8tuejpdmfanms9u4 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'
20240806@172812.9340 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20240806@172812.9473 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20240806@172812.9592 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2907.00.1'
20240806@172812.9717 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172812.9720 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240806@172812.9750 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172812.9753 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 1 valor from td where td.ndoc = 39
20240806@172813.7200 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172813.7170 oe8ls1vsfi8tuejpdmfanms9u4 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')
20240806@172813.1299 oe8ls1vsfi8tuejpdmfanms9u4 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
20240806@172813.1333 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172813.1336 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 ~inactivo valor from cl where no = '100080' and estab = 0 order by inactivo desc
20240806@172813.1461 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172813.1464 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240806@172813.1496 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172813.1499 oe8ls1vsfi8tuejpdmfanms9u4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240806@172813.1541 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172813.1544 oe8ls1vsfi8tuejpdmfanms9u4 Query : select szadrsstamp valor from szadrs where szadrsdesc='sorefoz - santa iria'
20240806@172813.1591 oe8ls1vsfi8tuejpdmfanms9u4 Query : use flama_phc
20240806@172813.1594 oe8ls1vsfi8tuejpdmfanms9u4 Query : select 1 valor from td where ndoc = 39
20240806@172813.1607 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240806@172813.1622 oe8ls1vsfi8tuejpdmfanms9u4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172813.1638 oe8ls1vsfi8tuejpdmfanms9u4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240806@172813.1659 oe8ls1vsfi8tuejpdmfanms9u4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172813.1674 oe8ls1vsfi8tuejpdmfanms9u4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240806@172813.1704 oe8ls1vsfi8tuejpdmfanms9u4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172813.1719 oe8ls1vsfi8tuejpdmfanms9u4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240806@172813.1733 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240806@172813.1803 oe8ls1vsfi8tuejpdmfanms9u4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240806@172813.1816 oe8ls1vsfi8tuejpdmfanms9u4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240806@172813.1832 oe8ls1vsfi8tuejpdmfanms9u4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240806@172813.1848 oe8ls1vsfi8tuejpdmfanms9u4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66b240247066b24f1d2a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240806@172813.2027 oe8ls1vsfi8tuejpdmfanms9u4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
