20241219@084742.7893 d0mrug8v0sht1ocqv9ak7it9c5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@084742.7909 d0mrug8v0sht1ocqv9ak7it9c5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@084742.7921 d0mrug8v0sht1ocqv9ak7it9c5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6763d706006763ddaec0','aut6763d817636763ddae72' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@084742.7926 d0mrug8v0sht1ocqv9ak7it9c5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@084742.7941 d0mrug8v0sht1ocqv9ak7it9c5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@084742.7972 d0mrug8v0sht1ocqv9ak7it9c5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut6763d706006763ddaec0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6763d817636763ddae72' ,0,0 ,2,23.00,20000,?,?,?,?)
20241219@084742.8230 d0mrug8v0sht1ocqv9ak7it9c5 Query : use flama_phc
20241219@084742.8234 d0mrug8v0sht1ocqv9ak7it9c5 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241219@084742.8256 d0mrug8v0sht1ocqv9ak7it9c5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241219@084742.8271 d0mrug8v0sht1ocqv9ak7it9c5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@084742.8290 d0mrug8v0sht1ocqv9ak7it9c5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@084742.8318 d0mrug8v0sht1ocqv9ak7it9c5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@084742.8334 d0mrug8v0sht1ocqv9ak7it9c5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@084742.8343 d0mrug8v0sht1ocqv9ak7it9c5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@084742.8356 d0mrug8v0sht1ocqv9ak7it9c5 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241219@084742.8370 d0mrug8v0sht1ocqv9ak7it9c5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@084742.8385 d0mrug8v0sht1ocqv9ak7it9c5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@084742.8398 d0mrug8v0sht1ocqv9ak7it9c5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6763d196956763ddaecc','aut6763d817636763ddae72' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@084742.8404 d0mrug8v0sht1ocqv9ak7it9c5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@084742.8419 d0mrug8v0sht1ocqv9ak7it9c5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@084742.8452 d0mrug8v0sht1ocqv9ak7it9c5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut6763d196956763ddaecc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6763d817636763ddae72' ,0,0 ,2,23.00,30000,?,?,?,?)
20241219@084742.8690 d0mrug8v0sht1ocqv9ak7it9c5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6763d817636763ddae72','2408780','wait',39,'adm09112754980.682000002')
20241219@084742.8769 d0mrug8v0sht1ocqv9ak7it9c5 Query : use flama_phc
20241219@084742.8772 d0mrug8v0sht1ocqv9ak7it9c5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241219@084742.8808 d0mrug8v0sht1ocqv9ak7it9c5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4101';
20241219@084742.8851 d0mrug8v0sht1ocqv9ak7it9c5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4101';
20241219@084742.8905 d0mrug8v0sht1ocqv9ak7it9c5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4101';
20241219@084742.8942 d0mrug8v0sht1ocqv9ak7it9c5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4101';

