RSF_FCFLT_IN_LN

(SQL View)
 Index Back

Forecast Filter Industry VW


SELECT DISTINCT A.FORECAST_ID , A.TIMEFRAME_PERIOD , A.FORECAST_CATEGORY , A.INDUSTRY_ID , L.LANGUAGE_CD , L.DESCR50 FROM PS_RSF_FCAST_DTL A , PS_RSF_INDSTRY_LNG L WHERE A.INDUSTRY_ID =L.INDUSTRY_ID

  • Related Language Record for RSF_FCFLT_IN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORECAST_ID Character(15) VARCHAR2(15) NOT NULL Forecast Name
    2 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
    3 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
    R=Revenue Forecast
    S=Shadow Forecast
    4 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 INDUSTRYDESCR Character(50) VARCHAR2(50) NOT NULL Description