Posted on 2007-04-27 02:20
leekiang 閱讀(376)
評論(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 設置對話的非固定表。