20241021@174840.7777 02k6e5l4dve2j3mt961r593qec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174840.7789 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.7806 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174840.7818 02k6e5l4dve2j3mt961r593qec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716865670671685e8be','aut6716897162671685e844' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174840.7823 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.7837 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174840.7865 02k6e5l4dve2j3mt961r593qec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716865670671685e8be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716897162671685e844' ,0,0 ,2,23.00,70000,?,?,?)
20241021@174840.8078 02k6e5l4dve2j3mt961r593qec Query : use flama_phc
20241021@174840.8083 02k6e5l4dve2j3mt961r593qec Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20241021@174840.8102 02k6e5l4dve2j3mt961r593qec Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1608.00.1'
20241021@174840.8117 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.8132 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174840.8159 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.8174 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174840.8183 02k6e5l4dve2j3mt961r593qec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174840.8197 02k6e5l4dve2j3mt961r593qec Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2400237100a'
20241021@174840.8210 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.8225 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174840.8238 02k6e5l4dve2j3mt961r593qec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716818224671685e8c8','aut6716897162671685e844' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174840.8242 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.8257 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174840.8287 02k6e5l4dve2j3mt961r593qec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716818224671685e8c8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6716897162671685e844' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241021@174840.8608 02k6e5l4dve2j3mt961r593qec Query : use flama_phc
20241021@174840.8611 02k6e5l4dve2j3mt961r593qec Query : select st.usalote valor from st where st.ref = '324.939.00.01'
20241021@174840.8632 02k6e5l4dve2j3mt961r593qec 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.939.00.01'
20241021@174840.8761 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.8778 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174840.8808 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.8825 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174840.8836 02k6e5l4dve2j3mt961r593qec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174840.8849 02k6e5l4dve2j3mt961r593qec Query : select sestamp valor from se where ref ='324.939.00.01' and lote = 'r2301371200a'
20241021@174840.8864 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.8879 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174840.8891 02k6e5l4dve2j3mt961r593qec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716826893671685e8d8','aut6716897162671685e844' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174840.8895 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.8910 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174840.8938 02k6e5l4dve2j3mt961r593qec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716826893671685e8d8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6716897162671685e844' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241021@174840.9181 02k6e5l4dve2j3mt961r593qec Query : use flama_phc
20241021@174840.9184 02k6e5l4dve2j3mt961r593qec Query : select st.usalote valor from st where st.ref = '324.939.00.01'
20241021@174840.9210 02k6e5l4dve2j3mt961r593qec 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.939.00.01'
20241021@174840.9228 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.9245 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174840.9273 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.9287 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174840.9297 02k6e5l4dve2j3mt961r593qec Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174840.9309 02k6e5l4dve2j3mt961r593qec Query : select sestamp valor from se where ref ='324.939.00.01' and lote = 'r2301371200a'
20241021@174840.9322 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.9338 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174840.9349 02k6e5l4dve2j3mt961r593qec Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716866147671685e8e3','aut6716897162671685e844' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174840.9353 02k6e5l4dve2j3mt961r593qec Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174840.9368 02k6e5l4dve2j3mt961r593qec Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174840.9396 02k6e5l4dve2j3mt961r593qec Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716866147671685e8e3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6716897162671685e844' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241021@174840.9646 02k6e5l4dve2j3mt961r593qec Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6716897162671685e844','2406848','wait',39,'adm09112754980.682000002')
20241021@174840.9725 02k6e5l4dve2j3mt961r593qec Query : use flama_phc
20241021@174840.9728 02k6e5l4dve2j3mt961r593qec Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241021@174840.9759 02k6e5l4dve2j3mt961r593qec Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2822';
20241021@174840.9793 02k6e5l4dve2j3mt961r593qec Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2822';
20241021@174840.9840 02k6e5l4dve2j3mt961r593qec Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2822';
20241021@174840.9876 02k6e5l4dve2j3mt961r593qec Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2822';
20241021@174841.5710 ngstga4pv15oe0t7437ittgofn Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241021@174841.5840 ngstga4pv15oe0t7437ittgofn Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241021@174841.6450 ngstga4pv15oe0t7437ittgofn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2823';
20241021@174841.7030 ngstga4pv15oe0t7437ittgofn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2823';
20241021@174841.7600 ngstga4pv15oe0t7437ittgofn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2823';
20241021@174841.7900 ngstga4pv15oe0t7437ittgofn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2823';
20241021@174841.8440 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.8470 ngstga4pv15oe0t7437ittgofn Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241021@174841.9100 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.9130 ngstga4pv15oe0t7437ittgofn Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20241021@174841.1004 ngstga4pv15oe0t7437ittgofn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20241021@174841.1024 ngstga4pv15oe0t7437ittgofn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406889 and bi.ref ='304.4320.00.1' and bi.lordem =1
20241021@174841.1342 ngstga4pv15oe0t7437ittgofn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20241021@174841.1466 ngstga4pv15oe0t7437ittgofn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406889 and bi.ref ='324.4751.00.1' and bi.lordem =2
20241021@174841.1785 ngstga4pv15oe0t7437ittgofn 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'
20241021@174841.1806 ngstga4pv15oe0t7437ittgofn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406889 and bi.ref ='324.4970.00.1' and bi.lordem =3
20241021@174841.2127 ngstga4pv15oe0t7437ittgofn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4902.00.1'
20241021@174841.2262 ngstga4pv15oe0t7437ittgofn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406889 and bi.ref ='324.4902.00.1' and bi.lordem =4
20241021@174841.2673 ngstga4pv15oe0t7437ittgofn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20241021@174841.2875 ngstga4pv15oe0t7437ittgofn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406889 and bi.ref ='324.4960.00.1' and bi.lordem =5
20241021@174841.3183 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.3186 ngstga4pv15oe0t7437ittgofn Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241021@174841.3222 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.3225 ngstga4pv15oe0t7437ittgofn Query : select top 1 1 valor from td where td.ndoc = 39
20241021@174841.3255 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.3259 ngstga4pv15oe0t7437ittgofn 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')
20241021@174841.3286 ngstga4pv15oe0t7437ittgofn 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
20241021@174841.3321 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.3324 ngstga4pv15oe0t7437ittgofn Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20241021@174841.3429 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.3433 ngstga4pv15oe0t7437ittgofn Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241021@174841.3462 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.3466 ngstga4pv15oe0t7437ittgofn Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241021@174841.3512 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.3515 ngstga4pv15oe0t7437ittgofn Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20241021@174841.3560 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.3563 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from td where ndoc = 39
20241021@174841.3576 ngstga4pv15oe0t7437ittgofn Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241021@174841.3591 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.3610 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241021@174841.3629 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.3644 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241021@174841.3674 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.3688 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241021@174841.3700 ngstga4pv15oe0t7437ittgofn Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241021@174841.3763 ngstga4pv15oe0t7437ittgofn Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241021@174841.3775 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.3794 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241021@174841.3809 ngstga4pv15oe0t7437ittgofn Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6716829570671685e95a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241021@174841.4094 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.5346 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241021@174841.5384 ngstga4pv15oe0t7437ittgofn Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241021@174841.5396 ngstga4pv15oe0t7437ittgofn Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241021@174841.5408 ngstga4pv15oe0t7437ittgofn Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241021@174841.5420 ngstga4pv15oe0t7437ittgofn Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241021@174841.5433 ngstga4pv15oe0t7437ittgofn Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241021@174841.5445 ngstga4pv15oe0t7437ittgofn Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241021@174841.5456 ngstga4pv15oe0t7437ittgofn Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6716829570671685e95a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241021@174841.5724 ngstga4pv15oe0t7437ittgofn Query : select top 1 fno valor from wsftdata order by fno desc
20241021@174841.5755 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.5770 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241021@174841.5791 ngstga4pv15oe0t7437ittgofn Query : select 'normal' from dummy
20241021@174841.5805 ngstga4pv15oe0t7437ittgofn Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6716829570671685e95a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1414,102253,0,'2024-10-21',39,'euro',0,0,2024 ,?,?)
20241021@174841.6077 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.6080 ngstga4pv15oe0t7437ittgofn Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20241021@174841.6103 ngstga4pv15oe0t7437ittgofn Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20241021@174841.6117 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.6133 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.6158 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.6172 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.6181 ngstga4pv15oe0t7437ittgofn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174841.6192 ngstga4pv15oe0t7437ittgofn Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '241183'
20241021@174841.6205 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.6219 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.6230 ngstga4pv15oe0t7437ittgofn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716843062671685e997','aut6716829570671685e95a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174841.6235 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.6249 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.6276 ngstga4pv15oe0t7437ittgofn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716843062671685e997',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',32.000 ,'aut6716829570671685e95a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241021@174841.6526 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.6530 ngstga4pv15oe0t7437ittgofn Query : select st.usalote valor from st where st.ref = '324.4751.00.1'
20241021@174841.6550 ngstga4pv15oe0t7437ittgofn 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.4751.00.1'
20241021@174841.6674 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.6690 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.6715 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.6729 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.6737 ngstga4pv15oe0t7437ittgofn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174841.6749 ngstga4pv15oe0t7437ittgofn Query : select sestamp valor from se where ref ='324.4751.00.1' and lote = 'r2400049200a'
20241021@174841.6771 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.6788 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.6799 ngstga4pv15oe0t7437ittgofn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716819520671685e9a5','aut6716829570671685e95a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174841.6803 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.6817 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.6844 ngstga4pv15oe0t7437ittgofn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716819520671685e9a5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6716829570671685e95a' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241021@174841.7066 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.7072 ngstga4pv15oe0t7437ittgofn Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20241021@174841.7092 ngstga4pv15oe0t7437ittgofn 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.4970.00.1'
20241021@174841.7106 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.7121 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.7146 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.7160 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.7168 ngstga4pv15oe0t7437ittgofn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174841.7180 ngstga4pv15oe0t7437ittgofn Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400492200a'
20241021@174841.7193 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.7207 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.7218 ngstga4pv15oe0t7437ittgofn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716833851671685e9af','aut6716829570671685e95a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174841.7222 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.7238 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.7269 ngstga4pv15oe0t7437ittgofn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716833851671685e9af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6716829570671685e95a' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241021@174841.7498 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.7501 ngstga4pv15oe0t7437ittgofn Query : select st.usalote valor from st where st.ref = '324.4902.00.1'
20241021@174841.7524 ngstga4pv15oe0t7437ittgofn 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.4902.00.1'
20241021@174841.7656 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.7673 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.7697 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.7712 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.7720 ngstga4pv15oe0t7437ittgofn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174841.7732 ngstga4pv15oe0t7437ittgofn Query : select sestamp valor from se where ref ='324.4902.00.1' and lote = 'r2400145200a'
20241021@174841.7745 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.7760 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.7776 ngstga4pv15oe0t7437ittgofn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716835999671685e9bd','aut6716829570671685e95a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174841.7780 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.7794 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.7823 ngstga4pv15oe0t7437ittgofn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716835999671685e9bd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6716829570671685e95a' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241021@174841.8050 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.8066 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.8117 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.8132 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.8142 ngstga4pv15oe0t7437ittgofn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174841.8155 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.8170 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.8182 ngstga4pv15oe0t7437ittgofn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716804638671685e9c7','aut6716829570671685e95a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174841.8187 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.8205 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.8237 ngstga4pv15oe0t7437ittgofn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716804638671685e9c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716829570671685e95a' ,0,0 ,2,23.00,50000,?,?,?)
20241021@174841.8479 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.8486 ngstga4pv15oe0t7437ittgofn Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20241021@174841.8507 ngstga4pv15oe0t7437ittgofn Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20241021@174841.8635 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.8652 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.8678 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.8693 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.8702 ngstga4pv15oe0t7437ittgofn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174841.8714 ngstga4pv15oe0t7437ittgofn Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20241021@174841.8728 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.8743 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174841.8755 ngstga4pv15oe0t7437ittgofn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716833826671685e9d5','aut6716829570671685e95a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174841.8760 ngstga4pv15oe0t7437ittgofn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174841.8774 ngstga4pv15oe0t7437ittgofn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174841.8802 ngstga4pv15oe0t7437ittgofn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716833826671685e9d5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6716829570671685e95a' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241021@174841.9031 ngstga4pv15oe0t7437ittgofn Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6716829570671685e95a','2406889','wait',39,'adm09112754980.682000002')
20241021@174841.9106 ngstga4pv15oe0t7437ittgofn Query : use flama_phc
20241021@174841.9109 ngstga4pv15oe0t7437ittgofn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241021@174841.9143 ngstga4pv15oe0t7437ittgofn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2823';
20241021@174841.9178 ngstga4pv15oe0t7437ittgofn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2823';
20241021@174841.9223 ngstga4pv15oe0t7437ittgofn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2823';
20241021@174841.9251 ngstga4pv15oe0t7437ittgofn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2823';
20241021@174841.9860 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241021@174841.9871 n1rfcl7tb7qov9v0ojjcprs3gv Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241021@174841.9934 n1rfcl7tb7qov9v0ojjcprs3gv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2824';
20241021@174841.9995 n1rfcl7tb7qov9v0ojjcprs3gv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2824';
20241021@174842.5600 n1rfcl7tb7qov9v0ojjcprs3gv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2824';
20241021@174842.8400 n1rfcl7tb7qov9v0ojjcprs3gv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2824';
20241021@174842.1350 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.1380 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241021@174842.1990 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.2020 n1rfcl7tb7qov9v0ojjcprs3gv Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20241021@174842.2460 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241021@174842.2650 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406890 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241021@174842.5980 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241021@174842.6180 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406890 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241021@174842.6370 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.6400 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241021@174842.6750 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.6780 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 1 valor from td where td.ndoc = 39
20241021@174842.7090 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.7120 n1rfcl7tb7qov9v0ojjcprs3gv 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')
20241021@174842.7400 n1rfcl7tb7qov9v0ojjcprs3gv 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
20241021@174842.7750 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.7770 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20241021@174842.8080 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.8110 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241021@174842.8420 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.8440 n1rfcl7tb7qov9v0ojjcprs3gv Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241021@174842.8860 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.8890 n1rfcl7tb7qov9v0ojjcprs3gv Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20241021@174842.1000 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.1003 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from td where ndoc = 39
20241021@174842.1018 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241021@174842.1032 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.1050 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241021@174842.1071 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.1085 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241021@174842.1112 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.1126 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241021@174842.1138 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241021@174842.1201 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241021@174842.1214 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.1229 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241021@174842.1248 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6716893112671685ea1b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241021@174842.1401 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.1416 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241021@174842.1448 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241021@174842.1460 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241021@174842.1473 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241021@174842.1484 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241021@174842.1496 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241021@174842.1508 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241021@174842.1521 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6716893112671685ea1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241021@174842.1728 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 fno valor from wsftdata order by fno desc
20241021@174842.1751 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.1773 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241021@174842.1799 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 'normal' from dummy
20241021@174842.1814 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6716893112671685ea1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1415,102253,0,'2024-10-21',39,'euro',0,0,2024 ,?,?)
20241021@174842.3071 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.3076 n1rfcl7tb7qov9v0ojjcprs3gv Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241021@174842.3099 n1rfcl7tb7qov9v0ojjcprs3gv 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.1834.00.1'
20241021@174842.3117 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.3135 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.3161 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.3177 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.3186 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174842.3197 n1rfcl7tb7qov9v0ojjcprs3gv Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241021@174842.3210 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.3231 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.3244 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716841702671685ea4e','aut6716893112671685ea1b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174842.3250 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.3264 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.3292 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716841702671685ea4e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6716893112671685ea1b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241021@174842.3723 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.3740 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.3767 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.3782 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.3791 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174842.3804 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.3820 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.3832 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716877811671685ea5c','aut6716893112671685ea1b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174842.3836 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.3853 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.3882 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716877811671685ea5c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716893112671685ea1b' ,0,0 ,2,23.00,20000,?,?,?)
20241021@174842.4110 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.4113 n1rfcl7tb7qov9v0ojjcprs3gv Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241021@174842.4142 n1rfcl7tb7qov9v0ojjcprs3gv 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.1834.00.1'
20241021@174842.4156 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.4173 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.4198 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.4214 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.4223 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174842.4236 n1rfcl7tb7qov9v0ojjcprs3gv Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241021@174842.4249 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.4267 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.4279 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716818822671685ea67','aut6716893112671685ea1b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174842.4283 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.4297 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.4325 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716818822671685ea67',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6716893112671685ea1b' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241021@174842.4552 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.4568 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.4594 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.4608 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.4617 n1rfcl7tb7qov9v0ojjcprs3gv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174842.4629 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.4644 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.4655 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716815855671685ea71','aut6716893112671685ea1b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174842.4660 n1rfcl7tb7qov9v0ojjcprs3gv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.4675 n1rfcl7tb7qov9v0ojjcprs3gv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.4705 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716815855671685ea71',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716893112671685ea1b' ,0,0 ,2,23.00,50000,?,?,?)
20241021@174842.4935 n1rfcl7tb7qov9v0ojjcprs3gv Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6716893112671685ea1b','2406890','wait',39,'adm09112754980.682000002')
20241021@174842.5006 n1rfcl7tb7qov9v0ojjcprs3gv Query : use flama_phc
20241021@174842.5010 n1rfcl7tb7qov9v0ojjcprs3gv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241021@174842.5040 n1rfcl7tb7qov9v0ojjcprs3gv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2824';
20241021@174842.5075 n1rfcl7tb7qov9v0ojjcprs3gv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2824';
20241021@174842.5119 n1rfcl7tb7qov9v0ojjcprs3gv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2824';
20241021@174842.5147 n1rfcl7tb7qov9v0ojjcprs3gv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2824';
20241021@174842.6072 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241021@174842.6083 9jd8u4bo8i71gv8c6p57kabmtr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241021@174842.6151 9jd8u4bo8i71gv8c6p57kabmtr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2825';
20241021@174842.6206 9jd8u4bo8i71gv8c6p57kabmtr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2825';
20241021@174842.6270 9jd8u4bo8i71gv8c6p57kabmtr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2825';
20241021@174842.6392 9jd8u4bo8i71gv8c6p57kabmtr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2825';
20241021@174842.6451 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.6454 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241021@174842.6520 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.6523 9jd8u4bo8i71gv8c6p57kabmtr Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241021@174842.6564 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.6586 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =1
20241021@174842.7027 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7049 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =1
20241021@174842.7066 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7086 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =1
20241021@174842.7104 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7128 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7427 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7449 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7467 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7487 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7504 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7524 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7540 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7560 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7578 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7599 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7616 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7636 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7653 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7672 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7689 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7709 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7725 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7745 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7761 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241021@174842.7783 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406892 and bi.ref ='324.692.00.01' and bi.lordem =2
20241021@174842.7802 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.7805 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241021@174842.7840 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.7843 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 1 valor from td where td.ndoc = 39
20241021@174842.7874 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.7877 9jd8u4bo8i71gv8c6p57kabmtr 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')
20241021@174842.7905 9jd8u4bo8i71gv8c6p57kabmtr 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
20241021@174842.7939 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.7942 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241021@174842.7971 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.7974 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241021@174842.8006 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.8011 9jd8u4bo8i71gv8c6p57kabmtr Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241021@174842.8050 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.8053 9jd8u4bo8i71gv8c6p57kabmtr Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241021@174842.8097 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.8100 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from td where ndoc = 39
20241021@174842.8112 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241021@174842.8126 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.8146 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241021@174842.8166 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.8181 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241021@174842.8209 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.8224 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241021@174842.8247 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241021@174842.8316 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241021@174842.8329 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.8345 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241021@174842.8361 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241021@174842.8516 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.8532 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241021@174842.8565 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241021@174842.8577 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241021@174842.8589 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241021@174842.8601 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241021@174842.8613 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241021@174842.8625 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241021@174842.8636 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6716816493671685eac9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241021@174842.8865 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 fno valor from wsftdata order by fno desc
20241021@174842.8888 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.8906 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241021@174842.8933 9jd8u4bo8i71gv8c6p57kabmtr Query : select 'normal' from dummy
20241021@174842.8950 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6716816493671685eac9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1416,100810,0,'2024-10-21',39,'euro',0,0,2024 ,?,?)
20241021@174842.9200 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174842.9203 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174842.9225 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174842.9239 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.9255 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.9284 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.9299 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.9308 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174842.9324 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174842.9336 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.9351 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.9363 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716891164671685eae3','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174842.9367 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.9383 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.9412 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716891164671685eae3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241021@174842.9643 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.9660 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.9688 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.9703 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.9711 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174842.9724 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.9738 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174842.9750 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716830540671685eaed','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174842.9754 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174842.9769 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174842.9800 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716830540671685eaed',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,20000,?,?,?)
20241021@174843.1800 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.2400 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.4400 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.8500 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1010 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.1290 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1440 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.1530 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.1650 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.1770 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1920 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.2040 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716897591671685eb04','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.2080 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.2230 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.2520 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716897591671685eb04',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241021@174843.4930 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5130 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.5440 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5600 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.5690 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.5820 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5960 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.6080 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716875538671685eb0e','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.6120 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6270 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.6560 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716875538671685eb0e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,50000,?,?,?)
20241021@174843.8820 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.8880 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.9070 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.9220 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9370 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.9630 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9780 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.9870 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.9990 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.1013 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1028 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.1040 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716868738671685eb18','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.1044 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1059 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.1087 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716868738671685eb18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241021@174843.1330 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1346 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.1371 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1385 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.1394 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.1406 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1420 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.1433 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716881281671685eb22','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.1441 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1456 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.1487 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716881281671685eb22',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,80000,?,?,?)
20241021@174843.1717 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.1720 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.1740 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.1754 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1773 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.1799 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1814 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.1826 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.1837 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.1850 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1865 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.1877 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716808698671685eb2d','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.1881 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.1895 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.1924 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716808698671685eb2d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241021@174843.2160 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.2176 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.2202 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.2217 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.2225 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.2238 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.2253 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.2265 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716804758671685eb36','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.2270 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.2284 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.2313 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716804758671685eb36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,110000,?,?,?)
20241021@174843.2547 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.2551 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.2570 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.2584 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.2600 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.2626 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.2641 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.2649 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.2668 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.2681 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.2697 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.2709 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716827916671685eb41','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.2713 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.3915 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.3949 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716827916671685eb41',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241021@174843.4250 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.4271 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.4301 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.4317 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.4326 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.4340 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.4355 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.4369 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716898884671685eb69','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.4373 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.4388 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.4418 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716898884671685eb69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,140000,?,?,?)
20241021@174843.4660 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.4663 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.4685 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.4699 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.4717 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.4744 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.4760 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.4774 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.4786 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.4800 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.4815 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.4827 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716865482671685eb75','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.4832 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.4847 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.4878 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716865482671685eb75',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241021@174843.5125 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5143 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.5169 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5184 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.5193 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.5207 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5223 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.5236 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716886704671685eb7f','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.5240 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5255 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.5284 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716886704671685eb7f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,170000,?,?,?)
20241021@174843.5524 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.5527 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.5548 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.5562 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5584 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.5612 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5628 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.5637 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.5652 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.5665 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5680 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.5692 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716834915671685eb8a','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.5696 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5712 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.5745 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716834915671685eb8a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241021@174843.5982 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.5998 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.6027 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6043 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.6052 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.6065 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6079 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.6091 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716868662671685eb94','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.6095 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6111 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.6145 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716868662671685eb94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,200000,?,?,?)
20241021@174843.6397 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.6400 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.6421 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.6435 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6451 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.6476 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6491 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.6499 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.6511 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.6524 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6539 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.6550 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716882695671685eb9f','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.6555 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6570 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.6598 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716882695671685eb9f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241021@174843.6838 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6855 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.6882 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6897 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.6907 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.6919 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6934 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.6946 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716827194671685eba8','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.6951 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.6966 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.6994 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716827194671685eba8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,230000,?,?,?)
20241021@174843.7228 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.7231 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.7255 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.7269 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.7285 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.7312 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.7327 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.7335 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.7349 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.7365 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.7380 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.7392 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716885414671685ebb3','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.7397 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.7411 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.7440 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716885414671685ebb3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20241021@174843.7683 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.7700 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.7729 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.7744 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.7753 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.7766 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.7781 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.7793 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716838927671685ebbd','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.7797 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.7813 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.7846 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716838927671685ebbd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,260000,?,?,?)
20241021@174843.8128 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.8132 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.8154 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.8170 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.8189 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.8222 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.8238 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.8249 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.8262 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.8275 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.8290 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.8302 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716879287671685ebca','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.8307 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.8321 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.8351 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716879287671685ebca',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,280000,?,?,?,?,?)
20241021@174843.8589 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.8606 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.8632 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.8648 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.8657 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.8669 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.8683 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.8695 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716838143671685ebd3','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.8699 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.8714 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.8742 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716838143671685ebd3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,290000,?,?,?)
20241021@174843.8953 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.8957 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.8976 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.8989 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9005 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.9030 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9045 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.9054 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.9066 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.9078 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9093 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.9105 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716885338671685ebdd','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.9109 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9123 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.9152 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716885338671685ebdd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,310000,?,?,?,?,?)
20241021@174843.9380 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9397 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.9424 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9439 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.9447 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.9464 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9478 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.9489 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716872017671685ebe7','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.9495 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9510 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.9543 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6716872017671685ebe7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,320000,?,?,?)
20241021@174843.9764 9jd8u4bo8i71gv8c6p57kabmtr Query : use flama_phc
20241021@174843.9767 9jd8u4bo8i71gv8c6p57kabmtr Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241021@174843.9798 9jd8u4bo8i71gv8c6p57kabmtr 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.692.00.01'
20241021@174843.9811 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9836 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174843.9863 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9878 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.9887 9jd8u4bo8i71gv8c6p57kabmtr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241021@174843.9899 9jd8u4bo8i71gv8c6p57kabmtr Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241021@174843.9912 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9927 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241021@174843.9939 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6716836486671685ebf2','aut6716816493671685eac9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241021@174843.9953 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174843.9968 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241021@174844.4000 9jd8u4bo8i71gv8c6p57kabmtr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6716836486671685ebf2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6716816493671685eac9' ,0,0 ,2,23.00,340000,?,?,?,?,?)
20241021@174844.2270 9jd8u4bo8i71gv8c6p57kabmtr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241021@174844.2420 9jd8u4bo8i71gv8c6p57kabmtr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
