CNTRCT_LN_ITEM

(SQL View)
 Index Back

Supplier Contract Item View

HD 1826796000: 02/11/2009: Remove C.PRICE_CNTRCT_BASE <> 0 from view definition

SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , B.INV_ITEM_ID , B.CNTRCT_LINE_NBR , A.VENDOR_SETID , A.VENDOR_ID , A.CNTRCT_BEGIN_DT , A.CNTRCT_TYPE , B.DESCR254_MIXED , B.CATEGORY_ID FROM PS_CNTRCT_HDR A , PS_CNTRCT_LINE B WHERE A.SETID = B.SETID AND A.CNTRCT_ID = B.CNTRCT_ID AND A.VERSION_NBR = B.VERSION_NBR AND A.CNTRCT_STATUS = 'A' AND B.AMT_ONLY_FLG = 'N' AND B.CATEGORY_ID <> ' ' AND B.UNIT_OF_MEASURE <> ' ' AND B.DESCR254_MIXED <> ' ' AND B.LINE_STATUS = 'O' AND EXISTS ( SELECT 'X' FROM PS_CNTRCT_LINE_UOM C , PS_CNTRCT_LN_SHIP D WHERE C.SETID = B.SETID AND C.CNTRCT_ID = B.CNTRCT_ID AND C.VERSION_NBR = B.VERSION_NBR AND C.CNTRCT_LINE_NBR = B.CNTRCT_LINE_NBR AND D.SETID = B.SETID AND D.CNTRCT_ID = B.CNTRCT_ID AND D.VERSION_NBR = B.VERSION_NBR AND D.CNTRCT_LINE_NBR = B.CNTRCT_LINE_NBR AND C.VNDR_LOC <> ' ' AND D.QTY_SCHED <> 0)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

Default Value: NEXT

3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
9 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order
10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID