RECFIELD_POL_VW

(SQL View)
 Index Back

View of Fields from psrecfield


SELECT DISTINCT A.RECNAME , A.FIELDNAME , '1' FROM PSRECFIELDALL A , PSPNLFIELD B , PSPNLDEFN C , PSDBFLDLABL D , PSPNLGROUP E WHERE A.RECNAME = 'PO_LINE' AND A.RECNAME = B.RECNAME AND B.SECUREINVISIBLE = '0' AND A.FIELDNAME = B.FIELDNAME AND B.PNLNAME = C.PNLNAME AND A.FIELDNAME = D.FIELDNAME AND E.PNLGRPNAME = 'PURCHASE_ORDER' AND C.OBJECTOWNERID = 'DPO' AND D.DEFAULT_LABEL = 1 AND (A.USEEDIT - ((A.USEEDIT / 2) * 2)) = 0 AND ((B.PNLNAME = E.PNLNAME AND E.HIDDEN = 0) OR EXISTS ( SELECT 'X' FROM PSPNLFIELD F WHERE B.PNLNAME = F.SUBPNLNAME AND F.FIELDTYPE = 18 AND F.PNLNAME = E.PNLNAME))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 LBL_TYPE Character(1) VARCHAR2(1) NOT NULL Label Type
1=Rec Long
2=Rec Short
3=Page
4=Custom
5=Panel