GM_X_BUD_DTL_V2

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , SUM(A.SPONSOR_AMT) FROM PS_GM_EC_BUD_DTL A WHERE A.BUDGET_PERIOD_GM = 1 GROUP BY A.BUSINESS_UNIT , A.PROPOSAL_ID , A.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 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount