20230426@175832.7167 abhajt5leod4anm04k477it0o6 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175832.7171 abhajt5leod4anm04k477it0o6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175832.7181 abhajt5leod4anm04k477it0o6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175832.7192 abhajt5leod4anm04k477it0o6 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175832.7202 abhajt5leod4anm04k477it0o6 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut644952302364495838af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6449537866644958385d' ,0,0 ,2,23.00,70000,?,?,?)
20230426@175832.7406 abhajt5leod4anm04k477it0o6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175832.7419 abhajt5leod4anm04k477it0o6 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175832.7423 abhajt5leod4anm04k477it0o6 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut644952302364495838af','aut6449537866644958385d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175832.7428 abhajt5leod4anm04k477it0o6 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6449537866644958385d','','wait',39,'ari17112337378,753000005')
20230426@175832.7449 abhajt5leod4anm04k477it0o6 Query : use flama_phc
20230426@175832.7452 abhajt5leod4anm04k477it0o6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230426@175832.7464 abhajt5leod4anm04k477it0o6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='62';
20230426@175832.7475 abhajt5leod4anm04k477it0o6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='62';
20230426@175832.7484 abhajt5leod4anm04k477it0o6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='62';
20230426@175832.7494 abhajt5leod4anm04k477it0o6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='62';
20230426@175832.7793 buneqb7jnj6v3hglja47pvl310 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230426@175832.7805 buneqb7jnj6v3hglja47pvl310 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230426@175832.7820 buneqb7jnj6v3hglja47pvl310 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='63';
20230426@175832.7868 buneqb7jnj6v3hglja47pvl310 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='63';
20230426@175832.7879 buneqb7jnj6v3hglja47pvl310 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='63';
20230426@175832.7891 buneqb7jnj6v3hglja47pvl310 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='63';
20230426@175832.7901 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.7904 buneqb7jnj6v3hglja47pvl310 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230426@175832.7921 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.7924 buneqb7jnj6v3hglja47pvl310 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20230426@175832.7973 buneqb7jnj6v3hglja47pvl310 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1646.00.1'
20230426@175832.7985 buneqb7jnj6v3hglja47pvl310 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 3 and bi.ref ='324.1646.00.1' and bi.lordem =1
20230426@175832.8383 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.8387 buneqb7jnj6v3hglja47pvl310 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230426@175832.8401 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.8405 buneqb7jnj6v3hglja47pvl310 Query : select top 1 1 valor from td where td.ndoc = 39
20230426@175832.8416 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.8420 buneqb7jnj6v3hglja47pvl310 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230426@175832.8436 buneqb7jnj6v3hglja47pvl310 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230426@175832.8453 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.8456 buneqb7jnj6v3hglja47pvl310 Query : select top 1 ~inactivo valor from cl where no = '101597' and estab = 0 order by inactivo desc
20230426@175832.8468 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.8471 buneqb7jnj6v3hglja47pvl310 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230426@175832.8483 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.8486 buneqb7jnj6v3hglja47pvl310 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230426@175832.8498 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.8501 buneqb7jnj6v3hglja47pvl310 Query : select szadrsstamp valor from szadrs where szadrsdesc='101597 - auchan retail portugal , sa'
20230426@175832.8513 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.8516 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from td where ndoc = 39
20230426@175832.8528 buneqb7jnj6v3hglja47pvl310 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230426@175832.8541 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175832.8556 buneqb7jnj6v3hglja47pvl310 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230426@175832.8569 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175832.8585 buneqb7jnj6v3hglja47pvl310 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230426@175832.8589 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175832.8595 buneqb7jnj6v3hglja47pvl310 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175832.8637 buneqb7jnj6v3hglja47pvl310 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175832.8646 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175832.8653 buneqb7jnj6v3hglja47pvl310 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut644957082364495838d1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175832.8658 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175832.8672 buneqb7jnj6v3hglja47pvl310 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230426@175832.8677 buneqb7jnj6v3hglja47pvl310 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut644957082364495838d1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175832.8683 buneqb7jnj6v3hglja47pvl310 Query : select top 1 fno valor from wsft039data order by fno desc
20230426@175832.8695 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175832.8709 buneqb7jnj6v3hglja47pvl310 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230426@175832.8721 buneqb7jnj6v3hglja47pvl310 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,encomenda ) values ('aut644957082364495838d1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',23,101597,0,'2023-04-26',39,'euro',0,0,2023 ,'20230426','1828',?,?,?)
20230426@175832.8974 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.8978 buneqb7jnj6v3hglja47pvl310 Query : select st.usalote valor from st where st.ref = '324.1646.00.1'
20230426@175832.8991 buneqb7jnj6v3hglja47pvl310 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1646.00.1'
20230426@175832.9120 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175832.9135 buneqb7jnj6v3hglja47pvl310 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175832.9145 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175832.9159 buneqb7jnj6v3hglja47pvl310 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175832.9163 buneqb7jnj6v3hglja47pvl310 Query : select sestamp valor from se where ref ='324.1646.00.1' and lote = 'r2101259200a'
20230426@175832.9171 buneqb7jnj6v3hglja47pvl310 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175832.9181 buneqb7jnj6v3hglja47pvl310 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175832.9193 buneqb7jnj6v3hglja47pvl310 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175832.9205 buneqb7jnj6v3hglja47pvl310 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut644957539064495838e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2 ,'aut644957082364495838d1' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230426@175832.9424 buneqb7jnj6v3hglja47pvl310 Query : use flama_phc
20230426@175832.9428 buneqb7jnj6v3hglja47pvl310 Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20230426@175832.9439 buneqb7jnj6v3hglja47pvl310 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='63';
20230426@175832.9450 buneqb7jnj6v3hglja47pvl310 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='63';
20230426@175832.9761 7ffe0cqiuig7hm3vcnlepl8vd4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230426@175832.9774 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230426@175832.9787 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='64';
20230426@175832.9826 7ffe0cqiuig7hm3vcnlepl8vd4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='64';
20230426@175832.9837 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='64';
20230426@175832.9847 7ffe0cqiuig7hm3vcnlepl8vd4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='64';
20230426@175832.9857 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175832.9861 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230426@175832.9873 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175832.9876 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20230426@175832.9909 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2211.00.1'
20230426@175832.9922 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 4 and bi.ref ='324.2211.00.1' and bi.lordem =1
20230426@175833.2110 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.2150 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230426@175833.2300 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.2330 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 1 valor from td where td.ndoc = 39
20230426@175833.2430 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.2460 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230426@175833.2580 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230426@175833.2730 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.2760 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 ~inactivo valor from cl where no = '101597' and estab = 0 order by inactivo desc
20230426@175833.2870 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.2900 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230426@175833.3010 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.3040 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230426@175833.3150 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.3190 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select szadrsstamp valor from szadrs where szadrsdesc='101597 - auchan retail portugal , sa'
20230426@175833.3310 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.3340 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from td where ndoc = 39
20230426@175833.3450 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230426@175833.3570 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175833.3710 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230426@175833.3830 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175833.3960 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230426@175833.4000 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175833.4060 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175833.4500 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175833.4610 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175833.4670 7ffe0cqiuig7hm3vcnlepl8vd4 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495910786449583909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175833.4720 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175833.4880 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230426@175833.4930 7ffe0cqiuig7hm3vcnlepl8vd4 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495910786449583909',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175833.4980 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 fno valor from wsft039data order by fno desc
20230426@175833.5090 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175833.5230 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230426@175833.5360 7ffe0cqiuig7hm3vcnlepl8vd4 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,encomenda ) values ('aut64495910786449583909',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',23,101597,0,'2023-04-26',39,'euro',0,0,2023 ,'20230426','1828',?,?,?)
20230426@175833.7770 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.7810 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select st.usalote valor from st where st.ref = '324.2211.00.1'
20230426@175833.7940 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2211.00.1'
20230426@175833.9280 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175833.9440 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175833.9550 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175833.9680 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175833.9740 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select sestamp valor from se where ref ='324.2211.00.1' and lote = 'r2100703100a'
20230426@175833.9800 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175833.9910 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175833.1005 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175833.1017 7ffe0cqiuig7hm3vcnlepl8vd4 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495651006449583918',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6 ,'aut64495910786449583909' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230426@175833.1249 7ffe0cqiuig7hm3vcnlepl8vd4 Query : use flama_phc
20230426@175833.1253 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20230426@175833.1268 7ffe0cqiuig7hm3vcnlepl8vd4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='64';
20230426@175833.1281 7ffe0cqiuig7hm3vcnlepl8vd4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='64';
20230426@175833.1563 t93393df090s5tmubcnhda1f7u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230426@175833.1575 t93393df090s5tmubcnhda1f7u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230426@175833.1588 t93393df090s5tmubcnhda1f7u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='65';
20230426@175833.1624 t93393df090s5tmubcnhda1f7u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='65';
20230426@175833.1635 t93393df090s5tmubcnhda1f7u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='65';
20230426@175833.1645 t93393df090s5tmubcnhda1f7u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='65';
20230426@175833.1655 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.1658 t93393df090s5tmubcnhda1f7u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230426@175833.1673 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.1676 t93393df090s5tmubcnhda1f7u Query : select no, estab,szadrsdesc from szadrs where u_coddest=3674
20230426@175833.1708 t93393df090s5tmubcnhda1f7u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20230426@175833.1720 t93393df090s5tmubcnhda1f7u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 5 and bi.ref ='324.4960.00.1' and bi.lordem =1
20230426@175833.2010 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.2013 t93393df090s5tmubcnhda1f7u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230426@175833.2028 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.2031 t93393df090s5tmubcnhda1f7u Query : select top 1 1 valor from td where td.ndoc = 39
20230426@175833.2043 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.2047 t93393df090s5tmubcnhda1f7u Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230426@175833.2059 t93393df090s5tmubcnhda1f7u Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230426@175833.2074 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.2077 t93393df090s5tmubcnhda1f7u Query : select top 1 ~inactivo valor from cl where no = '199524' and estab = 0 order by inactivo desc
20230426@175833.2086 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.2089 t93393df090s5tmubcnhda1f7u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230426@175833.2099 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.2102 t93393df090s5tmubcnhda1f7u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230426@175833.2114 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.2118 t93393df090s5tmubcnhda1f7u Query : select szadrsstamp valor from szadrs where szadrsdesc='worten-equipamentos para o lar,sa.- az'
20230426@175833.2130 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.2133 t93393df090s5tmubcnhda1f7u Query : select 1 valor from td where ndoc = 39
20230426@175833.2144 t93393df090s5tmubcnhda1f7u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230426@175833.2155 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175833.2169 t93393df090s5tmubcnhda1f7u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230426@175833.2179 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175833.2193 t93393df090s5tmubcnhda1f7u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230426@175833.2199 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175833.2205 t93393df090s5tmubcnhda1f7u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175833.2249 t93393df090s5tmubcnhda1f7u Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175833.2258 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175833.2265 t93393df090s5tmubcnhda1f7u Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495216356449583935' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175833.2269 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175833.2282 t93393df090s5tmubcnhda1f7u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230426@175833.2286 t93393df090s5tmubcnhda1f7u Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495216356449583935',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175833.2291 t93393df090s5tmubcnhda1f7u Query : select top 1 fno valor from wsft039data order by fno desc
20230426@175833.2302 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175833.2317 t93393df090s5tmubcnhda1f7u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230426@175833.2330 t93393df090s5tmubcnhda1f7u Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,encomenda ) values ('aut64495216356449583935',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',23,199524,0,'2023-04-26',39,'euro',0,0,2023 ,'20230426','1828',?,?,?)
20230426@175833.2907 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.3362 t93393df090s5tmubcnhda1f7u Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20230426@175833.3379 t93393df090s5tmubcnhda1f7u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20230426@175833.3514 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175833.3527 t93393df090s5tmubcnhda1f7u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175833.3538 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175833.3551 t93393df090s5tmubcnhda1f7u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175833.3555 t93393df090s5tmubcnhda1f7u Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20230426@175833.3566 t93393df090s5tmubcnhda1f7u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175833.3577 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175833.3588 t93393df090s5tmubcnhda1f7u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175833.3598 t93393df090s5tmubcnhda1f7u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495196276449583957',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',384 ,'aut64495216356449583935' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230426@175833.3815 t93393df090s5tmubcnhda1f7u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175833.3831 t93393df090s5tmubcnhda1f7u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175833.3835 t93393df090s5tmubcnhda1f7u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495196276449583957','aut64495216356449583935' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175833.3841 t93393df090s5tmubcnhda1f7u Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut64495216356449583935','','wait',39,'ari17112337378,753000005')
20230426@175833.3858 t93393df090s5tmubcnhda1f7u Query : use flama_phc
20230426@175833.3861 t93393df090s5tmubcnhda1f7u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230426@175833.3874 t93393df090s5tmubcnhda1f7u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='65';
20230426@175833.3887 t93393df090s5tmubcnhda1f7u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='65';
20230426@175833.3897 t93393df090s5tmubcnhda1f7u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='65';
20230426@175833.3908 t93393df090s5tmubcnhda1f7u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='65';
20230426@175833.4226 f8odfic4d17tm50ash8d0kvd02 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230426@175833.4239 f8odfic4d17tm50ash8d0kvd02 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230426@175833.4254 f8odfic4d17tm50ash8d0kvd02 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='66';
20230426@175833.4293 f8odfic4d17tm50ash8d0kvd02 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='66';
20230426@175833.4305 f8odfic4d17tm50ash8d0kvd02 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='66';
20230426@175833.4318 f8odfic4d17tm50ash8d0kvd02 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='66';
20230426@175833.4329 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.4332 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230426@175833.4347 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.4351 f8odfic4d17tm50ash8d0kvd02 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4804
20230426@175833.4443 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4901.00.1'
20230426@175833.4607 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 6 and bi.ref ='324.4901.00.1' and bi.lordem =1
20230426@175833.4889 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4963.00.1'
20230426@175833.4901 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 6 and bi.ref ='324.4963.00.1' and bi.lordem =2
20230426@175833.5176 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4964.00.1'
20230426@175833.5189 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 6 and bi.ref ='324.4964.00.1' and bi.lordem =3
20230426@175833.5564 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4724.00.1'
20230426@175833.5700 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 6 and bi.ref ='324.4724.00.1' and bi.lordem =4
20230426@175833.6016 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.6020 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230426@175833.6033 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.6037 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 1 valor from td where td.ndoc = 39
20230426@175833.6048 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.6051 f8odfic4d17tm50ash8d0kvd02 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230426@175833.6063 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230426@175833.6078 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.6082 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 ~inactivo valor from cl where no = '101900' and estab = 0 order by inactivo desc
20230426@175833.6172 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.6175 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230426@175833.6188 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.6191 f8odfic4d17tm50ash8d0kvd02 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230426@175833.6202 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.6206 f8odfic4d17tm50ash8d0kvd02 Query : select szadrsstamp valor from szadrs where szadrsdesc='101900 - pd - alfena n/p'
20230426@175833.6220 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.6223 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from td where ndoc = 39
20230426@175833.6233 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230426@175833.6245 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175833.6259 f8odfic4d17tm50ash8d0kvd02 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230426@175833.6270 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175833.6283 f8odfic4d17tm50ash8d0kvd02 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230426@175833.6288 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175833.6295 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175833.6338 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175833.6349 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175833.6355 f8odfic4d17tm50ash8d0kvd02 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495625436449583999' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175833.6361 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175833.6374 f8odfic4d17tm50ash8d0kvd02 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230426@175833.6379 f8odfic4d17tm50ash8d0kvd02 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495625436449583999',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175833.6384 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 fno valor from wsft039data order by fno desc
20230426@175833.6395 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175833.6408 f8odfic4d17tm50ash8d0kvd02 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230426@175833.6422 f8odfic4d17tm50ash8d0kvd02 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,encomenda ) values ('aut64495625436449583999',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24,101900,0,'2023-04-26',39,'euro',0,0,2023 ,'20230426','1828',?,?,?)
20230426@175833.6697 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.6702 f8odfic4d17tm50ash8d0kvd02 Query : select st.usalote valor from st where st.ref = '324.4901.00.1'
20230426@175833.6716 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4901.00.1'
20230426@175833.6871 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175833.6886 f8odfic4d17tm50ash8d0kvd02 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175833.6896 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175833.6909 f8odfic4d17tm50ash8d0kvd02 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175833.6913 f8odfic4d17tm50ash8d0kvd02 Query : select sestamp valor from se where ref ='324.4901.00.1' and lote = 'r2200240200a'
20230426@175833.6919 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175833.6928 f8odfic4d17tm50ash8d0kvd02 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175833.6940 f8odfic4d17tm50ash8d0kvd02 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175833.6950 f8odfic4d17tm50ash8d0kvd02 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut644951479364495839a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',28 ,'aut64495625436449583999' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230426@175833.7178 f8odfic4d17tm50ash8d0kvd02 Query : use flama_phc
20230426@175833.7182 f8odfic4d17tm50ash8d0kvd02 Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20230426@175833.7194 f8odfic4d17tm50ash8d0kvd02 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='66';
20230426@175833.7204 f8odfic4d17tm50ash8d0kvd02 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='66';
20230426@175833.7616 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230426@175833.7630 69ersj7bj4dkjfc0ultkfbvdsj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230426@175833.7644 69ersj7bj4dkjfc0ultkfbvdsj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='67';
20230426@175833.7682 69ersj7bj4dkjfc0ultkfbvdsj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='67';
20230426@175833.7694 69ersj7bj4dkjfc0ultkfbvdsj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='67';
20230426@175833.7705 69ersj7bj4dkjfc0ultkfbvdsj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='67';
20230426@175833.7716 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175833.7720 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230426@175833.7733 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175833.7736 69ersj7bj4dkjfc0ultkfbvdsj Query : select no, estab,szadrsdesc from szadrs where u_coddest=2686
20230426@175833.7805 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20230426@175833.8009 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.988.00.01' and bi.lordem =1
20230426@175833.8467 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20230426@175833.8480 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='304.422.00.07' and bi.lordem =2
20230426@175833.8805 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4840.00.1'
20230426@175833.8934 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.4840.00.1' and bi.lordem =3
20230426@175833.9217 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4211.00.1'
20230426@175833.9340 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='304.4211.00.1' and bi.lordem =4
20230426@175833.9622 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20230426@175833.9633 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.1816.00.1' and bi.lordem =5
20230426@175834.5500 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20230426@175834.1300 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.1816.00.1' and bi.lordem =6
20230426@175834.4300 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1837.00.1'
20230426@175834.5590 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.1837.00.1' and bi.lordem =7
20230426@175834.8500 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4930.00.1'
20230426@175834.8610 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.4930.00.1' and bi.lordem =8
20230426@175834.1143 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.959.00.01'
20230426@175834.1155 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.959.00.01' and bi.lordem =9
20230426@175834.1448 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20230426@175834.1597 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.2066.00.1' and bi.lordem =10
20230426@175834.1896 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20230426@175834.2020 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.2031.00.1' and bi.lordem =11
20230426@175834.2294 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1461.00.1'
20230426@175834.2421 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.1461.00.1' and bi.lordem =12
20230426@175834.3382 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1462.00.1'
20230426@175834.3778 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.1462.00.1' and bi.lordem =13
20230426@175834.4092 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5540.00.1'
20230426@175834.4104 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.5540.00.1' and bi.lordem =14
20230426@175834.4388 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20230426@175834.4401 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='324.5342.00.1' and bi.lordem =15
20230426@175834.4672 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8171.00.1'
20230426@175834.4790 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 7 and bi.ref ='327.8171.00.1' and bi.lordem =16
20230426@175834.5058 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.5062 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230426@175834.5074 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.5077 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 1 valor from td where td.ndoc = 39
20230426@175834.5086 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.5089 69ersj7bj4dkjfc0ultkfbvdsj Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230426@175834.5099 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230426@175834.5113 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.5116 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 ~inactivo valor from cl where no = '102189' and estab = 0 order by inactivo desc
20230426@175834.5217 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.5220 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230426@175834.5232 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.5235 69ersj7bj4dkjfc0ultkfbvdsj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230426@175834.5246 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.5248 69ersj7bj4dkjfc0ultkfbvdsj Query : select szadrsstamp valor from szadrs where szadrsdesc='bom preÇo, lda.- entrega'
20230426@175834.5261 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.5263 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from td where ndoc = 39
20230426@175834.5273 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230426@175834.5285 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175834.5298 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230426@175834.5308 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175834.5321 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230426@175834.5325 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175834.5332 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175834.5371 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175834.5381 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175834.5387 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.5392 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175834.5404 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230426@175834.5408 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495279466449583a82',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.5417 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 fno valor from wsft039data order by fno desc
20230426@175834.5429 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175834.5443 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230426@175834.5453 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,encomenda ) values ('aut64495279466449583a82',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24,102189,0,'2023-04-26',39,'euro',0,0,2023 ,'20230426','1828',?,?,?)
20230426@175834.5697 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.5700 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20230426@175834.5713 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.988.00.01'
20230426@175834.5837 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.5857 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175834.5867 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.5881 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175834.5885 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2200267200a'
20230426@175834.5896 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175834.5906 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.5918 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175834.5929 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495202326449583a90',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2 ,'aut64495279466449583a82' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230426@175834.6143 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.6156 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175834.6161 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495202326449583a90','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.6165 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.6168 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '304.422.00.07'
20230426@175834.6178 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.422.00.07'
20230426@175834.6189 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.6202 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175834.6212 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.6225 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175834.6229 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='304.422.00.07' and lote = '230334'
20230426@175834.6240 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175834.6250 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.6262 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175834.6271 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495437586449583a98',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4 ,'aut64495279466449583a82' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20230426@175834.6515 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.6534 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175834.6540 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495437586449583a98','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.6544 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.6548 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.4840.00.1'
20230426@175834.6560 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4840.00.1'
20230426@175834.6690 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.6707 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175834.6719 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.6733 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175834.6738 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.4840.00.1' and lote = 'r2101353200a'
20230426@175834.6751 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175834.6762 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.6775 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175834.6786 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495325676449583aa5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2 ,'aut64495279466449583a82' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20230426@175834.7011 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.7026 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175834.7031 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495325676449583aa5','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.7035 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.7079 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '304.4211.00.1'
20230426@175834.8005 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4211.00.1'
20230426@175834.8133 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.8145 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175834.8154 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.8166 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175834.8170 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='304.4211.00.1' and lote = '220034'
20230426@175834.8199 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175834.8208 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.8219 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175834.8228 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495775386449583ac8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2 ,'aut64495279466449583a82' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20230426@175834.8461 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.8475 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175834.8479 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495775386449583ac8','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.8483 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.8486 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20230426@175834.8496 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20230426@175834.8506 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.8517 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175834.8526 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.8538 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175834.8542 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2200645200a'
20230426@175834.8551 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175834.8560 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.8571 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175834.8581 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495065086449583ad0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7 ,'aut64495279466449583a82' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20230426@175834.8790 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.8803 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175834.8807 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495065086449583ad0','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.8812 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.8824 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175834.8834 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.8846 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175834.8850 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175834.8860 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.8872 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175834.8882 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut64495820606449583ad8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64495279466449583a82' ,0,0 ,2,23.00,60000,?,?,?)
20230426@175834.9088 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.9102 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175834.9107 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495820606449583ad8','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.9112 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.9115 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20230426@175834.9127 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20230426@175834.9140 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.9153 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175834.9163 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.9177 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175834.9182 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2200645200a'
20230426@175834.9191 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175834.9200 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.9212 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175834.9222 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495406656449583ae0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1 ,'aut64495279466449583a82' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20230426@175834.9425 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.9454 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175834.9459 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495406656449583ae0','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.9464 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.9476 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175834.9486 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.9497 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175834.9501 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175834.9510 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.9522 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175834.9532 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut64495455456449583ae8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64495279466449583a82' ,0,0 ,2,23.00,90000,?,?,?)
20230426@175834.9741 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.9754 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175834.9758 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495455456449583ae8','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175834.9762 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175834.9765 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.1837.00.1'
20230426@175834.9779 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1837.00.1'
20230426@175834.9907 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.9920 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175834.9929 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175834.9943 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175834.9947 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.1837.00.1' and lote = 'r2200668100a'
20230426@175834.9957 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175834.9968 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175834.9980 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175834.9989 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495678566449583af3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1 ,'aut64495279466449583a82' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20230426@175835.2010 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.2160 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.2210 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495678566449583af3','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.2260 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175835.2290 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.4930.00.1'
20230426@175835.2400 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4930.00.1'
20230426@175835.2510 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.2640 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.2740 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.2860 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.2910 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.4930.00.1' and lote = 'r2100754100a'
20230426@175835.3010 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.3100 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.3220 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.3320 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495036336449583b07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6 ,'aut64495279466449583a82' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20230426@175835.6240 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.6400 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.6450 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495036336449583b07','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.6510 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175835.6540 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.959.00.01'
20230426@175835.6660 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.959.00.01'
20230426@175835.6790 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.6930 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.7030 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.7150 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.7190 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.959.00.01' and lote = 'r2100174200a'
20230426@175835.7280 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.7380 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.7490 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.7580 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495445036449583b12',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4 ,'aut64495279466449583a82' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20230426@175835.9780 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.9920 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.9960 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495445036449583b12','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.1000 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175835.1003 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20230426@175835.1013 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2066.00.1'
20230426@175835.1023 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.1036 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.1045 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.1056 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.1059 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2100893200a'
20230426@175835.1069 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.1078 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.1089 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.1098 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495008636449583b1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6 ,'aut64495279466449583a82' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20230426@175835.1381 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.1397 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.1401 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495008636449583b1a','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.1406 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.1418 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.1426 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.1437 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.1441 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.1450 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.1462 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.1471 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut64495869216449583b23',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64495279466449583a82' ,0,0 ,2,23.00,150000,?,?,?)
20230426@175835.1686 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.1700 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.1704 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495869216449583b23','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.1708 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175835.1711 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20230426@175835.1721 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2031.00.1'
20230426@175835.1846 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.1858 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.1867 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.1878 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.1882 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20230426@175835.1892 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.1901 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.1912 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.1921 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495428626449583b2e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6 ,'aut64495279466449583a82' ,0,0 ,2,23.00,170000,?,?,?,?,?)
20230426@175835.2127 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.2140 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.2144 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495428626449583b2e','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.2149 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.2161 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.2171 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.2182 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.2186 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.2195 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.2206 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.2215 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut64495965796449583b35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64495279466449583a82' ,0,0 ,2,23.00,180000,?,?,?)
20230426@175835.2441 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.2454 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.2458 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495965796449583b35','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.2463 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175835.2466 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.1461.00.1'
20230426@175835.2477 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1461.00.1'
20230426@175835.2599 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.2611 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.2620 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.2632 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.2636 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.1461.00.1' and lote = 'r2100211200a'
20230426@175835.2647 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.2655 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.2667 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.2675 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495350436449583b40',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1 ,'aut64495279466449583a82' ,0,0 ,2,23.00,200000,?,?,?,?,?)
20230426@175835.2884 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.2898 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.2902 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495350436449583b40','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.2906 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175835.2909 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.1462.00.1'
20230426@175835.2922 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1462.00.1'
20230426@175835.3043 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.3055 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.3064 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.3076 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.3080 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.1462.00.1' and lote = 'r2101096200a'
20230426@175835.3091 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.3100 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.3112 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.3122 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495313776449583b4b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1 ,'aut64495279466449583a82' ,0,0 ,2,23.00,210000,?,?,?,?,?)
20230426@175835.3341 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.3355 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.3359 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495313776449583b4b','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.3363 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175835.3366 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.5540.00.1'
20230426@175835.3443 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5540.00.1'
20230426@175835.3453 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.3465 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.3474 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.3486 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.3490 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.5540.00.1' and lote = 'r2101288200a'
20230426@175835.3500 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.3508 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.3520 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.3529 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495886746449583b55',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2 ,'aut64495279466449583a82' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20230426@175835.3747 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.3761 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.3765 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495886746449583b55','aut64495279466449583a82' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.3769 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175835.3772 69ersj7bj4dkjfc0ultkfbvdsj Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20230426@175835.3783 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5342.00.1'
20230426@175835.3912 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.3925 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.3935 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.3946 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.3950 69ersj7bj4dkjfc0ultkfbvdsj Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = '06/20'
20230426@175835.3955 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.3964 69ersj7bj4dkjfc0ultkfbvdsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.3977 69ersj7bj4dkjfc0ultkfbvdsj Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.3988 69ersj7bj4dkjfc0ultkfbvdsj Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495678906449583b60',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6 ,'aut64495279466449583a82' ,0,0 ,2,23.00,230000,?,?,?,?,?)
20230426@175835.4980 69ersj7bj4dkjfc0ultkfbvdsj Query : use flama_phc
20230426@175835.4985 69ersj7bj4dkjfc0ultkfbvdsj Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20230426@175835.4997 69ersj7bj4dkjfc0ultkfbvdsj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='67';
20230426@175835.5006 69ersj7bj4dkjfc0ultkfbvdsj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='67';
20230426@175835.5305 uurjph2sgvv1ga0i4c8uteehlh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230426@175835.5318 uurjph2sgvv1ga0i4c8uteehlh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230426@175835.5399 uurjph2sgvv1ga0i4c8uteehlh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='68';
20230426@175835.5439 uurjph2sgvv1ga0i4c8uteehlh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='68';
20230426@175835.5450 uurjph2sgvv1ga0i4c8uteehlh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='68';
20230426@175835.5460 uurjph2sgvv1ga0i4c8uteehlh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='68';
20230426@175835.5470 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.5473 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230426@175835.5487 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.5490 uurjph2sgvv1ga0i4c8uteehlh Query : select no, estab,szadrsdesc from szadrs where u_coddest=1024
20230426@175835.5558 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5540.00.1'
20230426@175835.5570 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 8 and bi.ref ='324.5540.00.1' and bi.lordem =1
20230426@175835.5863 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.5867 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230426@175835.5879 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.5882 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 1 valor from td where td.ndoc = 39
20230426@175835.5892 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.5894 uurjph2sgvv1ga0i4c8uteehlh Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230426@175835.5904 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230426@175835.5917 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.5920 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 ~inactivo valor from cl where no = '102328' and estab = 0 order by inactivo desc
20230426@175835.6008 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.6011 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230426@175835.6021 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.6024 uurjph2sgvv1ga0i4c8uteehlh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230426@175835.6034 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.6037 uurjph2sgvv1ga0i4c8uteehlh Query : select szadrsstamp valor from szadrs where szadrsdesc='cor e som electrodomÉsticos, lda.'
20230426@175835.6049 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.6051 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from td where ndoc = 39
20230426@175835.6061 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230426@175835.6071 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175835.6085 uurjph2sgvv1ga0i4c8uteehlh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230426@175835.6094 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175835.6106 uurjph2sgvv1ga0i4c8uteehlh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230426@175835.6110 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175835.6116 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175835.6156 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175835.6165 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175835.6170 uurjph2sgvv1ga0i4c8uteehlh Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495675706449583b95' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.6175 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175835.6187 uurjph2sgvv1ga0i4c8uteehlh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230426@175835.6191 uurjph2sgvv1ga0i4c8uteehlh Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495675706449583b95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.6195 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 fno valor from wsft039data order by fno desc
20230426@175835.6205 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175835.6217 uurjph2sgvv1ga0i4c8uteehlh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230426@175835.6226 uurjph2sgvv1ga0i4c8uteehlh Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,encomenda ) values ('aut64495675706449583b95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24,102328,0,'2023-04-26',39,'euro',0,0,2023 ,'20230426','1828',?,?,?)
20230426@175835.6496 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.6500 uurjph2sgvv1ga0i4c8uteehlh Query : select st.usalote valor from st where st.ref = '324.5540.00.1'
20230426@175835.6511 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5540.00.1'
20230426@175835.6522 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.6534 uurjph2sgvv1ga0i4c8uteehlh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175835.6543 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.6555 uurjph2sgvv1ga0i4c8uteehlh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175835.6559 uurjph2sgvv1ga0i4c8uteehlh Query : select sestamp valor from se where ref ='324.5540.00.1' and lote = 'r2101288200a'
20230426@175835.6569 uurjph2sgvv1ga0i4c8uteehlh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175835.6579 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175835.6590 uurjph2sgvv1ga0i4c8uteehlh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175835.6599 uurjph2sgvv1ga0i4c8uteehlh Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495787026449583ba0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2 ,'aut64495675706449583b95' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230426@175835.6819 uurjph2sgvv1ga0i4c8uteehlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175835.6834 uurjph2sgvv1ga0i4c8uteehlh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175835.6838 uurjph2sgvv1ga0i4c8uteehlh Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495787026449583ba0','aut64495675706449583b95' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175835.6843 uurjph2sgvv1ga0i4c8uteehlh Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut64495675706449583b95','','wait',39,'ari17112337378,753000005')
20230426@175835.6858 uurjph2sgvv1ga0i4c8uteehlh Query : use flama_phc
20230426@175835.6861 uurjph2sgvv1ga0i4c8uteehlh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230426@175835.6872 uurjph2sgvv1ga0i4c8uteehlh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='68';
20230426@175835.6882 uurjph2sgvv1ga0i4c8uteehlh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='68';
20230426@175835.6893 uurjph2sgvv1ga0i4c8uteehlh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='68';
20230426@175835.6902 uurjph2sgvv1ga0i4c8uteehlh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='68';
20230426@175835.7205 7b4mbja1hgkhbpienll8jh69eq Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230426@175835.7217 7b4mbja1hgkhbpienll8jh69eq Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230426@175835.7229 7b4mbja1hgkhbpienll8jh69eq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='69';
20230426@175835.7265 7b4mbja1hgkhbpienll8jh69eq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='69';
20230426@175835.7276 7b4mbja1hgkhbpienll8jh69eq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='69';
20230426@175835.7286 7b4mbja1hgkhbpienll8jh69eq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='69';
20230426@175835.7295 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175835.7298 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230426@175835.7310 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175835.7313 7b4mbja1hgkhbpienll8jh69eq Query : select no, estab,szadrsdesc from szadrs where u_coddest=829
20230426@175835.7414 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20230426@175835.7426 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 9 and bi.ref ='324.1824.00.1' and bi.lordem =1
20230426@175835.7723 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20230426@175835.7854 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 9 and bi.ref ='324.1834.00.1' and bi.lordem =2
20230426@175835.8140 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20230426@175835.8264 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 9 and bi.ref ='324.1879.00.1' and bi.lordem =3
20230426@175835.8559 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.719.00.01'
20230426@175835.8688 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 9 and bi.ref ='324.719.00.01' and bi.lordem =4
20230426@175835.8973 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.724.00.01'
20230426@175835.9103 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 9 and bi.ref ='324.724.00.01' and bi.lordem =5
20230426@175835.9384 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20230426@175835.9511 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 9 and bi.ref ='324.727.00.01' and bi.lordem =6
20230426@175835.9794 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.711.00.01'
20230426@175835.9922 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =231 and bo.boano =2011 and bo.obrano = 9 and bi.ref ='324.711.00.01' and bi.lordem =7
20230426@175836.2880 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.3490 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230426@175836.4970 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.5180 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 1 valor from td where td.ndoc = 39
20230426@175836.5300 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.5330 7b4mbja1hgkhbpienll8jh69eq Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230426@175836.5430 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230426@175836.5570 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.5610 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 ~inactivo valor from cl where no = '101684' and estab = 0 order by inactivo desc
20230426@175836.7860 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.8670 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230426@175836.8800 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.8830 7b4mbja1hgkhbpienll8jh69eq Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230426@175836.8940 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.8970 7b4mbja1hgkhbpienll8jh69eq Query : select szadrsstamp valor from szadrs where szadrsdesc='martins & correia,lda'
20230426@175836.9150 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.9180 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from td where ndoc = 39
20230426@175836.9270 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230426@175836.9380 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175836.1048 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230426@175836.1090 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175836.1103 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230426@175836.1107 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175836.1114 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175836.1154 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230426@175836.1164 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230426@175836.1171 7b4mbja1hgkhbpienll8jh69eq Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495128316449583c1b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175836.1176 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230426@175836.1188 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230426@175836.1192 7b4mbja1hgkhbpienll8jh69eq Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495128316449583c1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175836.1197 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 fno valor from wsft039data order by fno desc
20230426@175836.1206 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230426@175836.1219 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230426@175836.1233 7b4mbja1hgkhbpienll8jh69eq Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,encomenda ) values ('aut64495128316449583c1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',25,101684,0,'2023-04-26',39,'euro',0,0,2023 ,'20230426','1828',?,?,?)
20230426@175836.1476 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.1480 7b4mbja1hgkhbpienll8jh69eq Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20230426@175836.1491 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20230426@175836.1502 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175836.1521 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175836.1532 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175836.1546 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175836.1550 7b4mbja1hgkhbpienll8jh69eq Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2200671200a'
20230426@175836.1561 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175836.1571 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175836.1584 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175836.1594 7b4mbja1hgkhbpienll8jh69eq Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495279976449583c26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3 ,'aut64495128316449583c1b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230426@175836.1817 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175836.1832 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175836.1838 7b4mbja1hgkhbpienll8jh69eq Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495279976449583c26','aut64495128316449583c1b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175836.1843 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175836.1857 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175836.1868 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175836.1883 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175836.1888 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175836.1899 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175836.1912 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175836.1923 7b4mbja1hgkhbpienll8jh69eq Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut64495301516449583c2e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64495128316449583c1b' ,0,0 ,2,23.00,20000,?,?,?)
20230426@175836.2134 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175836.2149 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175836.2154 7b4mbja1hgkhbpienll8jh69eq Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495301516449583c2e','aut64495128316449583c1b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175836.2158 7b4mbja1hgkhbpienll8jh69eq Query : use flama_phc
20230426@175836.2162 7b4mbja1hgkhbpienll8jh69eq Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20230426@175836.2174 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1834.00.1'
20230426@175836.2310 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175836.2324 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175836.2335 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175836.2350 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230426@175836.2355 7b4mbja1hgkhbpienll8jh69eq Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2200671100a'
20230426@175836.2368 7b4mbja1hgkhbpienll8jh69eq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230426@175836.2379 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175836.2392 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230426@175836.2402 7b4mbja1hgkhbpienll8jh69eq Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut64495538506449583c3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1 ,'aut64495128316449583c1b' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20230426@175836.2637 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230426@175836.2652 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230426@175836.2657 7b4mbja1hgkhbpienll8jh69eq Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64495538506449583c3a','aut64495128316449583c1b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230426@175836.2662 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230426@175836.2676 7b4mbja1hgkhbpienll8jh69eq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230426@175836.2687 7b4mbja1hgkhbpienll8jh69eq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
