REPORT_ENTITYBUYER_IDSRM_DB_S_FISCAL_YRSRM_DB_S_ACCT_PERSRM_DB_MPODT_VW(SQL View) |
Index Back |
|---|---|
Manager spend by PO date view |
| 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) , ' ' , ' ' FROM PS_PO_MANAGER_TBL A , PS_PO_SPEND_BUYER B , PS_PO_SPEND_PO_DT 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 |
| 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 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 10 | DATAHINT | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |