REPORT_ENTITYBUYER_IDSRM_DB_S_FISCAL_YRSRM_DB_S_ACCT_PERSRM_DB_BSPND_V1(SQL View) |
Index Back |
|---|---|
Buyer Spend view |
| SELECT DISTINCT REPORT_ENTITY , BUYER_ID , SRM_DB_S_FISCAL_YR , SRM_DB_S_ACCT_PER , %Round(%DecMult(%DecDiv(SUM(CONTRACT_AMT), SUM(MERCHANDISE_AMT)), 100), 2) PERCENTAGE FROM PS_PO_SPEND_HIST 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 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |