DP_FCITMCODE_VW

(SQL View)
 Index Back

Forecast Item Values

Forecast Item Values

SELECT DISTINCT( DP_CONFIGVIEW) , DP_ITEMCODE FROM PS_DP_FCITEMS WHERE DP_TEMPLATEITEM = 'N' AND DP_ITEMCODE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

Prompt Table: %EDITTABLE

2 DP_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE