20241114@144012.2721 bcvl7ulmlk2inefbjp7e5dpgaa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3319';
20241114@151930.5310 ppjgfsn7m5d0d5j8grd2r73fvf Query : use flama_phc
20241114@151930.5314 ppjgfsn7m5d0d5j8grd2r73fvf Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241114@151930.5407 ppjgfsn7m5d0d5j8grd2r73fvf Query : use flama_phc
20241114@151930.5411 ppjgfsn7m5d0d5j8grd2r73fvf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@153631.3151 r0i3nn9jifs4iuv51831e7nohs Query : use flama_phc
20241114@153631.3156 r0i3nn9jifs4iuv51831e7nohs Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241114@153631.3261 r0i3nn9jifs4iuv51831e7nohs Query : use flama_phc
20241114@153631.3265 r0i3nn9jifs4iuv51831e7nohs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@161917.2265 lj4i9rvaihvdvnq8j9oq011vkb Query : use flama_phc
20241114@161917.2269 lj4i9rvaihvdvnq8j9oq011vkb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241114@161917.2360 lj4i9rvaihvdvnq8j9oq011vkb Query : use flama_phc
20241114@161917.2363 lj4i9rvaihvdvnq8j9oq011vkb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@163617.3749 4dv16m2k5di6thdoac3dhfnu95 Query : use flama_phc
20241114@163617.3753 4dv16m2k5di6thdoac3dhfnu95 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241114@163617.3849 4dv16m2k5di6thdoac3dhfnu95 Query : use flama_phc
20241114@163617.3852 4dv16m2k5di6thdoac3dhfnu95 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@171916.7537 v4o3edh6mp8t6vm534o7u76lf0 Query : use flama_phc
20241114@171916.7541 v4o3edh6mp8t6vm534o7u76lf0 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241114@171916.7626 v4o3edh6mp8t6vm534o7u76lf0 Query : use flama_phc
20241114@171916.7629 v4o3edh6mp8t6vm534o7u76lf0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@173616.5437 58ckl22qq6t8mudfgql732e8pg Query : use flama_phc
20241114@173616.5440 58ckl22qq6t8mudfgql732e8pg Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241114@173616.5528 58ckl22qq6t8mudfgql732e8pg Query : use flama_phc
20241114@173616.5531 58ckl22qq6t8mudfgql732e8pg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@181923.7409 jpihb140dl00lmnarlvji515jo Query : use flama_phc
20241114@181923.7413 jpihb140dl00lmnarlvji515jo Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241114@181923.7509 jpihb140dl00lmnarlvji515jo Query : use flama_phc
20241114@181923.7512 jpihb140dl00lmnarlvji515jo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@183623.5610 1f1aduvfu1decpgu7278rf6foi Query : use flama_phc
20241114@183623.5615 1f1aduvfu1decpgu7278rf6foi Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241114@183623.5713 1f1aduvfu1decpgu7278rf6foi Query : use flama_phc
20241114@183623.5717 1f1aduvfu1decpgu7278rf6foi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@185730.1856 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241114@185730.1874 0t6l1r6qi8eifgbc1lpn21qp6s Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241114@185730.2040 0t6l1r6qi8eifgbc1lpn21qp6s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3320';
20241114@185730.2105 0t6l1r6qi8eifgbc1lpn21qp6s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3320';
20241114@185730.2161 0t6l1r6qi8eifgbc1lpn21qp6s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3320';
20241114@185730.2191 0t6l1r6qi8eifgbc1lpn21qp6s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3320';
20241114@185730.2250 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.2253 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241114@185730.2325 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.2328 0t6l1r6qi8eifgbc1lpn21qp6s Query : select no, estab,szadrsdesc from szadrs where u_coddest=566
20241114@185730.2423 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241114@185730.2579 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407596 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241114@185730.2892 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20241114@185730.3037 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407596 and bi.ref ='324.645.00.01' and bi.lordem =2
20241114@185730.3378 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241114@185730.3406 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407596 and bi.ref ='324.646.00.01' and bi.lordem =3
20241114@185730.3705 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241114@185730.3725 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407596 and bi.ref ='324.646.00.01' and bi.lordem =3
20241114@185730.3747 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241114@185730.3891 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407596 and bi.ref ='324.1824.00.1' and bi.lordem =4
20241114@185730.4297 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241114@185730.4322 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407596 and bi.ref ='324.1824.00.1' and bi.lordem =4
20241114@185730.4344 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241114@185730.4371 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407596 and bi.ref ='324.1824.00.1' and bi.lordem =5
20241114@185730.4684 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241114@185730.4706 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407596 and bi.ref ='324.1879.00.1' and bi.lordem =6
20241114@185730.5024 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241114@185730.5046 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407596 and bi.ref ='324.1879.00.1' and bi.lordem =6
20241114@185730.5063 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.5066 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241114@185730.5111 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.5117 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 1 valor from td where td.ndoc = 39
20241114@185730.5159 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.5163 0t6l1r6qi8eifgbc1lpn21qp6s 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')
20241114@185730.5212 0t6l1r6qi8eifgbc1lpn21qp6s 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
20241114@185730.5267 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.5271 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 ~inactivo valor from cl where no = '101794' and estab = 0 order by inactivo desc
20241114@185730.5394 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.5397 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241114@185730.5436 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.5439 0t6l1r6qi8eifgbc1lpn21qp6s Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241114@185730.5486 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.5489 0t6l1r6qi8eifgbc1lpn21qp6s Query : select szadrsstamp valor from szadrs where szadrsdesc='dario alberto almeida, lda - lixa'
20241114@185730.5540 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.5544 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from td where ndoc = 39
20241114@185730.5561 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241114@185730.5582 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.5611 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241114@185730.5658 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.5673 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241114@185730.5701 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.5716 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241114@185730.5729 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241114@185730.5809 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241114@185730.5840 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.5857 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241114@185730.5879 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241114@185730.6188 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.6206 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241114@185730.6250 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241114@185730.6273 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241114@185730.6286 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241114@185730.6299 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241114@185730.6312 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241114@185730.6324 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241114@185730.6339 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67364809596736481a8b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241114@185730.6984 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 fno valor from wsftdata order by fno desc
20241114@185730.7023 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.7040 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241114@185730.7068 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 'normal' from dummy
20241114@185730.7105 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67364809596736481a8b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1878,101794,0,'2024-11-14',39,'euro',0,0,2024 ,?,?)
20241114@185730.7589 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.7593 0t6l1r6qi8eifgbc1lpn21qp6s Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241114@185730.7626 0t6l1r6qi8eifgbc1lpn21qp6s 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.1879.00.1'
20241114@185730.7775 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.7794 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185730.7821 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.7838 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185730.7848 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185730.7866 0t6l1r6qi8eifgbc1lpn21qp6s Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2400283200a'
20241114@185730.7894 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.7910 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185730.7922 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364606026736481ac0','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185730.7938 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.7955 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185730.7990 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364606026736481ac0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241114@185730.8862 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.8880 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185730.8908 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.8924 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185730.8935 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185730.8949 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.8967 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185730.8981 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364133536736481ada','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185730.8986 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.9005 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185730.9041 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364133536736481ada',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,20000,?,?,?)
20241114@185730.9295 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185730.9299 0t6l1r6qi8eifgbc1lpn21qp6s Query : select st.usalote valor from st where st.ref = '324.645.00.01'
20241114@185730.9322 0t6l1r6qi8eifgbc1lpn21qp6s 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.645.00.01'
20241114@185730.9481 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.9501 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185730.9530 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.9547 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185730.9556 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185730.9575 0t6l1r6qi8eifgbc1lpn21qp6s Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2400228200a'
20241114@185730.9592 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.9610 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185730.9624 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364338616736481aea','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185730.9629 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.9647 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185730.9681 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364338616736481aea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241114@185730.9958 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185730.9978 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.9000 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.2600 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.3600 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.5300 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.6900 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.8400 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364726806736481b01','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.9000 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.1070 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.1390 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364726806736481b01',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,50000,?,?,?)
20241114@185731.3990 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185731.4030 0t6l1r6qi8eifgbc1lpn21qp6s Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241114@185731.4320 0t6l1r6qi8eifgbc1lpn21qp6s 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.646.00.01'
20241114@185731.4550 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4730 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.5020 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5180 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.5280 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.5420 0t6l1r6qi8eifgbc1lpn21qp6s Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241114@185731.5560 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5730 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.5880 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364806796736481b0d','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.5930 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.6120 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.6450 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364806796736481b0d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241114@185731.9500 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.9690 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.1023 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.1042 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.1052 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.1066 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.1082 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.1096 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364113236736481b1a','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.1101 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.1122 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.1155 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364113236736481b1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,80000,?,?,?)
20241114@185731.1426 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185731.1429 0t6l1r6qi8eifgbc1lpn21qp6s Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241114@185731.1455 0t6l1r6qi8eifgbc1lpn21qp6s 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.646.00.01'
20241114@185731.1470 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.1487 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.1515 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.1533 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.1543 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.1556 0t6l1r6qi8eifgbc1lpn21qp6s Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241114@185731.1570 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.1587 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.1606 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364260656736481b26','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.1612 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.1636 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.1673 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364260656736481b26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241114@185731.1969 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.1989 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.2016 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.2033 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.2043 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.2056 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.2072 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.2085 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364151636736481b32','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.2089 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.2106 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.2140 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364151636736481b32',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,110000,?,?,?)
20241114@185731.2391 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185731.2394 0t6l1r6qi8eifgbc1lpn21qp6s Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241114@185731.2415 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20241114@185731.2554 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.2570 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.2599 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.2614 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.2623 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.2637 0t6l1r6qi8eifgbc1lpn21qp6s Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241114@185731.2658 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.2673 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.2686 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364289186736481b40','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.2691 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.2707 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.2736 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364289186736481b40',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241114@185731.3062 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3078 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.3104 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3118 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.3127 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.3139 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3154 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.3165 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364716986736481b4c','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.3169 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3190 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.3217 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364716986736481b4c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,140000,?,?,?)
20241114@185731.3464 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185731.3467 0t6l1r6qi8eifgbc1lpn21qp6s Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241114@185731.3486 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20241114@185731.3499 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3514 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.3538 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3552 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.3560 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.3572 0t6l1r6qi8eifgbc1lpn21qp6s Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241114@185731.3585 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3600 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.3613 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364072526736481b57','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.3617 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3632 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.3661 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364072526736481b57',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241114@185731.3907 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3922 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.3947 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3961 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.3970 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.3982 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.3996 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.4007 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364116806736481b61','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.4011 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4024 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.4051 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364116806736481b61',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,170000,?,?,?)
20241114@185731.4308 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185731.4311 0t6l1r6qi8eifgbc1lpn21qp6s Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241114@185731.4331 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20241114@185731.4345 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4362 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.4388 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4402 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.4412 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.4427 0t6l1r6qi8eifgbc1lpn21qp6s Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241114@185731.4440 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4454 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.4465 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364968306736481b6c','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.4468 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4485 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.4513 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364968306736481b6c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241114@185731.4767 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4782 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.4809 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4823 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.4831 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.4849 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4869 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.4882 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364819756736481b76','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.4886 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.4904 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.4933 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364819756736481b76',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,200000,?,?,?)
20241114@185731.5205 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185731.5230 0t6l1r6qi8eifgbc1lpn21qp6s Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241114@185731.5256 0t6l1r6qi8eifgbc1lpn21qp6s 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.1879.00.1'
20241114@185731.5270 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5286 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.5311 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5326 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.5335 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.5348 0t6l1r6qi8eifgbc1lpn21qp6s Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2400283200a'
20241114@185731.5360 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5375 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.5388 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364884276736481b82','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.5392 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5407 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.5436 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364884276736481b82',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241114@185731.5700 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5715 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.5740 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5756 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.5764 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.5776 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5794 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.5806 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364473886736481b8d','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.5810 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.5824 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.5853 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364473886736481b8d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,230000,?,?,?)
20241114@185731.6115 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185731.6118 0t6l1r6qi8eifgbc1lpn21qp6s Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241114@185731.6139 0t6l1r6qi8eifgbc1lpn21qp6s 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.1879.00.1'
20241114@185731.6272 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.6532 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.6556 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.7299 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.7483 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.7543 0t6l1r6qi8eifgbc1lpn21qp6s Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2400283200a'
20241114@185731.7557 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.7573 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.7585 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364091936736481bb8','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.7590 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.7606 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.7632 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364091936736481bb8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20241114@185731.7901 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.7916 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.7941 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.7955 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.7964 0t6l1r6qi8eifgbc1lpn21qp6s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185731.7976 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.7991 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185731.8003 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364918796736481bc2','aut67364809596736481a8b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185731.8007 0t6l1r6qi8eifgbc1lpn21qp6s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185731.8022 0t6l1r6qi8eifgbc1lpn21qp6s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185731.8050 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364918796736481bc2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364809596736481a8b' ,0,0 ,2,23.00,260000,?,?,?)
20241114@185731.8319 0t6l1r6qi8eifgbc1lpn21qp6s Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67364809596736481a8b','2407596','wait',39,'adm09112754980.682000002')
20241114@185731.8398 0t6l1r6qi8eifgbc1lpn21qp6s Query : use flama_phc
20241114@185731.8401 0t6l1r6qi8eifgbc1lpn21qp6s Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@185731.8431 0t6l1r6qi8eifgbc1lpn21qp6s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3320';
20241114@185731.8469 0t6l1r6qi8eifgbc1lpn21qp6s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3320';
20241114@185731.8515 0t6l1r6qi8eifgbc1lpn21qp6s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3320';
20241114@185731.8544 0t6l1r6qi8eifgbc1lpn21qp6s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3320';
20241114@185731.9093 rdfthufnd1v3m82v49r3m9ss5f Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241114@185731.9104 rdfthufnd1v3m82v49r3m9ss5f Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241114@185731.9630 rdfthufnd1v3m82v49r3m9ss5f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3321';
20241114@185731.9719 rdfthufnd1v3m82v49r3m9ss5f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3321';
20241114@185731.9870 rdfthufnd1v3m82v49r3m9ss5f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3321';
20241114@185731.9920 rdfthufnd1v3m82v49r3m9ss5f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3321';
20241114@185732.7500 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.7900 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241114@185732.1420 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.1480 rdfthufnd1v3m82v49r3m9ss5f Query : select no, estab,szadrsdesc from szadrs where u_coddest=3071
20241114@185732.2460 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20241114@185732.2660 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407597 and bi.ref ='324.645.00.01' and bi.lordem =1
20241114@185732.5800 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241114@185732.6000 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407597 and bi.ref ='324.646.00.01' and bi.lordem =2
20241114@185732.9020 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241114@185732.9220 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407597 and bi.ref ='324.646.00.01' and bi.lordem =2
20241114@185732.9390 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241114@185732.9580 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407597 and bi.ref ='324.1824.00.1' and bi.lordem =3
20241114@185732.1279 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241114@185732.1302 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407597 and bi.ref ='324.1824.00.1' and bi.lordem =3
20241114@185732.1319 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241114@185732.1343 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407597 and bi.ref ='324.1824.00.1' and bi.lordem =4
20241114@185732.1700 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241114@185732.1727 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407597 and bi.ref ='324.1879.00.1' and bi.lordem =5
20241114@185732.2049 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241114@185732.2071 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407597 and bi.ref ='324.1879.00.1' and bi.lordem =6
20241114@185732.2392 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.2396 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241114@185732.2428 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.2431 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 1 valor from td where td.ndoc = 39
20241114@185732.2459 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.2462 rdfthufnd1v3m82v49r3m9ss5f 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')
20241114@185732.2490 rdfthufnd1v3m82v49r3m9ss5f 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
20241114@185732.2528 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.2531 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 ~inactivo valor from cl where no = '101794' and estab = 0 order by inactivo desc
20241114@185732.2629 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.2632 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241114@185732.2662 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.2665 rdfthufnd1v3m82v49r3m9ss5f Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241114@185732.2703 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.2706 rdfthufnd1v3m82v49r3m9ss5f Query : select szadrsstamp valor from szadrs where szadrsdesc='dÁrio a. almeida lda (euronics)'
20241114@185732.2749 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.2751 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from td where ndoc = 39
20241114@185732.2763 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241114@185732.2783 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.2807 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241114@185732.2826 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.2841 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241114@185732.2881 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.2896 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241114@185732.2910 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241114@185732.2971 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241114@185732.2985 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.3001 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241114@185732.3017 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241114@185732.3212 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.3228 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241114@185732.3261 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241114@185732.3273 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241114@185732.3286 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241114@185732.3298 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241114@185732.3310 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241114@185732.3320 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241114@185732.3331 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67364457736736481c47',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241114@185732.3601 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 fno valor from wsftdata order by fno desc
20241114@185732.3631 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.3647 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241114@185732.3669 rdfthufnd1v3m82v49r3m9ss5f Query : select 'normal' from dummy
20241114@185732.3684 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67364457736736481c47',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1879,101794,0,'2024-11-14',39,'euro',0,0,2024 ,?,?)
20241114@185732.3990 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.3993 rdfthufnd1v3m82v49r3m9ss5f Query : select st.usalote valor from st where st.ref = '324.645.00.01'
20241114@185732.4013 rdfthufnd1v3m82v49r3m9ss5f 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.645.00.01'
20241114@185732.4026 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.4042 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.4065 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.4079 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.4087 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.4099 rdfthufnd1v3m82v49r3m9ss5f Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2400228200a'
20241114@185732.4110 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.4124 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.4135 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364554986736481c64','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.4140 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.4153 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.4179 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364554986736481c64',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut67364457736736481c47' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241114@185732.4448 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.4463 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.4488 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.4503 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.4510 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.4522 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.4537 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.4549 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364830616736481c6e','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.4553 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.4567 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.4594 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364830616736481c6e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364457736736481c47' ,0,0 ,2,23.00,20000,?,?,?)
20241114@185732.4888 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.4894 rdfthufnd1v3m82v49r3m9ss5f Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241114@185732.4917 rdfthufnd1v3m82v49r3m9ss5f 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.646.00.01'
20241114@185732.4933 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.4955 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.4987 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.5013 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.5023 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.5036 rdfthufnd1v3m82v49r3m9ss5f Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241114@185732.5051 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.5069 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.5082 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364715546736481c7b','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.5088 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.5108 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.5145 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364715546736481c7b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67364457736736481c47' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241114@185732.5449 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.5470 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.5502 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.5534 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.5544 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.5558 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.5592 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.5604 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364115956736481c87','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.5609 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.5623 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.5653 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364115956736481c87',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364457736736481c47' ,0,0 ,2,23.00,50000,?,?,?)
20241114@185732.5941 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.5945 rdfthufnd1v3m82v49r3m9ss5f Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241114@185732.5967 rdfthufnd1v3m82v49r3m9ss5f 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.646.00.01'
20241114@185732.5983 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.6001 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.6030 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.6047 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.6056 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.6069 rdfthufnd1v3m82v49r3m9ss5f Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241114@185732.6083 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.6100 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.6114 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364496006736481c94','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.6119 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.6133 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.6163 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364496006736481c94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut67364457736736481c47' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241114@185732.6457 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.6474 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.6504 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.6520 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.6530 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.6546 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.6561 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.6582 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364136726736481c9f','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.6586 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.6603 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.6631 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364136726736481c9f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364457736736481c47' ,0,0 ,2,23.00,80000,?,?,?)
20241114@185732.6922 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.6926 rdfthufnd1v3m82v49r3m9ss5f Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241114@185732.6949 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20241114@185732.6980 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.6997 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.7025 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.7040 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.7049 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.7064 rdfthufnd1v3m82v49r3m9ss5f Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241114@185732.7078 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.7094 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.7108 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364074386736481cac','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.7113 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.7129 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.7164 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364074386736481cac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut67364457736736481c47' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241114@185732.7448 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.7466 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.7492 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.7508 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.7516 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.7529 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.7543 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.7555 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364324426736481cb7','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.7560 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.7574 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.7603 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364324426736481cb7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364457736736481c47' ,0,0 ,2,23.00,110000,?,?,?)
20241114@185732.7893 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.7896 rdfthufnd1v3m82v49r3m9ss5f Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241114@185732.7931 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20241114@185732.7946 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.7962 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.7987 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8009 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.8018 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.8037 rdfthufnd1v3m82v49r3m9ss5f Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241114@185732.8050 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8068 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.8081 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364352606736481cc4','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.8086 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8104 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.8137 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364352606736481cc4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67364457736736481c47' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241114@185732.8430 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8447 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.8473 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8487 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.8497 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.8509 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8523 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.8535 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364878806736481ccf','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.8539 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8555 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.8582 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364878806736481ccf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364457736736481c47' ,0,0 ,2,23.00,140000,?,?,?)
20241114@185732.8837 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.8840 rdfthufnd1v3m82v49r3m9ss5f Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241114@185732.8863 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20241114@185732.8877 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8893 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.8920 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8934 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.8943 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.8956 rdfthufnd1v3m82v49r3m9ss5f Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241114@185732.8969 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.8983 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.8994 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364098286736481cda','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.8999 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.9013 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.9041 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364098286736481cda',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67364457736736481c47' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241114@185732.9303 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.9319 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.9344 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.9359 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.9368 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.9380 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.9394 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.9407 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364774876736481ce5','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.9411 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.9425 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.9467 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364774876736481ce5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364457736736481c47' ,0,0 ,2,23.00,170000,?,?,?)
20241114@185732.9727 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185732.9731 rdfthufnd1v3m82v49r3m9ss5f Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241114@185732.9752 rdfthufnd1v3m82v49r3m9ss5f 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.1879.00.1'
20241114@185732.9766 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.9781 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.9807 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.9821 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.9829 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185732.9841 rdfthufnd1v3m82v49r3m9ss5f Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2400283200a'
20241114@185732.9854 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.9871 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185732.9883 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364755456736481cf0','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185732.9887 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185732.9902 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185732.9930 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364755456736481cf0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',11.000 ,'aut67364457736736481c47' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241114@185733.1960 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.2160 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.2740 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.2910 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.3000 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185733.3130 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.3280 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.3390 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364410296736481d07','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185733.3440 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.3580 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.3850 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364410296736481d07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364457736736481c47' ,0,0 ,2,23.00,200000,?,?,?)
20241114@185733.6550 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185733.6590 rdfthufnd1v3m82v49r3m9ss5f Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241114@185733.6780 rdfthufnd1v3m82v49r3m9ss5f 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.1879.00.1'
20241114@185733.6930 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.7090 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.7340 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.7480 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.7560 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185733.7670 rdfthufnd1v3m82v49r3m9ss5f Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2400283200a'
20241114@185733.7790 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.7930 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.8250 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364658146736481d13','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185733.8290 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.8430 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.8700 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364658146736481d13',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67364457736736481c47' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241114@185733.1152 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.1168 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.1193 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.1208 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.1216 rdfthufnd1v3m82v49r3m9ss5f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185733.1229 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.1245 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.1260 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364279466736481d1e','aut67364457736736481c47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185733.1272 rdfthufnd1v3m82v49r3m9ss5f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.1289 rdfthufnd1v3m82v49r3m9ss5f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.1319 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364279466736481d1e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364457736736481c47' ,0,0 ,2,23.00,230000,?,?,?)
20241114@185733.1610 rdfthufnd1v3m82v49r3m9ss5f Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67364457736736481c47','2407597','wait',39,'adm09112754980.682000002')
20241114@185733.1700 rdfthufnd1v3m82v49r3m9ss5f Query : use flama_phc
20241114@185733.1703 rdfthufnd1v3m82v49r3m9ss5f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241114@185733.1742 rdfthufnd1v3m82v49r3m9ss5f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3321';
20241114@185733.1780 rdfthufnd1v3m82v49r3m9ss5f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3321';
20241114@185733.1828 rdfthufnd1v3m82v49r3m9ss5f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3321';
20241114@185733.1857 rdfthufnd1v3m82v49r3m9ss5f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3321';
20241114@185733.2411 e3bqhj75bds7bh58jvm8lgeabv Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241114@185733.2425 e3bqhj75bds7bh58jvm8lgeabv Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241114@185733.2508 e3bqhj75bds7bh58jvm8lgeabv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3322';
20241114@185733.2577 e3bqhj75bds7bh58jvm8lgeabv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3322';
20241114@185733.2641 e3bqhj75bds7bh58jvm8lgeabv Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3322';
20241114@185733.2676 e3bqhj75bds7bh58jvm8lgeabv Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3322';
20241114@185733.2739 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.2743 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241114@185733.2820 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.2823 e3bqhj75bds7bh58jvm8lgeabv Query : select no, estab,szadrsdesc from szadrs where u_coddest=698
20241114@185733.2920 e3bqhj75bds7bh58jvm8lgeabv 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'
20241114@185733.2948 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407598 and bi.ref ='324.5343.00.1' and bi.lordem =1
20241114@185733.3270 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20241114@185733.3422 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407598 and bi.ref ='324.2066.00.1' and bi.lordem =2
20241114@185733.3738 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.3742 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241114@185733.3783 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.3786 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 1 valor from td where td.ndoc = 39
20241114@185733.3826 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.3828 e3bqhj75bds7bh58jvm8lgeabv 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')
20241114@185733.3856 e3bqhj75bds7bh58jvm8lgeabv 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
20241114@185733.3889 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.3892 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 ~inactivo valor from cl where no = '100220' and estab = 0 order by inactivo desc
20241114@185733.4013 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.4015 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241114@185733.4046 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.4049 e3bqhj75bds7bh58jvm8lgeabv Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241114@185733.4089 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.4092 e3bqhj75bds7bh58jvm8lgeabv Query : select szadrsstamp valor from szadrs where szadrsdesc='amorim & ferreira, lda'
20241114@185733.4138 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.4141 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from td where ndoc = 39
20241114@185733.4153 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241114@185733.4166 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.4183 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241114@185733.4202 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.4217 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241114@185733.4244 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.4259 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241114@185733.4272 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241114@185733.4335 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241114@185733.4348 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.4363 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241114@185733.4380 e3bqhj75bds7bh58jvm8lgeabv Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67364209316736481d68' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241114@185733.4564 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.4582 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241114@185733.4616 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241114@185733.4628 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241114@185733.4640 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241114@185733.4651 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241114@185733.4664 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241114@185733.4675 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241114@185733.4686 e3bqhj75bds7bh58jvm8lgeabv Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67364209316736481d68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241114@185733.4960 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 fno valor from wsftdata order by fno desc
20241114@185733.4993 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.5011 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241114@185733.5039 e3bqhj75bds7bh58jvm8lgeabv Query : select 'normal' from dummy
20241114@185733.5056 e3bqhj75bds7bh58jvm8lgeabv Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67364209316736481d68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1880,100220,0,'2024-11-14',39,'euro',0,0,2024 ,?,?)
20241114@185733.5367 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.5370 e3bqhj75bds7bh58jvm8lgeabv Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20241114@185733.5395 e3bqhj75bds7bh58jvm8lgeabv 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.5343.00.1'
20241114@185733.5417 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.5435 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.5466 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.5483 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.5493 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185733.5507 e3bqhj75bds7bh58jvm8lgeabv Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20241114@185733.5527 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.5543 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.5554 e3bqhj75bds7bh58jvm8lgeabv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364832246736481d86','aut67364209316736481d68' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185733.5558 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.5581 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.5610 e3bqhj75bds7bh58jvm8lgeabv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364832246736481d86',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67364209316736481d68' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241114@185733.5901 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.5920 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.5950 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.5967 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.5976 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185733.5989 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.6004 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.6018 e3bqhj75bds7bh58jvm8lgeabv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364731586736481d92','aut67364209316736481d68' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185733.6023 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.6040 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.6068 e3bqhj75bds7bh58jvm8lgeabv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67364731586736481d92',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67364209316736481d68' ,0,0 ,2,23.00,20000,?,?,?)
20241114@185733.6364 e3bqhj75bds7bh58jvm8lgeabv Query : use flama_phc
20241114@185733.6368 e3bqhj75bds7bh58jvm8lgeabv Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20241114@185733.6391 e3bqhj75bds7bh58jvm8lgeabv 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.2066.00.1'
20241114@185733.6548 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.6566 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.6591 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.6607 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.6616 e3bqhj75bds7bh58jvm8lgeabv Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241114@185733.6628 e3bqhj75bds7bh58jvm8lgeabv Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20241114@185733.6648 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.6664 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241114@185733.6676 e3bqhj75bds7bh58jvm8lgeabv Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67364833426736481da2','aut67364209316736481d68' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241114@185733.6681 e3bqhj75bds7bh58jvm8lgeabv Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241114@185733.6696 e3bqhj75bds7bh58jvm8lgeabv Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241114@185733.6725 e3bqhj75bds7bh58jvm8lgeabv Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67364833426736481da2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67364209316736481d68' ,0,0 ,2,23.00,40000,?,?,?,?,?)
