CE_SCRAPPID_VW

(SQL View)
Index Back

Production ID Scrap View


SELECT BUSINESS_UNIT , CM_BOOK ,PRODUCTION_ID ,SUM(CE_EXTENDED_COST) FROM PS_CE_ACTUAL_COST WHERE TRANSACTION_GROUP = '651' GROUP BY BUSINESS_UNIT, CM_BOOK, PRODUCTION_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost