BI_LINE_IM_VW

(SQL View)
 Index Back

Fieldname Prompt View

This view is used as the Fieldname prompt view on the Invoice Maintenance Change grid. For 9.1 the only valid values are the 3 PC chartfields: Resource_Type, Resource_Category, Resource_Sub_Cat.

SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B , PSDBFIELD C , PS_FS_CF_TEMPLATE D WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDNAME = C.FIELDNAME AND A.FIELDNAME = D.ORIG_CF_NAME AND B.DEFAULT_LABEL = 1 AND D.CF_ACTIVE_STATUS = 'A' AND D.DELETE_CF = 'N' AND A.RECNAME IN ('BI_LINE', 'PC_CF1_N_SBR') AND A.FIELDNAME IN ('RESOURCE_TYPE', 'RESOURCE_CATEGORY', 'RESOURCE_SUB_CAT')

  • Related Language Record: BI_LINE_IM_LVW

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