CNTRCT_ITM_INQ(SQL View) |
Index Back |
|---|---|
Contract Event Inq Search View |
| SELECT DISTINCT c. ITM_SETID , c.INV_ITEM_ID , c.DESCR254_MIXED , a.SETID , a.CNTRCT_ID , a.VENDOR_SETID , a.VENDOR_ID , b.VENDOR_NAME_SHORT , a.CNTRCT_STATUS , a.CNTRCT_TYPE FROM PS_CNTRCT_HDR a , PS_VENDOR b , PS_CNTRCT_LINE c WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.setid = c.setid AND a.cntrct_id = c.cntrct_id AND a.version_nbr = c.version_nbr AND c.inv_item_id <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ITM_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Item SetID
Prompt Table: SP_SETIN_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 5 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 6 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: VENDOR_VW |
| 8 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL |
Short Vendor Name
Prompt Table: VENDOR_SHRT_VW1 |
| 9 | CNTRCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status
A=Approved C=Closed H=On-Hold O=Open P=Pre-Approved X=Canceled Default Value: O |
| 10 | CNTRCT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Contract Type
AP=Recurring Voucher GN=General Contract MS=Master Contract PO=Purchase Order |