EX_PRJ_SHEET_VW

(SQL View)
 Index Back

Sheet Projects Detail View

This view shows Sheets by Project

SELECT C.BUSINESS_UNIT_PC , C.PROJECT_ID , A.SHEET_ID , A.SHEET_NAME , SUM(C.TXN_AMOUNT) , C.TXN_CURRENCY_CD FROM PS_EX_SHEET_HDR A , PS_EX_SHEET_LINE B , PS_EX_SHEET_DIST C , PS_PROJECT D WHERE A.POST_STATUS_EX = 'N' AND A.SHEET_STATUS IN ('APY', 'PD','STG') AND A.PROJ_MGR_FLAG = 'Y' AND A.SHEET_ID = B.SHEET_ID AND B.SHEET_ID = C.SHEET_ID AND B.LINE_NBR = C.LINE_NBR AND C.PROJECT_ID <> ' ' AND C.BUSINESS_UNIT_PC = D.BUSINESS_UNIT AND C.PROJECT_ID = D.PROJECT_ID GROUP BY C.BUSINESS_UNIT_PC, C.PROJECT_ID, A.SHEET_ID, A.SHEET_NAME, C.TXN_CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
4 SHEET_NAME Character(30) VARCHAR2(30) NOT NULL Report Description
5 TOTAL_PROJ_EXP_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Expenses
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code