SETID_SOURCESOURCE_CDRO_DEFN_SRC_VW(SQL View) |
Index Back |
|---|---|
Source CodesSource Codes View for ACE Order Capture reports |
| SELECT SETID , SOURCE_CD , DESCR50 FROM PS_RO_DEFN_SOURCE UNION SELECT 'AASR' , 'ALLSRC' , %Substring(MESSAGE_TEXT, 1, 50) FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 17834 AND MESSAGE_NBR = 4065 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_SOURCE |
Character(5) | VARCHAR2(5) NOT NULL | MOC SETID Field |
| 2 | SOURCE_CD |
Character(6) | VARCHAR2(6) NOT NULL | Source Code |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |