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