RF_INPRD_FLD_VW

(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.SHORTNAME , C.LONGNAME FROM PSRECFIELD A , PSDBFIELD B , PSDBFLDLABL C WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDNAME = C.FIELDNAME AND A.RECNAME = 'RF_INST_PROD' AND ((C.DEFAULT_LABEL = 0 AND C.FIELDNAME = 'INSTALLED_DATE' AND C.LABEL_ID = 'PURCHASE_DATE') OR (C.DEFAULT_LABEL = 1 AND C.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', 'ADDRESS4_AC', 'CITY_AC', 'INSTALLED_DATE', 'NODE_ID','BO_ID_PTNR_CMP','BO_ID_PTNR_CNT','ROLETYPE_PTNR_CMP','ROLETYPE_PTNR_CNT'))

  • Related Language Record: RF_INPRDFLD_LVW

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