WC_FIELDNAME_VW

(SQL View)
 Index Back

Dyn Role recfield view

This is the view that shows all fields for the selected record.

SELECT RECNAME , FIELDNAME FROM PSRECFIELD WHERE FIELDNAME IN ('CUST_ID', 'SOLD_TO_CUST_ID', 'SHIP_TO_CUST_ID', 'BILL_TO_CUST_ID', 'CONTACT_ID')

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