DP_ADJ_SUMSTAGE(SQL Table) |
Index Back |
---|---|
DP_ADJ_SUMSTAGEDP_ADJ_SUMSTAGE |
# | 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_YEAR | Number(4,0) | SMALLINT NOT NULL | DP_YEAR |
5 | DP_PERIOD | Number(3,0) | SMALLINT NOT NULL | DP_PERIOD |
6 | DP_OLD_ADJFORECAST | Number(15,4) | DECIMAL(14,4) NOT NULL | DP_OLD_ADJFORECAST |
7 | DP_OLD_FCPCODE | Character(1) | VARCHAR2(1) NOT NULL |
DP_OLD_FCPCODE
0=Not Adjusted/Prorated 1=Not Adjusted/Not Prorated 2=Direct/Prorated 3=Direct/Not Prorated 4=Promoted/Prorated 5=Promoted/Not Prorated 6=Event/Prorated 7=Event/Not Prorated |
8 | DP_ADJFORECAST | Number(15,4) | DECIMAL(14,4) NOT NULL | DP_ADJFORECAST |
9 | DP_FC_PROCESS_ACT | Character(1) | VARCHAR2(1) NOT NULL |
DP_FC_PROCESS_ACT
0=Not Adjusted/Prorated 1=Not Adjusted/Not Prorated 2=Direct/Prorated 3=Direct/Not Prorated 4=Promoted/Prorated 5=Promoted/Not Prorated 6=Event/Prorated 7=Event/Not Prorated |
10 | DP_NEW_ADJFORECAST | Number(15,4) | DECIMAL(14,4) NOT NULL | DP_NEW_ADJFORECAST |
11 | DP_NEW_FCPCODE | Character(1) | VARCHAR2(1) NOT NULL |
DP_NEW_FCPCODE
0=Not Adjusted/Prorated 1=Not Adjusted/Not Prorated 2=Direct/Prorated 3=Direct/Not Prorated 4=Promoted/Prorated 5=Promoted/Not Prorated 6=Event/Prorated 7=Event/Not Prorated |