PO_CNTRCT_ITM

(SQL View)
Index Back

Search for PO Contract Items


SELECT DISTINCT setid , cntrct_id , inv_item_id , descr254_mixed FROM PS_CNTRCT_LINE WHERE inv_item_id <> ' '

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description