RS_FR_SUP_LVW(SQL View) |
Index Back |
---|---|
Supply forecast SearchESA 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 |
# | 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 |