CNTRCT_RFQ_XVW

(SQL View)
Index Back

Contract RFQ Xref

Contract RFQ Xref view for RFQ info only

SELECT A.SETID , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , A.BUSINESS_UNIT , A.DOC_ID , A.DOC_LINE , A.BUSINESS_UNIT_REQ , A.REQ_ID , A.REQ_LINE_NBR , SUM(A.QTY_OPEN_STD) FROM PS_CNTRCT_RFQ_XREF A WHERE A.PRCR_DOC_TYPE = 'RFQ' GROUP BY A.SETID , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , A.BUSINESS_UNIT , A.DOC_ID , A.DOC_LINE, A.BUSINESS_UNIT_REQ , A.REQ_ID , A.REQ_LINE_NBR

# 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 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
6 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
7 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
8 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
9 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
10 QTY_OPEN_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM