| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DP_CONFIGVIEW |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
|
| 2 |
DP_CONFIGLEVEL |
Number(2,0) |
SMALLINT NOT NULL |
DP_CONFIGLEVEL
|
| 3 |
DP_FORECASTITEM |
Character(120) |
VARCHAR2(120) NOT NULL |
DP_FORECASTITEM
|
| 4 |
DP_FCST_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Forecast Year
|
| 5 |
DP_FCST_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
DP_FCST_PERIOD
|
| 6 |
DP_ACTUALDEMAND |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_ACTUALDEMAND
|
| 7 |
DP_ADJDEMAND |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Adjusted Demand
|
| 8 |
DP_DEMANDVALUE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_DEMANDVALUE
|
| 9 |
DP_STATFORECAST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_STATFORECAST
|
| 10 |
DP_PROFORECAST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_PROFORECAST
|
| 11 |
DP_ADJFORECAST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ADJFORECAST
|
| 12 |
DP_FORECASTADJ |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECASTADJ
|
| 13 |
DP_SUMMFORECAST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_SUMMFORECAST
|
| 14 |
DP_EVALSTATFORE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_EVALSTATFORE
|
| 15 |
DP_EVALADJFORE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_EVALADJFORE
|
| 16 |
DP_EVALPRORFORE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_EVALPRORFORE
|
| 17 |
DP_PERIODPRICE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_PERIODPRICE
|
| 18 |
DP_PERIODCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_PERIODCOST
|
| 19 |
DP_RESULTANTADJ |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_RESULTANTADJ
|
| 20 |
DP_PERIODAVGPRICE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_PERIODAVGPRICE
|
| 21 |
DP_USERDATA01 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA01
|
| 22 |
DP_USERDATA02 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA02
|
| 23 |
DP_USERDATA03 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA03
|
| 24 |
DP_USERDATA04 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA04
|
| 25 |
DP_USERDATA05 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA05
|
| 26 |
DP_USERDATA06 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA06
|
| 27 |
DP_USERDATA07 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_USERDATA07
|
| 28 |
DP_FORECAST01 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST01
|
| 29 |
DP_FORECAST02 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST02
|
| 30 |
DP_FORECAST03 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST03
|
| 31 |
DP_FORECAST04 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST04
|
| 32 |
DP_FORECAST05 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST05
|
| 33 |
DP_FORECAST06 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST06
|
| 34 |
DP_FORECAST07 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST07
|
| 35 |
DP_FORECAST08 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST08
|
| 36 |
DP_FORECAST09 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST09
|
| 37 |
DP_FORECAST10 |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
DP_FORECAST10
|