RS_FR_SUP_LVW

(SQL View)
Index Back

Supply forecast Search

ESA for IT: Supply forecast Search Language record for RS_FR_SUP_SRCH

SELECT A.FORECAST_ID_SUP , B.DESCR , A.FROM_MONTH_SCP , A.FROM_YEAR , A.TO_MONTH_SCP , A.TO_YEAR , B.LANGUAGE_CD FROM PS_RS_FR_SUP_HDR A , PS_RS_FR_SUP_LNG B WHERE A.FORECAST_ID_SUP = B.FORECAST_ID_SUP

  • Related Language Record for RS_FR_SUP_SRCH
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORECAST_ID_SUP Character(15) VARCHAR2(15) NOT NULL Supply Forecast ID

    Default Value: NEXT

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 FROM_MONTH_SCP Character(2) VARCHAR2(2) NOT NULL SCP- From Month
    1=01 - January
    10=10 - October
    11=11 - November
    12=12 - December
    2=02 - February
    3=03 - March
    4=04 - April
    5=05 - May
    6=06 - June
    7=07 - July
    8=08 - August
    9=09 - September
    4 FROM_YEAR Number(4,0) SMALLINT NOT NULL From Year
    5 TO_MONTH_SCP Character(2) VARCHAR2(2) NOT NULL SCP- To Month
    1=01 - January
    10=10 - October
    11=11 - November
    12=12 - December
    2=02 - February
    3=03 - March
    4=04 - April
    5=05 - May
    6=06 - June
    7=07 - July
    8=08 - August
    9=09 - September
    6 TO_YEAR Number(4,0) SMALLINT NOT NULL To Year
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code