PV_MERCH_FLD_VW

(SQL View)
 Index Back

Records for a field

This view brings up all the records for a field, accounting for sub records.

SELECT DISTINCT FIELDNAME FROM PSRECFIELD WHERE RECNAME='PV_DC_REQ_LINE' OR RECNAME = 'REQ_LINE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).