20241219@102016.7220 gp1r3sp6g13188ges1b80cgfng Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4102';
20241219@102016.7286 gp1r3sp6g13188ges1b80cgfng Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4102';
20241219@102016.7369 gp1r3sp6g13188ges1b80cgfng Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4102';
20241219@102016.8467 ksgq86ojo3mun97993pjft7p86 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241219@102016.8478 ksgq86ojo3mun97993pjft7p86 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241219@102016.8548 ksgq86ojo3mun97993pjft7p86 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4103';
20241219@102016.8613 ksgq86ojo3mun97993pjft7p86 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4103';
20241219@102016.8759 ksgq86ojo3mun97993pjft7p86 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4103';
20241219@102016.8805 ksgq86ojo3mun97993pjft7p86 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4103';
20241219@102016.8860 ksgq86ojo3mun97993pjft7p86 Query : use flama_phc
20241219@102016.8863 ksgq86ojo3mun97993pjft7p86 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241219@102016.8972 ksgq86ojo3mun97993pjft7p86 Query : select no, estab,szadrsdesc from szadrs where u_coddest=00000001
20241219@102016.9131 ksgq86ojo3mun97993pjft7p86 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '304.2187.00.1'
20241219@102016.9418 ksgq86ojo3mun97993pjft7p86 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '304.2187.00.1'
20241219@102016.9453 ksgq86ojo3mun97993pjft7p86 Query : use flama_phc
20241219@102016.9458 ksgq86ojo3mun97993pjft7p86 Query : select top 1 1 valor from ts where ts.ndos = 5
20241219@102016.9587 ksgq86ojo3mun97993pjft7p86 Query : use flama_phc
20241219@102016.9590 ksgq86ojo3mun97993pjft7p86 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')
20241219@102016.9800 ksgq86ojo3mun97993pjft7p86 Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20241219@102017.5400 ksgq86ojo3mun97993pjft7p86 Query : use flama_phc
20241219@102017.5900 ksgq86ojo3mun97993pjft7p86 Query : select top 1 ~inactivo valor from fl where no = '102245' and estab = 0 order by inactivo desc
20241219@102017.2430 ksgq86ojo3mun97993pjft7p86 Query : use flama_phc
20241219@102017.2470 ksgq86ojo3mun97993pjft7p86 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -230
20241219@102017.5870 ksgq86ojo3mun97993pjft7p86 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4103';
20241219@102017.6310 ksgq86ojo3mun97993pjft7p86 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4103';

