DP_CONFIGVIEWPrompt Table: DP_CONFIGVIEWS
DP_CONFIGLEVELPrompt Table: DP_CONFIGLEVELS
DP_FORECASTITEMPrompt Table: DP_FCSTACRCY_VW
DP_FCSTACRCY_VW(SQL View) |
Index Back |
|---|---|
DP_FCSTACRCY_VWDP_FCSTACRCY_VW |
| SELECT DISTINCT DP_CONFIGVIEW ,DP_CONFIGLEVEL ,DP_FORECASTITEM FROM PS_DP_FCITEMDATA |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_CONFIGVIEWS |
| 2 | DP_CONFIGLEVEL |
Number(2,0) | SMALLINT NOT NULL |
DP_CONFIGLEVEL
Prompt Table: DP_CONFIGLEVELS |
| 3 | DP_FORECASTITEM |
Character(120) | VARCHAR2(120) NOT NULL |
DP_FORECASTITEM
Prompt Table: DP_FCSTACRCY_VW |