CNTRCT_SETIDCNTRCT_IDDefault Value: VENDOR_SHRT_VW.VENDOR_ID
Prompt Table: VENDOR_PO_VW
CNTRCT_SRCH_PO6(SQL View) |
Index Back |
|---|---|
Contract Search Record - PO |
| SELECT DISTINCT a.SETID , a.CNTRCT_ID , a.VENDOR_SETID , a.VENDOR_ID , a.DESCR FROM PS_CNTRCT_HDR a WHERE a.cntrct_type IN ('PO', 'GN') AND a.cntrct_status = 'A' AND a.cntrct_proc_opt <> 'DST' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CNTRCT_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 3 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: VENDOR_PO_VW |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |