ORDENT_GRDPRSVW

(SQL View)
 Index Back

Order Line Grid Fields

Defines the enterable fields on the sales order line grid (on page ORDENT_FORM_LINE).

SELECT U.MENUNAME , U.PNLGRPNAME , U.PNLNAME , P.PNLFIELDNAME , U.OPRID , U.PTCUSTOMFORMAT FROM PSUSEROBJTYPE U , PSPNLFIELD P WHERE P.PNLNAME = U.PNLNAME AND P.FIELDTYPE IN (19,27) AND P.PNLFIELDNAME IN ('ORD_LINE','ORD_SCHEDULE')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
4 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 PTCUSTOMFORMAT Long Character CLOB Personalization Custom Format