BUSINESS_UNITPROPOSAL_IDVERSION_IDGM_XML_COSTCLS4(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , PROPOSAL_ID , VERSION_ID , SUM(ANTICIPATED_AMT) , SUM(NO_ALLOW_AMT) , SUM(ANTICIPATED_AMT + NO_ALLOW_AMT) FROM PS_GM_BUD_PERIOD 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 | AMT4 | 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_4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount4 |
| 6 | AMT4_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amt4 Total |