20241219@134141.7384 47ork68g50qubq485nvr3th49i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4104';
20241219@134141.7479 47ork68g50qubq485nvr3th49i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4104';
20241219@134141.7523 47ork68g50qubq485nvr3th49i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4104';
20241219@134141.7602 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134141.7605 47ork68g50qubq485nvr3th49i Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241219@134141.7726 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134141.7729 47ork68g50qubq485nvr3th49i Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241219@134141.7822 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2300.00.1'
20241219@134141.7963 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2300.00.1' and bi.lordem =1
20241219@134141.8319 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2300.00.1'
20241219@134141.8341 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2300.00.1' and bi.lordem =1
20241219@134141.8360 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2308.00.1'
20241219@134141.8498 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2308.00.1' and bi.lordem =2
20241219@134141.8840 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2308.00.1'
20241219@134141.8862 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2308.00.1' and bi.lordem =2
20241219@134141.8879 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9009 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9324 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9345 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9363 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9382 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9398 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9418 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9434 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9481 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9499 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9519 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9540 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9561 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9580 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9601 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9650 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9672 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9688 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9708 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9725 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9744 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9763 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241219@134141.9792 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2301.00.3' and bi.lordem =3
20241219@134141.9834 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241219@134142.1860 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2326.00.1' and bi.lordem =4
20241219@134142.6330 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241219@134142.6570 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2326.00.1' and bi.lordem =4
20241219@134142.6760 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241219@134142.7030 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2326.00.1' and bi.lordem =4
20241219@134142.7240 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2317.00.1'
20241219@134142.9140 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2317.00.1' and bi.lordem =5
20241219@134142.1241 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2317.00.1'
20241219@134142.1266 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2317.00.1' and bi.lordem =5
20241219@134142.1287 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2318.00.1'
20241219@134142.1453 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2318.00.1' and bi.lordem =6
20241219@134142.1794 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2366.00.1'
20241219@134142.1966 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2366.00.1' and bi.lordem =7
20241219@134142.2302 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241219@134142.2442 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2330.00.1' and bi.lordem =8
20241219@134142.2857 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241219@134142.2880 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2330.00.1' and bi.lordem =8
20241219@134142.2935 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241219@134142.2957 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2330.00.1' and bi.lordem =8
20241219@134142.2973 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241219@134142.2993 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2330.00.1' and bi.lordem =8
20241219@134142.3010 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241219@134142.3029 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2330.00.1' and bi.lordem =8
20241219@134142.3047 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241219@134142.3072 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2330.00.1' and bi.lordem =8
20241219@134142.3090 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241219@134142.3111 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2330.00.1' and bi.lordem =8
20241219@134142.3129 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241219@134142.3174 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2330.00.1' and bi.lordem =8
20241219@134142.3192 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241219@134142.3219 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2335.00.1' and bi.lordem =9
20241219@134142.3571 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241219@134142.3629 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2335.00.1' and bi.lordem =9
20241219@134142.3684 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241219@134142.3857 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2335.00.1' and bi.lordem =9
20241219@134142.3881 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241219@134142.4149 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2335.00.1' and bi.lordem =9
20241219@134142.4365 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241219@134142.4465 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2335.00.1' and bi.lordem =9
20241219@134142.4483 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241219@134142.4506 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2335.00.1' and bi.lordem =9
20241219@134142.4527 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241219@134142.4547 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2335.00.1' and bi.lordem =9
20241219@134142.4565 47ork68g50qubq485nvr3th49i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241219@134142.4585 47ork68g50qubq485nvr3th49i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408692 and bi.ref ='324.2335.00.1' and bi.lordem =9
20241219@134142.4626 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134142.4629 47ork68g50qubq485nvr3th49i Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241219@134142.4807 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134142.4810 47ork68g50qubq485nvr3th49i Query : select top 1 1 valor from td where td.ndoc = 39
20241219@134142.4881 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134142.4884 47ork68g50qubq485nvr3th49i 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')
20241219@134142.4955 47ork68g50qubq485nvr3th49i 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
20241219@134142.5073 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134142.5076 47ork68g50qubq485nvr3th49i Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241219@134142.5205 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134142.5214 47ork68g50qubq485nvr3th49i Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241219@134142.5330 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134142.5343 47ork68g50qubq485nvr3th49i Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241219@134142.5422 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134142.5428 47ork68g50qubq485nvr3th49i Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241219@134142.5495 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134142.5500 47ork68g50qubq485nvr3th49i Query : select 1 valor from td where ndoc = 39
20241219@134142.5654 47ork68g50qubq485nvr3th49i Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241219@134142.5745 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134142.6556 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241219@134142.6869 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134142.6893 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241219@134142.6927 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134142.6943 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241219@134142.6958 47ork68g50qubq485nvr3th49i Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241219@134142.7216 47ork68g50qubq485nvr3th49i Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241219@134142.7409 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134142.7426 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241219@134142.7475 47ork68g50qubq485nvr3th49i Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241219@134142.7759 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134142.7783 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241219@134142.7870 47ork68g50qubq485nvr3th49i Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241219@134142.8116 47ork68g50qubq485nvr3th49i Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241219@134142.8202 47ork68g50qubq485nvr3th49i Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241219@134142.8301 47ork68g50qubq485nvr3th49i Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241219@134142.8419 47ork68g50qubq485nvr3th49i Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241219@134142.8518 47ork68g50qubq485nvr3th49i Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241219@134142.8634 47ork68g50qubq485nvr3th49i Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676427110667642296a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241219@134142.9319 47ork68g50qubq485nvr3th49i Query : select top 1 fno valor from wsftdata order by fno desc
20241219@134142.9409 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134142.9426 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241219@134142.9456 47ork68g50qubq485nvr3th49i Query : select 'normal' from dummy
20241219@134142.9518 47ork68g50qubq485nvr3th49i Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676427110667642296a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2562,102943,0,'2024-12-19',39,'euro',0,0,2024 ,?,?)
20241219@134142.9936 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134142.9940 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241219@134142.9973 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2300.00.1'
20241219@134143.1290 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.1620 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.1930 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.2090 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.2190 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.2630 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400497200a'
20241219@134143.2880 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.3040 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.3190 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642016246764229707','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.3740 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.4300 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.4680 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642016246764229707',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241219@134143.8170 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.8210 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241219@134143.8390 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2300.00.1'
20241219@134143.8530 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.9050 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.9330 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.9480 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.9560 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.9710 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400497200a'
20241219@134143.9830 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.9970 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.1011 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642104836764229717','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.1015 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.1029 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.1059 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642104836764229717',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',60.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241219@134143.1327 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.1330 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2308.00.1'
20241219@134143.1351 47ork68g50qubq485nvr3th49i 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.2308.00.1'
20241219@134143.1478 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.1494 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.1520 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.1537 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.1545 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.1556 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2308.00.1' and lote = 'r2400475700a'
20241219@134143.1569 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.1584 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.1607 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642992266764229726','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.1611 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.1625 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.1651 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642992266764229726',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241219@134143.1893 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.1897 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2308.00.1'
20241219@134143.1924 47ork68g50qubq485nvr3th49i 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.2308.00.1'
20241219@134143.1956 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.1972 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.1996 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.2015 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.2043 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.2055 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2308.00.1' and lote = 'r2400475700a'
20241219@134143.2067 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.2088 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.2100 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642283216764229732','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.2104 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.2123 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.2150 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642283216764229732',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',126.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241219@134143.2446 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.2451 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.2471 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.2641 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.2658 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.2690 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.2706 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.2756 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.2787 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.2802 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.2819 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.2832 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642794286764229744','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.2839 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.2875 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.2915 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642794286764229744',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241219@134143.3153 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.3157 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.3186 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.3233 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.3279 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.3310 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.3327 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.3338 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.3354 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.3372 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.3387 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.3413 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642040846764229752','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.3424 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.3481 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.3534 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642040846764229752',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241219@134143.3792 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.3795 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.3928 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.4017 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.4037 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.4119 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.4150 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.4160 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.4173 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.4206 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.4229 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.4243 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642993556764229766','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.4265 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.4321 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.4368 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642993556764229766',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241219@134143.4637 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.4642 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.4667 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.4706 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.4727 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.4775 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.4799 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.4810 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.4826 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.4845 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.4884 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.4898 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642709806764229776','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.4903 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.4945 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.4986 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642709806764229776',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241219@134143.5241 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.5245 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.5289 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.5312 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.5372 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.5409 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.5425 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.5435 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.5460 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.5475 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.5491 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.5509 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642800626764229785','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.5518 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.5541 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.5632 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642800626764229785',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241219@134143.5897 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.5908 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.5958 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.5991 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.6045 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.6113 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.6205 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.6217 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.6232 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.6296 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.6347 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.6361 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642603526764229799','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.6366 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.6413 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.6853 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642603526764229799',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241219@134143.7264 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.7270 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.7293 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.7315 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.7339 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.7375 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.7394 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.7404 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.7416 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.7455 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.7473 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.7485 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676425676267642297b6','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.7491 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.7510 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.7560 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676425676267642297b6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241219@134143.7815 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.7819 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.7946 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.8020 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.8047 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.8077 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.8099 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.8109 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.8123 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.8140 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.8158 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.8172 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676420690567642297c6','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.8178 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.8197 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.8230 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676420690567642297c6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20241219@134143.8510 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.8514 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.8555 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.8621 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.8640 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.8675 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.8691 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.8729 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.8744 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.8829 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.8851 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.8877 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676421878467642297d7','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.8885 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.8911 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.9126 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676421878467642297d7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241219@134143.9538 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134143.9547 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134143.9566 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134143.9599 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.9615 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.9646 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.9660 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.9673 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134143.9685 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134143.9698 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.9768 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134143.9833 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676421080467642297ec','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134143.9850 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134143.9893 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134143.9940 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676421080467642297ec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20241219@134144.2850 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134144.3150 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134144.3380 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134144.3600 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.3860 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.4400 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.4660 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.4750 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.4900 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134144.5040 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.5180 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.5330 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6764249373676422980c','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.5450 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.5620 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.6120 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6764249373676422980c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,150000,?,?,?,?,?)
20241219@134144.8800 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134144.8840 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241219@134144.9230 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241219@134144.9550 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.9750 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.1081 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.1233 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.1473 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.1604 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241219@134144.1648 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.1666 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.1687 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642724316764229828','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.1721 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.1746 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.1788 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642724316764229828',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241219@134144.2128 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134144.2227 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241219@134144.2263 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2326.00.1'
20241219@134144.2453 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.2470 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.2548 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.2650 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.2662 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.2751 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2400475600a'
20241219@134144.2771 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.2787 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.2798 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642095896764229843','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.2811 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.2835 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.2902 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642095896764229843',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',126.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,170000,?,?,?,?,?)
20241219@134144.3208 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134144.3212 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241219@134144.3245 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2326.00.1'
20241219@134144.3275 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.3295 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.3326 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.3340 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.3349 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.3361 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2400475600a'
20241219@134144.3409 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.3427 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.3438 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642038976764229853','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.3443 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.3481 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.3511 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642038976764229853',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',126.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,180000,?,?,?,?,?)
20241219@134144.3749 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134144.3753 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241219@134144.3786 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2326.00.1'
20241219@134144.3816 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.3833 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.3897 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.3912 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.3920 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.3932 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2400475600a'
20241219@134144.3950 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.3995 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.4189 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642349106764229860','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.4208 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.4244 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.4287 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642349106764229860',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',126.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241219@134144.4543 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134144.4547 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2317.00.1'
20241219@134144.4575 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2317.00.1'
20241219@134144.4734 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.4811 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.4835 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.4851 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.4859 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.4870 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2317.00.1' and lote = 'r2400475100a'
20241219@134144.4884 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.4912 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.4923 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642287336764229877','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.4927 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.4941 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.5008 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642287336764229877',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',108.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,200000,?,?,?,?,?)
20241219@134144.5287 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.5311 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.5347 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.5362 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.5406 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.5451 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.5476 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.5499 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642563726764229885','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.5522 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.5552 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.5615 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67642563726764229885',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676427110667642296a9' ,0,0 ,2,23.00,210000,?,?,?)
20241219@134144.5865 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134144.5869 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2317.00.1'
20241219@134144.5931 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2317.00.1'
20241219@134144.5965 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.5988 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.6038 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.6083 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.6091 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.6104 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2317.00.1' and lote = 'r2400475100a'
20241219@134144.6173 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.6195 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.6206 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67642703686764229896','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.6211 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.6224 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.6318 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67642703686764229896',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',144.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,230000,?,?,?,?,?)
20241219@134144.6642 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.6662 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.6715 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.6767 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.6776 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.6796 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.6811 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.6823 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676423379567642298a5','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.6828 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.6842 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.6884 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676423379567642298a5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676427110667642296a9' ,0,0 ,2,23.00,240000,?,?,?)
20241219@134144.7148 47ork68g50qubq485nvr3th49i Query : use flama_phc
20241219@134144.7152 47ork68g50qubq485nvr3th49i Query : select st.usalote valor from st where st.ref = '324.2318.00.1'
20241219@134144.7199 47ork68g50qubq485nvr3th49i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2318.00.1'
20241219@134144.7387 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.7413 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.7444 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.7473 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.7487 47ork68g50qubq485nvr3th49i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241219@134144.7503 47ork68g50qubq485nvr3th49i Query : select sestamp valor from se where ref ='324.2318.00.1' and lote = 'r2100669100a'
20241219@134144.7551 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.7624 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241219@134144.7644 47ork68g50qubq485nvr3th49i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676429166967642298b8','aut676427110667642296a9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241219@134144.7649 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.7664 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241219@134144.7715 47ork68g50qubq485nvr3th49i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676429166967642298b8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',40.000 ,'aut676427110667642296a9' ,0,0 ,2,23.00,260000,?,?,?,?,?)
20241219@134144.8296 47ork68g50qubq485nvr3th49i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241219@134144.8315 47ork68g50qubq485nvr3th49i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
