BUSINESS_UNITPROPOSAL_IDVERSION_IDGM_XML_COSTCLS1(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , PROPOSAL_ID , VERSION_ID , SUM(SPN_ALLOW_AMT) , SUM(SPN_NO_ALLOW_AMT) , SUM(TOT_SPN_AMT) FROM PS_GM_XML_COSTCLAS GROUP BY BUSINESS_UNIT , PROPOSAL_ID , VERSION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 5 | AMT_1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount1 |
| 6 | AMT1_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Expenses |