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