20241015@173808.6608 58cikqcmn9h25ptbqdpoua2n0i Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241015@173808.6671 58cikqcmn9h25ptbqdpoua2n0i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2672';
20241015@173808.6730 58cikqcmn9h25ptbqdpoua2n0i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2672';
20241015@173808.6787 58cikqcmn9h25ptbqdpoua2n0i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2672';
20241015@173808.6816 58cikqcmn9h25ptbqdpoua2n0i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2672';
20241015@173808.6876 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173808.6880 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241015@173808.6961 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173808.6965 58cikqcmn9h25ptbqdpoua2n0i Query : select no, estab,szadrsdesc from szadrs where u_coddest=2448
20241015@173808.7062 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20241015@173808.7180 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='304.422.00.07' and bi.lordem =1
20241015@173808.7474 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2357.00.1'
20241015@173808.7582 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='324.2357.00.1' and bi.lordem =2
20241015@173808.7855 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241015@173808.7961 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='324.2362.00.1' and bi.lordem =3
20241015@173808.8254 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241015@173808.8274 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='324.2362.00.1' and bi.lordem =3
20241015@173808.8291 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20241015@173808.8400 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='324.5342.00.1' and bi.lordem =4
20241015@173808.8717 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20241015@173808.8837 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='324.5343.00.1' and bi.lordem =5
20241015@173808.9139 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241015@173808.9251 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='324.2326.00.1' and bi.lordem =6
20241015@173808.9542 58cikqcmn9h25ptbqdpoua2n0i 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'
20241015@173808.9661 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='324.4960.00.1' and bi.lordem =7
20241015@173808.9945 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.969.00.01'
20241015@173809.5100 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='324.969.00.01' and bi.lordem =8
20241015@173809.3330 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4961.00.1'
20241015@173809.4370 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406752 and bi.ref ='324.4961.00.1' and bi.lordem =9
20241015@173809.7130 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.7160 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241015@173809.7490 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.7520 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 1 valor from td where td.ndoc = 39
20241015@173809.7810 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.7840 58cikqcmn9h25ptbqdpoua2n0i 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')
20241015@173809.8130 58cikqcmn9h25ptbqdpoua2n0i 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
20241015@173809.8480 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.8510 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 ~inactivo valor from cl where no = '101889' and estab = 0 order by inactivo desc
20241015@173809.9680 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.9710 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241015@173809.1001 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.1004 58cikqcmn9h25ptbqdpoua2n0i Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241015@173809.1043 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.1046 58cikqcmn9h25ptbqdpoua2n0i Query : select szadrsstamp valor from szadrs where szadrsdesc='cooplecnorte,crl'
20241015@173809.1091 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.1093 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from td where ndoc = 39
20241015@173809.1105 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241015@173809.1119 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.1136 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241015@173809.1155 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.1171 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241015@173809.1201 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.1215 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241015@173809.1227 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241015@173809.1290 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241015@173809.1303 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.1317 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241015@173809.1332 58cikqcmn9h25ptbqdpoua2n0i Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670e955853670e9a711d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241015@173809.1476 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.1494 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241015@173809.1526 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241015@173809.1538 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241015@173809.1550 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241015@173809.1564 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241015@173809.1576 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241015@173809.1590 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241015@173809.1601 58cikqcmn9h25ptbqdpoua2n0i Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670e955853670e9a711d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241015@173809.1805 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 fno valor from wsftdata order by fno desc
20241015@173809.1827 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.1842 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241015@173809.1864 58cikqcmn9h25ptbqdpoua2n0i Query : select 'normal' from dummy
20241015@173809.1878 58cikqcmn9h25ptbqdpoua2n0i Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670e955853670e9a711d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1284,101889,0,'2024-10-15',39,'euro',0,0,2024 ,?,?)
20241015@173809.2112 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.2115 58cikqcmn9h25ptbqdpoua2n0i Query : select st.usalote valor from st where st.ref = '304.422.00.07'
20241015@173809.2139 58cikqcmn9h25ptbqdpoua2n0i 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.422.00.07'
20241015@173809.2251 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.2269 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.2302 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.2320 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.2331 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173809.2347 58cikqcmn9h25ptbqdpoua2n0i Query : select sestamp valor from se where ref ='304.422.00.07' and lote = '241004'
20241015@173809.2376 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.2409 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.2424 58cikqcmn9h25ptbqdpoua2n0i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e940656670e9a713a','aut670e955853670e9a711d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173809.2429 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.2448 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.2572 58cikqcmn9h25ptbqdpoua2n0i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e940656670e9a713a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut670e955853670e9a711d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241015@173809.2891 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.3022 58cikqcmn9h25ptbqdpoua2n0i Query : select st.usalote valor from st where st.ref = '324.2357.00.1'
20241015@173809.3128 58cikqcmn9h25ptbqdpoua2n0i 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.2357.00.1'
20241015@173809.3250 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.3267 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.3295 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.3313 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.3323 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173809.3338 58cikqcmn9h25ptbqdpoua2n0i Query : select sestamp valor from se where ref ='324.2357.00.1' and lote = 'r2200239100a'
20241015@173809.3360 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.3376 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.3389 58cikqcmn9h25ptbqdpoua2n0i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e925542670e9a7152','aut670e955853670e9a711d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173809.3393 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.3408 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.3435 58cikqcmn9h25ptbqdpoua2n0i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e925542670e9a7152',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut670e955853670e9a711d' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241015@173809.3658 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.3662 58cikqcmn9h25ptbqdpoua2n0i Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20241015@173809.3683 58cikqcmn9h25ptbqdpoua2n0i 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.2362.00.1'
20241015@173809.3796 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.3812 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.3837 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.3851 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.3859 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173809.3871 58cikqcmn9h25ptbqdpoua2n0i Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = '324.2362.00.1'
20241015@173809.3880 58cikqcmn9h25ptbqdpoua2n0i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.3894 58cikqcmn9h25ptbqdpoua2n0i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.3905 58cikqcmn9h25ptbqdpoua2n0i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e908030670e9a715e','aut670e955853670e9a711d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173809.3922 58cikqcmn9h25ptbqdpoua2n0i Query : use flama_phc
20241015@173809.3925 58cikqcmn9h25ptbqdpoua2n0i Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241015@173809.3980 58cikqcmn9h25ptbqdpoua2n0i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2672';
20241015@173809.4012 58cikqcmn9h25ptbqdpoua2n0i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2672';
20241015@173809.5183 gk2fp4cai3pvmib5ojtvrq847d Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241015@173809.5194 gk2fp4cai3pvmib5ojtvrq847d Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241015@173809.5253 gk2fp4cai3pvmib5ojtvrq847d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2673';
20241015@173809.5312 gk2fp4cai3pvmib5ojtvrq847d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2673';
20241015@173809.5375 gk2fp4cai3pvmib5ojtvrq847d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2673';
20241015@173809.5415 gk2fp4cai3pvmib5ojtvrq847d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2673';
20241015@173809.5476 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.5480 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241015@173809.5540 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.5543 gk2fp4cai3pvmib5ojtvrq847d Query : select no, estab,szadrsdesc from szadrs where u_coddest=2679
20241015@173809.5619 gk2fp4cai3pvmib5ojtvrq847d 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'
20241015@173809.5733 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406753 and bi.ref ='324.692.00.01' and bi.lordem =1
20241015@173809.6027 gk2fp4cai3pvmib5ojtvrq847d 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'
20241015@173809.6048 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406753 and bi.ref ='324.692.00.01' and bi.lordem =2
20241015@173809.6339 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.6343 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241015@173809.6378 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.6381 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 1 valor from td where td.ndoc = 39
20241015@173809.6414 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.6417 gk2fp4cai3pvmib5ojtvrq847d 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')
20241015@173809.6445 gk2fp4cai3pvmib5ojtvrq847d 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
20241015@173809.6480 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.6483 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 ~inactivo valor from cl where no = '199525' and estab = 0 order by inactivo desc
20241015@173809.6577 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.6581 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241015@173809.6613 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.6616 gk2fp4cai3pvmib5ojtvrq847d Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241015@173809.6655 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.6658 gk2fp4cai3pvmib5ojtvrq847d Query : select szadrsstamp valor from szadrs where szadrsdesc='euroilhas - soc.com.representaÇÕes,lda'
20241015@173809.6704 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.6707 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from td where ndoc = 39
20241015@173809.6720 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241015@173809.6734 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.6752 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241015@173809.6771 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.6785 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241015@173809.6814 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.6829 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241015@173809.6841 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241015@173809.6906 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241015@173809.6919 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.6933 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241015@173809.6948 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670e911901670e9a71a7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241015@173809.7093 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.7109 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241015@173809.7141 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241015@173809.7153 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241015@173809.7165 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241015@173809.7176 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241015@173809.7188 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241015@173809.7199 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241015@173809.7210 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670e911901670e9a71a7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241015@173809.7406 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 fno valor from wsftdata order by fno desc
20241015@173809.7428 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.7443 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241015@173809.7472 gk2fp4cai3pvmib5ojtvrq847d Query : select 'normal' from dummy
20241015@173809.7485 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670e911901670e9a71a7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1284,199525,0,'2024-10-15',39,'euro',0,0,2024 ,?,?)
20241015@173809.7719 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.7722 gk2fp4cai3pvmib5ojtvrq847d Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241015@173809.7744 gk2fp4cai3pvmib5ojtvrq847d 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'
20241015@173809.7862 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.7876 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.7900 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.7914 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.7923 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173809.7935 gk2fp4cai3pvmib5ojtvrq847d Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241015@173809.7956 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.7970 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.7985 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e932064670e9a71c2','aut670e911901670e9a71a7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173809.7991 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.8006 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.8035 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e932064670e9a71c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut670e911901670e9a71a7' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241015@173809.8260 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.8275 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.8300 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.8316 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.8325 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173809.8338 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.8352 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.8363 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e920448670e9a71cb','aut670e911901670e9a71a7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173809.8367 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.8381 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.8415 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670e920448670e9a71cb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670e911901670e9a71a7' ,0,0 ,2,23.00,20000,?,?,?)
20241015@173809.8644 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.8647 gk2fp4cai3pvmib5ojtvrq847d Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241015@173809.8668 gk2fp4cai3pvmib5ojtvrq847d 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'
20241015@173809.8685 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.8702 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.8728 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.8745 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.8753 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173809.8765 gk2fp4cai3pvmib5ojtvrq847d Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241015@173809.8777 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.8792 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.8804 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e901906670e9a71d6','aut670e911901670e9a71a7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173809.8808 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.8822 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.8851 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e901906670e9a71d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut670e911901670e9a71a7' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241015@173809.9076 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.9093 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.9119 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.9134 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.9143 gk2fp4cai3pvmib5ojtvrq847d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173809.9155 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.9169 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173809.9181 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e925430670e9a71df','aut670e911901670e9a71a7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173809.9185 gk2fp4cai3pvmib5ojtvrq847d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173809.9200 gk2fp4cai3pvmib5ojtvrq847d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173809.9229 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670e925430670e9a71df',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670e911901670e9a71a7' ,0,0 ,2,23.00,50000,?,?,?)
20241015@173809.9432 gk2fp4cai3pvmib5ojtvrq847d Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670e911901670e9a71a7','2406753','wait',39,'adm09112754980.682000002')
20241015@173809.9505 gk2fp4cai3pvmib5ojtvrq847d Query : use flama_phc
20241015@173809.9509 gk2fp4cai3pvmib5ojtvrq847d Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241015@173809.9540 gk2fp4cai3pvmib5ojtvrq847d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2673';
20241015@173809.9574 gk2fp4cai3pvmib5ojtvrq847d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2673';
20241015@173809.9620 gk2fp4cai3pvmib5ojtvrq847d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2673';
20241015@173809.9647 gk2fp4cai3pvmib5ojtvrq847d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2673';
20241015@173810.8900 dcgr3s4dh70kauggn6tv7kns0a Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241015@173810.9720 dcgr3s4dh70kauggn6tv7kns0a Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241015@173810.1444 dcgr3s4dh70kauggn6tv7kns0a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2674';
20241015@173810.1781 dcgr3s4dh70kauggn6tv7kns0a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2674';
20241015@173810.2126 dcgr3s4dh70kauggn6tv7kns0a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2674';
20241015@173810.2237 dcgr3s4dh70kauggn6tv7kns0a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2674';
20241015@173810.2597 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173810.2639 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241015@173810.2976 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173810.3017 dcgr3s4dh70kauggn6tv7kns0a Query : select no, estab,szadrsdesc from szadrs where u_coddest=315
20241015@173810.4288 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241015@173810.4999 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2301.00.3' and bi.lordem =1
20241015@173810.7473 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241015@173810.7945 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2330.00.1' and bi.lordem =2
20241015@173810.8683 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2357.00.1'
20241015@173810.8972 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2357.00.1' and bi.lordem =3
20241015@173810.9784 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241015@173811.1530 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2362.00.1' and bi.lordem =4
20241015@173811.9800 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2366.00.1'
20241015@173811.1402 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2366.00.1' and bi.lordem =5
20241015@173811.2129 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241015@173811.2438 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2335.00.1' and bi.lordem =6
20241015@173811.3282 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241015@173811.4504 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2335.00.1' and bi.lordem =6
20241015@173811.4711 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20241015@173811.5457 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.1608.00.1' and bi.lordem =7
20241015@173811.6230 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2300.00.1'
20241015@173811.6567 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2300.00.1' and bi.lordem =8
20241015@173811.7349 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2318.00.1'
20241015@173811.7823 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2318.00.1' and bi.lordem =9
20241015@173811.8552 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1317.00.1'
20241015@173811.9040 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.1317.00.1' and bi.lordem =10
20241015@173811.9774 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2334.00.1'
20241015@173812.2430 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2334.00.1' and bi.lordem =11
20241015@173812.1172 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241015@173812.1226 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2326.00.1' and bi.lordem =12
20241015@173812.2246 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2317.00.1'
20241015@173812.2709 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2317.00.1' and bi.lordem =13
20241015@173812.3441 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.2315.00.1'
20241015@173812.3904 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='304.2315.00.1' and bi.lordem =14
20241015@173812.4975 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20241015@173812.5437 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.2388.00.1' and bi.lordem =15
20241015@173812.7762 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1332.00.1'
20241015@173812.8232 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.1332.00.1' and bi.lordem =16
20241015@173812.9007 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1332.00.1'
20241015@173812.9404 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406755 and bi.ref ='324.1332.00.1' and bi.lordem =16
20241015@173812.9737 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173812.9780 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241015@173813.4750 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173813.5160 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 1 valor from td where td.ndoc = 39
20241015@173813.8790 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173813.1005 dcgr3s4dh70kauggn6tv7kns0a 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')
20241015@173813.1491 dcgr3s4dh70kauggn6tv7kns0a 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
20241015@173813.1944 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173813.1986 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 ~inactivo valor from cl where no = '100404' and estab = 0 order by inactivo desc
20241015@173813.2462 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173813.2503 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241015@173813.2875 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173813.2916 dcgr3s4dh70kauggn6tv7kns0a Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241015@173813.3368 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173813.3410 dcgr3s4dh70kauggn6tv7kns0a Query : select szadrsstamp valor from szadrs where szadrsdesc='euroilhas - soc. com.de. representacoes,lda'
20241015@173813.4894 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173813.4936 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from td where ndoc = 39
20241015@173813.5187 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241015@173813.5476 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173813.5727 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241015@173813.6139 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173813.6392 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241015@173813.6602 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173813.6854 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241015@173813.6922 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241015@173813.7177 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241015@173813.7575 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173813.8027 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241015@173813.8547 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241015@173813.8918 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173813.9414 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241015@173814.1160 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241015@173814.3220 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241015@173814.5280 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241015@173814.7340 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241015@173814.9390 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241015@173814.1282 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241015@173814.1497 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670e967602670e9a75a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241015@173814.1953 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 fno valor from wsftdata order by fno desc
20241015@173814.2210 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173814.2461 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241015@173814.2930 dcgr3s4dh70kauggn6tv7kns0a Query : select 'normal' from dummy
20241015@173814.3222 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670e967602670e9a75a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1285,100404,0,'2024-10-15',39,'euro',0,0,2024 ,?,?)
20241015@173814.3781 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173814.3822 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241015@173814.3931 dcgr3s4dh70kauggn6tv7kns0a 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.2301.00.3'
20241015@173814.4427 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173814.4842 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173814.5437 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173814.5695 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173814.5862 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173814.6109 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2300612200a'
20241015@173814.6359 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173814.6610 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173814.6817 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e995082670e9a769b','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173814.6860 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173814.7298 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173814.8007 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e995082670e9a769b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241015@173814.8506 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173814.8548 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241015@173814.9157 dcgr3s4dh70kauggn6tv7kns0a 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.2330.00.1'
20241015@173814.9743 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173814.9994 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173815.3200 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173815.4560 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173815.6230 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173815.6880 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100584800a'
20241015@173815.7050 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173815.9890 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173815.1195 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e940930670e9a7711','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173815.1238 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173815.1609 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173815.2236 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e940930670e9a7711',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241015@173815.2729 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173815.2770 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2357.00.1'
20241015@173815.3101 dcgr3s4dh70kauggn6tv7kns0a 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.2357.00.1'
20241015@173815.3348 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173815.3600 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173815.4315 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173815.4643 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173815.4808 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173815.5056 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2357.00.1' and lote = 'r2200239100a'
20241015@173815.5304 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173815.5554 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173815.5761 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e900574670e9a7781','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173815.5804 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173815.6056 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173815.6241 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e900574670e9a7781',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',11.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241015@173815.6732 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173815.6773 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20241015@173815.6804 dcgr3s4dh70kauggn6tv7kns0a 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.2362.00.1'
20241015@173815.6972 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173815.7224 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173815.8820 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173815.9072 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173815.9237 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173815.9486 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2300548200a'
20241015@173816.1838 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173816.2203 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173816.2410 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e958634670e9a782c','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173816.2453 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173816.2706 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173816.3325 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e958634670e9a782c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',11.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241015@173816.3828 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173816.3870 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2366.00.1'
20241015@173816.4059 dcgr3s4dh70kauggn6tv7kns0a 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.2366.00.1'
20241015@173816.4453 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173816.4532 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173816.4948 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173816.5204 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173816.5369 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173816.5616 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2366.00.1' and lote = 'r2300548100a'
20241015@173816.5867 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173816.6118 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173816.6324 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e960961670e9a788f','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173816.6367 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173816.6618 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173816.7238 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e960961670e9a788f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',11.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241015@173816.7734 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173816.7775 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241015@173816.8114 dcgr3s4dh70kauggn6tv7kns0a 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.2335.00.1'
20241015@173816.8546 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173816.8858 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173816.9657 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173816.9922 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173817.8800 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173817.3380 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2100585500a'
20241015@173817.6360 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173817.8870 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173817.1094 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e908401670e9a790f','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173817.1137 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173817.1388 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173817.2008 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e908401670e9a790f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241015@173817.3210 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173817.3506 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241015@173817.3839 dcgr3s4dh70kauggn6tv7kns0a 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.2335.00.1'
20241015@173817.4088 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173817.4340 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173817.4919 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173817.5171 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173817.5337 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173817.5584 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2100585500a'
20241015@173817.5833 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173817.7154 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173817.7366 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e999260670e9a798e','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173817.7409 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173817.7660 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173817.8278 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e999260670e9a798e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241015@173817.8783 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173817.8824 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20241015@173817.9157 dcgr3s4dh70kauggn6tv7kns0a 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'
20241015@173817.9592 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173817.9842 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173818.4370 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173818.6930 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173818.8580 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173818.1104 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2400237100a'
20241015@173818.1353 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173818.1607 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173818.1814 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e966979670e9a7a21','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173818.1857 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173818.2352 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173818.4820 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e966979670e9a7a21',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241015@173818.5311 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173818.5353 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241015@173818.5684 dcgr3s4dh70kauggn6tv7kns0a 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.2300.00.1'
20241015@173818.5974 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173818.6225 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173818.6819 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173818.7076 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173818.7241 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173818.7488 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400499200a'
20241015@173818.7751 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173818.8004 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173818.8215 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e950524670e9a7abd','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173818.8258 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173818.8511 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173818.9128 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e950524670e9a7abd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241015@173818.9621 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173818.9662 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2318.00.1'
20241015@173819.9000 dcgr3s4dh70kauggn6tv7kns0a 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.2318.00.1'
20241015@173819.3910 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.4110 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173819.8500 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.1832 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173819.2250 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173819.2497 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2318.00.1' and lote = 'r2100669100a'
20241015@173819.2788 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.3038 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173819.3366 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e944991670e9a7b44','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173819.3421 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.3672 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173819.4166 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e944991670e9a7b44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241015@173819.4681 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.4932 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173819.5507 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.5759 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173819.5924 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173819.6174 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.6427 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173819.6633 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e965966670e9a7b96','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173819.6676 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.6927 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173819.7361 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670e965966670e9a7b96',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,110000,?,?,?)
20241015@173819.7793 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173819.7835 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.1317.00.1'
20241015@173819.8167 dcgr3s4dh70kauggn6tv7kns0a 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.1317.00.1'
20241015@173819.8595 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.8846 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173819.9423 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173819.9674 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173819.9839 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173820.8180 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.1317.00.1' and lote = 'r2400458200a'
20241015@173820.1281 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173820.1300 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173820.1312 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e912243670e9a7c1f','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173820.1318 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173820.1624 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173820.2242 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e912243670e9a7c1f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241015@173820.2741 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173820.2784 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2334.00.1'
20241015@173820.3118 dcgr3s4dh70kauggn6tv7kns0a 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.2334.00.1'
20241015@173820.3685 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173820.3946 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173820.4524 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173820.4775 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173820.4940 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173820.5032 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2334.00.1' and lote = 'r2100585400a'
20241015@173820.5049 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173820.5243 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173820.5449 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e977602670e9a7c7b','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173820.5493 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173820.5743 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173820.7528 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e977602670e9a7c7b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20241015@173820.8027 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173820.8068 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241015@173820.8400 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2326.00.1'
20241015@173820.9438 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173821.1330 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173821.1114 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173821.1527 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173821.1707 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173821.1955 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2100576400a'
20241015@173821.2207 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173821.2458 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173821.2665 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e950402670e9a7d35','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173821.2708 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173821.2959 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173821.3419 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e950402670e9a7d35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,150000,?,?,?,?,?)
20241015@173821.3973 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173821.4033 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2317.00.1'
20241015@173821.4458 dcgr3s4dh70kauggn6tv7kns0a 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.2317.00.1'
20241015@173821.4939 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173821.5370 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173821.6392 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173821.6874 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173821.7124 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173821.7372 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2317.00.1' and lote = 'r2100576500a'
20241015@173821.7620 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173821.7871 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173821.8077 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e972956670e9a7dba','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173821.8120 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173821.8370 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173821.8988 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e972956670e9a7dba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241015@173821.9538 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173821.9880 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173822.1446 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173822.1700 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173822.1870 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173822.2119 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173822.2369 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173822.3830 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e941283670e9a7e33','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173822.4677 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173822.4929 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173822.5546 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670e941283670e9a7e33',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,170000,?,?,?)
20241015@173822.6050 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173822.6091 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '304.2315.00.1'
20241015@173822.6424 dcgr3s4dh70kauggn6tv7kns0a 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.2315.00.1'
20241015@173822.6861 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173822.6946 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173822.7186 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173822.7252 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173822.7423 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173822.7671 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='304.2315.00.1' and lote = 's2300276100a'
20241015@173822.7921 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173822.8178 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173822.8386 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e968980670e9a7ec1','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173822.8430 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173822.8697 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173822.9654 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e968980670e9a7ec1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241015@173823.2290 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173823.4810 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173823.1055 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173823.1306 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173823.1471 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173823.1718 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173823.1969 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173823.2024 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e932943670e9a7f29','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173823.2029 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173823.2203 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173823.2374 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670e932943670e9a7f29',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,200000,?,?,?)
20241015@173823.2878 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173823.2919 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20241015@173823.3740 dcgr3s4dh70kauggn6tv7kns0a 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.2388.00.1'
20241015@173823.4268 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173823.4519 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173823.5231 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173823.5482 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173823.5646 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173823.5893 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20241015@173823.6143 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173823.7682 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173823.7889 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e954566670e9a7f95','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173823.7933 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173823.8184 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173823.8350 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e954566670e9a7f95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241015@173823.8752 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173823.8787 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241015@173823.9163 dcgr3s4dh70kauggn6tv7kns0a 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.1332.00.1'
20241015@173823.9600 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173823.9851 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173824.4270 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173824.6790 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173824.8430 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173824.1090 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241015@173824.1338 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173824.1589 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173824.1795 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e942310670e9a8020','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173824.1839 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173824.2089 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173824.4119 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670e942310670e9a8020',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut670e967602670e9a75a9' ,0,0 ,2,23.00,230000,?,?,?,?,?)
20241015@173824.5114 dcgr3s4dh70kauggn6tv7kns0a Query : use flama_phc
20241015@173824.5173 dcgr3s4dh70kauggn6tv7kns0a Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241015@173824.5587 dcgr3s4dh70kauggn6tv7kns0a 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.1332.00.1'
20241015@173824.5834 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173824.6100 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241015@173824.6684 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173824.6935 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173824.7100 dcgr3s4dh70kauggn6tv7kns0a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241015@173824.7347 dcgr3s4dh70kauggn6tv7kns0a Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241015@173824.7595 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241015@173824.7846 dcgr3s4dh70kauggn6tv7kns0a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241015@173824.8094 dcgr3s4dh70kauggn6tv7kns0a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670e997191670e9a80b9','aut670e967602670e9a75a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241015@173824.9313 dcgr3s4dh70kauggn6tv7kns0a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
