DP_CONFIGVIEWDP_CONFIGLEVELDP_FORECASTITEMDP_YEARDP_PERIOD0=Not Adjusted
1=Direct
2=DePromoted
3=Filtered
0=Not Adjusted
1=Direct
0=Not Adjusted
1=Direct
2=DePromoted
3=Filtered
DP_DMD_SUMSTAGE(SQL Table) |
Index Back |
|---|---|
Summary of External Stage DataSummary of External Stage Data |
| # | 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_DMDVAL | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_OLD_DMDVAL |
| 7 | DP_OLD_ACTLDMD | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_OLD_ACTLDMD |
| 8 | DP_OLD_ADJDMD | Number(15,4) | DECIMAL(14,4) NOT NULL | DP_OLD_ADJDMD |
| 9 | DP_OLD_DMDPCODE | Character(1) | VARCHAR2(1) NOT NULL |
DP_OLD_DMDPCODE
0=Not Adjusted 1=Direct 2=DePromoted 3=Filtered |
| 10 | DP_STG_DMDVAL | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_STG_DMDVAL |
| 11 | DP_STG_ACTLDMD | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_STG_ACTLDMD |
| 12 | DP_STG_ADJDMD | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_STG_ADJDMD |
| 13 | DP_STG_DMDPCODE | Character(1) | VARCHAR2(1) NOT NULL |
DP_STG_DMDPCODE
0=Not Adjusted 1=Direct |
| 14 | DP_NEW_DMDVAL | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NEW_DMDVAL |
| 15 | DP_NEW_ACTLDMD | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NEW_ACTLDMD |
| 16 | DP_NEW_ADJDMD | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NEW_ADJDMD |
| 17 | DP_NEW_DMDPCODE | Character(1) | VARCHAR2(1) NOT NULL |
DP_NEW_DMDPCODE
0=Not Adjusted 1=Direct 2=DePromoted 3=Filtered |
| 18 | DP_UPD_DMD | Number(3,0) | SMALLINT NOT NULL | DP_UPD_DMD |
| 19 | DP_UPD_ACTL | Number(3,0) | SMALLINT NOT NULL | DP_UPD_ACTL |
| 20 | DP_UPD_ADJ | Number(3,0) | SMALLINT NOT NULL | DP_UPD_ADJ |
| 21 | DP_INHIBITED | Character(1) | VARCHAR2(1) NOT NULL | DP_INHIBITED |