DP_CONFIGVIEWDP_FROMLEVELDP_FORECASTITEMDP_FCITEMPRO_VW(SQL View) |
Index Back |
|---|---|
Group to Prorate LookupDate Initials Reference # Description 06/14/07 TH ICE 1662239000 New View for Group to Prorate Lookup - only displays those Items for the From Level selected |
| SELECT A.DP_CONFIGVIEW , A.DP_CONFIGLEVEL , A.DP_FORECASTITEM , A.DP_FCITEMCAPTION FROM PS_DP_FCITEMS A WHERE A.DP_TEMPLATEITEM <> 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW |
| 2 | DP_FROMLEVEL |
Number(3,0) | SMALLINT NOT NULL | DP_FROMLEVEL |
| 3 | DP_FORECASTITEM |
Character(120) | VARCHAR2(120) NOT NULL | DP_FORECASTITEM |
| 4 | DP_FCITEMCAPTION | Character(40) | VARCHAR2(40) NOT NULL | DP_FCITEMCAPTION |