PRCR_DS_CNT_VW(SQL View) |
Index Back |
|---|---|
Requisition Header ViewRequisition Header View 06/25/2008 PKL F-AHAYT-S60K7 Contract Enhancements 07/26/2018 LDAYONG PO002 - Manufacturer/Distributor-Add Field CNTRACT_STYLE,CNTRACT_STYLE_NAME,CNTRACT_PROC_OPTN |
| SELECT A.SETID , A.CNTRCT_ID , A.BUYER_ID , A.CNTRCT_BEGIN_DT , A.CNTRCT_STATUS , A.CURRENCY_CD , C.VENDOR_NAME_SHORT , B.AMT_RELSD_OPEN_ITM , 0 , A.VERSION_NBR , A.CNTRCT_STYLE , S.CNTRCT_STYLE_NAME , A.CNTRCT_PROC_OPT FROM PS_CNTRCT_HDR A LEFT OUTER JOIN PS_CNTRCT_STYLE S ON A.CNTRCT_STYLE = S.CNTRCT_STYLE , PS_CNTRCT_HDR_RLS B , PS_VENDOR C WHERE A.VERSION_STATUS = 'C' AND B.SETID = A.SETID AND B.CNTRCT_ID = A.CNTRCT_ID AND C.SETID = A.VENDOR_SETID AND C.VENDOR_ID = A.VENDOR_ID AND A.CNTRCT_PROC_OPT NOT IN('GRPM','GRPS','DST','SPP') |
| # | 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 |
| 10 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 11 | CNTRCT_STYLE | Character(10) | VARCHAR2(10) NOT NULL | Contract Style |
| 12 | CNTRCT_STYLE_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Contract Style
Prompt Table: CNTRCT_DC_VW |
| 13 | CNTRCT_PROC_OPTN | Character(4) | VARCHAR2(4) NOT NULL |
Contract Process Option
AP=Recurring Voucher BPO=Release to Single PO Only GN=General Contract MFG=Manufacturer PADV=Prepaid Voucher w/ Advance PO PO=Purchase Order PPAY=Prepaid Voucher RPOV=Recurring PO Voucher |