CNT_TAB_VW

(SQL View)
 Index Back

Contract Left Panel View

PO0025 - Master Contract Fluid

SELECT C.PNLNAME , C.SUBITEMNUM , C.ITEMLABEL , C.ITEMLABEL FROM PSPNLGROUP C , PSPNLDEFN P WHERE C.PNLGRPNAME = 'CNT_GRPCNT_FL' AND C.PNLNAME = P.PNLNAME AND P.PNLTYPE = 0 AND C.HIDDEN = 0

  • Related Language Record: CNT_TAB_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
    2 SUBITEMNUM Number(4,0) SMALLINT NOT NULL Sub Item Number
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr