PO_CNTRCTRV_VW4(SQL View) |
Index Back |
---|---|
Off Contract Spend View |
SELECT CH.VENDOR_SETID , CH.VENDOR_ID , ' ' , ' ' , CH.CURRENCY_CD , CH.CNTRCT_BEGIN_DT , SUM(%Coalesce(CL.AMT_LINE_RELEASED , 0)) FROM PS_CNTRCT_HDR CH LEFT OUTER JOIN PS_CS_CNT_SUMLN_VW CL ON CL.SETID = CH.SETID AND CL.CNTRCT_ID = CH.CNTRCT_ID WHERE CH.VERSION_STATUS = 'C' AND CH.CNTRCT_PROC_OPT IN ('AP', 'RPOV') GROUP BY CH.VENDOR_SETID, CH.VENDOR_ID, CH.CURRENCY_CD, CH.CNTRCT_BEGIN_DT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
4 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
5 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
6 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
7 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |