TML4PAGEFLD_VW

(SQL View)
 Index Back

List of hidden Page Fields

This shows the hidden fields on the Item Template Pages

SELECT DISTINCT RECNAME , FIELDNAME FROM PSPNLFIELD WHERE FIELDNAME <> ' ' AND (RECNAME %Like('%TML4%') OR RECNAME='MASTER_ITEM_SBR') AND (%Truncate((FIELDUSE/2),0) - %Truncate((FIELDUSE/4),0)*2) = 0

# 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).