PGM_BUD_ROLLUP

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.PC_BUDGET_ID , A.PC_BUDGET_ITEM , A.BUSINESS_UNIT_GL , A.ACCOUNT , A.DEPTID , B.BUDGET_PERIOD , SUM(B.BUDGET_AMOUNT) FROM %Table (PGM_BUD_DETAIL) A , %Table(PGM_BUD_PERIOD) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.PC_BUDGET_ID = B.PC_BUDGET_ID AND A.PC_BUDGET_ITEM = B.PC_BUDGET_ITEM AND A.SEQ_NBR = B.SEQ_NBR GROUP BY A.BUSINESS_UNIT , A.PROJECT_ID , A.PC_BUDGET_ID, A.PC_BUDGET_ITEM , A.BUSINESS_UNIT_GL , A.ACCOUNT , A.DEPTID , B.BUDGET_PERIOD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 PC_BUDGET_ID Number(3,0) SMALLINT NOT NULL Budget Plan ID
4 PC_BUDGET_ITEM Character(15) VARCHAR2(15) NOT NULL Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM

Prompt Table: PC_CUR_BUD_ITEM

5 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BUPCIT_NONVW

6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GL_ACCT_BUGL_VW

7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

8 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
9 BUDGET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Projects Budget Amount