SETIDCNTRCT_IDA=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
PRCR_DS_CNT_VW2(SQL View) |
Index Back |
|---|---|
Requisition Header ViewRequisition Header View |
| SELECT A.SETID , A.CNTRCT_ID , A.BUYER_ID , A.CNTRCT_BEGIN_DT , A.CNTRCT_STATUS , A.CURRENCY_CD , C.VENDOR_NAME_SHORT , AR.AMT_RELSD_OPEN_ITM , SUM(LR.AMT_LINE_RELEASED) FROM PS_CNTRCT_HDR A , PS_CNTRCT_HDR_RLS AR , PS_CNTRCT_LIN_RLS LR , PS_VENDOR C WHERE A.VERSION_STATUS = 'C' AND AR.SETID = A.SETID AND AR.CNTRCT_ID = A.CNTRCT_ID AND LR.SETID = A.SETID AND LR.CNTRCT_ID = A.CNTRCT_ID AND C.SETID = A.VENDOR_SETID AND C.VENDOR_ID = A.VENDOR_ID GROUP BY A.SETID , A.CNTRCT_ID , A.BUYER_ID , A.CNTRCT_BEGIN_DT , A.CNTRCT_STATUS , A.CURRENCY_CD , C.VENDOR_NAME_SHORT , AR.AMT_RELSD_OPEN_ITM |
| # | 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 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 4 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 5 | CNTRCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status
A=Approved C=Closed H=On-Hold O=Open P=Pre-Approved X=Canceled |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 8 | AMT_RELSD_OPEN_ITM | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amt relsd for Open Item |
| 9 | AMT_LINE_RELEASED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Amt Released |