SETIDCNTRCT_IDVERSION_NBRCAT_LINE_NBRCNTRCT_CAT_SVW(SQL View) |
Index Back |
|---|---|
Contract Category PTSF view |
| SELECT CNT.SETID ,CNT.CNTRCT_ID ,CNT.VERSION_NBR ,CNT.CAT_LINE_NBR ,CNT.CATEGORY_SETID ,(CASE WHEN CNT.CATEGORY_ID = ' ' THEN %Substring(X1.MESSAGE_TEXT,1,5) ELSE CNT.CATEGORY_ID END) FROM PS_CNTRCT_CATEGORY CNT ,PSMSGCATDEFN X1 WHERE X1.MESSAGE_SET_NBR = 18130 AND X1.MESSAGE_NBR = 18001 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 3 | VERSION_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 4 | CAT_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |
| 5 | CATEGORY_SETID | Character(5) | VARCHAR2(5) NOT NULL | Category SetID |
| 6 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |