GM_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 |