RSF_FCAST_GRP(SQL Table) |
Index Back |
|---|---|
Forecast GroupGrouping for subtotals displays within forecast. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 2 | FORECAST_CHECKED | Character(1) | VARCHAR2(1) NOT NULL |
Checked
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 3 | FORECAST_GRP | Character(50) | VARCHAR2(50) NOT NULL | ****************************************************************************** PSFT-CUSTOMER1 Modification: ****************************************************************************** 07/09/01 Mei Hee - add C1_OTYP field label for Oppy type ****************************************************************************** |
| 4 | FORECAST_GRP1 | Character(50) | VARCHAR2(50) NOT NULL | ****************************************************************************** PSFT-CUSTOMER1 Modification: ****************************************************************************** 07/09/01 Mei Hee - add C1_OTYP field label for Oppy type ****************************************************************************** |
| 5 | FORECAST_GRP2 | Character(50) | VARCHAR2(50) NOT NULL | ****************************************************************************** PSFT-CUSTOMER1 Modification: ****************************************************************************** 07/09/01 Mei Hee - add C1_OTYP field label for Oppy type ****************************************************************************** |
| 6 | FORECAST_GRP_NUM | Number(5,0) | INTEGER NOT NULL | Numeric Forecast Group |
| 7 | FORECAST_GRP_NUM1 | Number(5,0) | INTEGER NOT NULL | Numeric Forecast Group |
| 8 | FORECAST_GRP_NUM2 | Number(5,0) | INTEGER NOT NULL | Numeric Forecast Group |
| 9 | FORECAST_GRP_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Subtotal |