REPORT_ENTITYBUYER_MANAGERBUYER_IDPO_SPD_MCATG_VW(SQL View) |
Index Back |
|---|---|
Spend By Category View |
| SELECT A.REPORT_ENTITY , B.BUYER_MANAGER , A.BUYER_ID , A.VENDOR_SETID , A.VENDOR_ID , A.ITM_SETID , A.CATEGORY_ID , SUM(A.MERCHANDISE_AMT) , MIN(A.CURRENCY_CD) FROM PS_PO_SPND_HST_DTL A , PS_PO_MANAGER_TBL B WHERE A.BUYER_ID = B.BUYER_ID GROUP BY A.REPORT_ENTITY , B.BUYER_MANAGER , A.BUYER_ID , A.VENDOR_SETID , A.VENDOR_ID , A.ITM_SETID , A.CATEGORY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL | Reporting Entity ID |
| 2 | BUYER_MANAGER |
Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 3 | BUYER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 7 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 8 | TOTAL_SPENDING | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Spending Amount |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |