RF_INPRDFLD_LVW

(SQL View)
 Index Back

Installed Product Field View

List of fields on the Installed product record that are possible fields used when registering the installed product.

SELECT A.RECNAME , A.FIELDNAME , C.LANGUAGE_CD , C.SHORTNAME , C.LONGNAME FROM PSRECFIELD A , PSDBFIELD B , PSDBFLDLABLLANG C , PSDBFLDLABL D WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDNAME = C.FIELDNAME AND D.FIELDNAME = C.FIELDNAME AND D.LABEL_ID = C.LABEL_ID AND A.RECNAME = 'RF_INST_PROD' AND ((D.DEFAULT_LABEL = 0 AND D.FIELDNAME = 'INSTALLED_DATE' AND D.LABEL_ID = 'PURCHASE_DATE') OR (D.DEFAULT_LABEL = 1 AND D.FIELDNAME <> 'INSTALLED_DATE') AND A.FIELDNAME NOT IN ('SETID', 'INST_PROD_ID', 'BO_ID_CUST', 'ROLE_TYPE_ID_CUST', 'BO_ID_CONTACT', 'ROLE_TYPE_ID_CNTCT', 'PRODUCT_ID', 'INST_PROD_STATUS', 'BUSINESS_UNIT_OM', 'TOPLEVELPOSITION', 'LEVEL1', 'POSITION', 'ORDERBY1', 'CAPTURE_ID', 'CONFIG_CODE', 'EXTERNAL_ID', 'INV_ITEM_ID', 'LINE_NBR', 'PARENT_INST_PRODID', 'PERSON_ID', 'PO_ID', 'QUANTITY', 'SALES_USER_ID', 'ADDRESS1_AC', 'ADDRESS2_AC', 'ADDRESS3_AC', 'CITY_AC', 'INSTALLED_DATE', 'NODE_ID'))

  • Related Language Record for RF_INPRD_FLD_VW RF_IPRD_FLD_VW2

    • # 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).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
    5 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name