SRM_DB_MSPND_VW

(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 , C.SRM_DB_PER_LBL , SUM(C.MERCHANDISE_AMT) , SUM(C.CONTRACT_AMT) , SUM(C.SCHED_COUNT) , %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 , C.SRM_DB_PER_LBL

# 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 SRM_DB_PER_LBL Character(10) VARCHAR2(10) NOT NULL Chart Period Label
6 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
7 CONTRACT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
8 SCHED_COUNT Number(6,0) INTEGER NOT NULL Schedule Count
9 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
10 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
11 DATAHINT Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)