REPORT_ENTITYBUYER_IDSRM_DB_S_FISCAL_YRSRM_DB_S_ACCT_PERSRM_DB_PO_DT_VW(SQL View) |
Index Back |
|---|---|
Buyer Spend view |
| SELECT REPORT_ENTITY , BUYER_ID , SRM_DB_S_FISCAL_YR , SRM_DB_S_ACCT_PER , SRM_DB_PER_LBL , SUM(MERCHANDISE_AMT) , SUM(CONTRACT_AMT) , SUM(SCHED_COUNT) , ' ' , ' ' FROM PS_PO_SPEND_PO_DT GROUP BY REPORT_ENTITY , BUYER_ID , SRM_DB_S_FISCAL_YR , SRM_DB_S_ACCT_PER , 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) |