WORKLISTNAMECS_CW_CNTWL_VW2(SQL View) |
Index Back |
|---|---|
CNTSpend Threshhold WLsSCMT003 - Spend Threshold Worklists for Procurement Contracts |
| SELECT DISTINCT a.worklistname , a.setid , a.cntrct_id , b.oprid FROM PS_CS_CNT_SPND_WL A , PSWORKLIST B WHERE b.busprocname = a.busprocname AND b.activityname = a.activityname AND b.eventname = a.eventname AND b.worklistname = a.worklistname AND b.instanceid = a.instanceid AND b.transactionid = a.transactionid AND b.inststatus IN (0,1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |