SETIDDefault Value: CNTRCT_LINE.SETID
CNTRCT_IDDefault Value: CNTRCT_LINE.CNTRCT_ID
CNTRCT_LINE_NBRDefault Value: CNTRCT_LINE.CNTRCT_LINE_NBR
A=Amount
Q=Quantity
CNTRCT_RFQ_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT a.setid , a.cntrct_id , a.cntrct_line_nbr , a.doc_id , a.doc_line , a.business_unit , a.distrib_mthd_flg FROM PS_CNTRCT_RFQ_XREF a WHERE a.prcr_doc_type = 'RFQ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: CNTRCT_LINE.SETID |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Default Value: CNTRCT_LINE.CNTRCT_ID |
| 3 | CNTRCT_LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Buying Agreement Line Nbr
Default Value: CNTRCT_LINE.CNTRCT_LINE_NBR |
| 4 | RFQ_ID | Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
| 5 | RFQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | RFQ Line |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |