COUNTRYPrompt Table:
GP_COUNTRY
Set Control Field: COUNTRY
PIN_TAKE_NUMPrompt Table: GP_ABS_TAKE
FCST_CUSTOM_MSGE=Error
S=Success
W=Warning
EFFDTDefault Value: %date
LANGUAGE_CDGP_ABS_NRP_FLVW(SQL View) |
Index Back |
|---|---|
Forecasting Msg Rel. LanguageThis record is the related language for GP_ABS_FCST_MSG - NRP Views |
| SELECT COUNTRY , PIN_TAKE_NUM + 50000000 , FCST_CUSTOM_MSG , EFFDT , LANGUAGE_CD , FCST_VALUE FROM PS_GP_ABS_FCST_LNG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_COUNTRY
|
| 2 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_ABS_TAKE |
| 3 | FCST_CUSTOM_MSG |
Character(1) | VARCHAR2(1) NOT NULL |
This field is used to indicate what customize message to use for each of the major return status of Forecasting
E=Error S=Success W=Warning |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | FCST_VALUE | Character(30) | VARCHAR2(30) NOT NULL | This field is used to contain the value returned out of Forecasting. |