MDA/MDD/TDD/DDD/DDDDDDD
posts - 536, comments - 111, trackbacks - 0, articles - 0
  BlogJava :: 首页 :: 新随笔 :: 联系 :: 聚合  :: 管理

将采购申请行项目复制到询价单

Posted on 2007-04-27 02:20 leekiang 阅读(359) 评论(0)  编辑  收藏 所属分类: maximo
select *
  from prline t
 where linetype not in ('EXTERNAL')--generally is 'ITEM'
   and ponum is null
   and rfqnum is null
   and contractnum is null
   and prnum in
       (select prnum from pr where (status not in ('CLOSE', 'CAN'))) 

      maxvartype table contains the information of  all the maxvartype ,includes varname,vartype,
defaultsvalue,description(cn). vartype is one of site,system and org

the desc of  var "PRAPPROVAL" in app is "将采购申请转换为采购单或合同时需要批准?"
but in maxvartype table is "需要批准以将采购申请转换为采购单"
<dialog id="po" label="采购单选项" relationship="MAXVARINPUT4">
parent: ORGANIZATION  child:MAXVARINPUT   orgid=:orgid
MAXVARINPUT,psdi.app.system.virtual.MaxVarInputSet,用于 maxvar 设置对话的非固定表。

只有注册用户登录后才能发表评论。


网站导航: