CNTRCT_EVCHR_VW(SQL View) |
Index Back |
|---|---|
Contract Voucher Events |
| SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , B.BUSINESS_UNIT , B.VOUCHER_ID , C.POST_STATUS_AP , 0 , 'VC' , A.EVENT_STATUS , C.TXN_CURRENCY_CD , C.INVOICE_ID , C.INVOICE_DT , SUM(B.MERCHANDISE_AMT) ,'' ,'' ,'' ,'' FROM PS_CNTRCT_EVT_VCHR A , PS_VOUCHER_LINE B , PS_VOUCHER C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID GROUP BY A.SETID, A.CNTRCT_ID, A.VERSION_NBR, B.BUSINESS_UNIT, B.VOUCHER_ID, C.POST_STATUS_AP, A.EVENT_STATUS, C.TXN_CURRENCY_CD, C.INVOICE_ID, C.INVOICE_DT |
| # | 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 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | TRANSACTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Transaction ID |
| 6 | DOC_STATUS | Character(4) | VARCHAR2(4) NOT NULL | Doc Status Value |
| 7 | RELEASE_NBR | Number(5,0) | INTEGER NOT NULL | Release Number |
| 8 | CNTRCT_EVENT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Event Type
PO=PO Release RC=Receipt RQ=Requisition VC=Voucher |
| 9 | EVENT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Event Status
A=Active C=Closed I=Ineligible X=Canceled |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 12 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 13 | TTL_MERCH_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amount |
| 14 | CNTRCT_ID_DST | Character(25) | VARCHAR2(25) NOT NULL | Contract ID To |
| 15 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 16 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 17 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |