DP_DDH_SCODE_VW(SQL View) |
Index Back |
---|---|
DDH View for SOURCE_CDDDH 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 |