DP_FCI_SUMSTAGE(SQL Table) |
Index Back |
|---|---|
Forecast Items InterfaceThis table is used as an intermediate table for loading ForecastItems from external (nonPS) sources. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_IMPORTSPEC | Character(20) | VARCHAR2(20) NOT NULL | Specification used for running imports |
| 2 | DP_CONFIGVIEW | Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW |
| 3 | DP_CONFIGLEVEL | Number(2,0) | SMALLINT NOT NULL | DP_CONFIGLEVEL |
| 4 | DP_FORECASTITEM | Character(120) | VARCHAR2(120) NOT NULL | DP_FORECASTITEM |
| 5 | DP_SEQNUMBER | Number(10,0) | DECIMAL(10) NOT NULL | MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field. |