DP_DDH_SCODE_VW

(SQL View)
Index Back

DDH View for SOURCE_CD

DDH View for SOURCE_CD

SELECT DISTINCT( SOURCE_CODE) FROM PS_DP_DMDHISTORY WHERE SOURCE_CODE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning