SRM_DB_MSPND_V1

(SQL View)
 Index Back

Manager's View of Buyer Spend


SELECT B.REPORT_ENTITY , A.BUYER_MANAGER , C.SRM_DB_S_FISCAL_YR , C.SRM_DB_S_ACCT_PER , %Round(%DecMult(%DecDiv(SUM(C.CONTRACT_AMT), SUM(C.MERCHANDISE_AMT)), 100), 2) PERCENTAGE FROM PS_PO_MANAGER_TBL A , PS_PO_SPEND_BUYER B , PS_PO_SPEND_HIST C WHERE A.BUYER_MANAGER = B.BUYER_ID AND B.REPORT_ENTITY = C.REPORT_ENTITY AND A.BUYER_ID = C.BUYER_ID GROUP BY B.REPORT_ENTITY , A.BUYER_MANAGER , C.SRM_DB_S_FISCAL_YR , C.SRM_DB_S_ACCT_PER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
2 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_ACTIVE_VW

3 SRM_DB_S_FISCAL_YR Character(4) VARCHAR2(4) NOT NULL Fiscal Year string
4 SRM_DB_S_ACCT_PER Character(3) VARCHAR2(3) NOT NULL Accounting Period string
5 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage