DP_ADJ_SUMSTAGE

(SQL Table)
Index Back

DP_ADJ_SUMSTAGE

DP_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