DP_FCITEMS3_VW

(SQL View)
 Index Back

Not used

SELECT DP_CONFIGVIEW ,DP_CONFIGLEVEL ,DP_FORECASTITEM ,DP_FCITEMCAPTION FROM PS_DP_FCITEMS

SELECT DP_CONFIGVIEW ,DP_CONFIGLEVEL ,DP_FORECASTITEM ,DP_FCITEMCAPTION FROM PS_DP_FCITEMS WHERE 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_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL

Prompt Table: DP_CONFIGLEVELS

3 DP_FORECASTITEM Character(120) VARCHAR2(120) NOT NULL DP_FORECASTITEM
4 DP_FCITEMCAPTION Character(40) VARCHAR2(40) NOT NULL DP_FCITEMCAPTION