DP_ITEMCD_VW

(SQL View)
 Index Back

ITEM CODE FROM FCITEMS

SELECT DISTINCT(DP_ITEMCODE) ,DP_ITEMCODE FROM PS_DP_FCITEMS WHERE DP_ITEMCODE <> ''

SELECT DISTINCT(DP_ITEMCODE) , DP_ITEMCODE FROM PS_DP_FCITEMS WHERE DP_ITEMCODE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE
2 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION