CM_021_CST_VW

(SQL View)
 Index Back

SELECT BUSINESS_UNIT , CM_BOOK , INV_ITEM_ID , COST_ELEMENT , CM_DT_TIMESTAMP_P , PRODUCTION_ID , SUM(QTY_BASE) , SUM(CM_021_QTY) , SUM(CM_021D_QTY) , SUM(QTY_BASE_NEW) , SUM(CM_UNIT_COST) , %Round(%DecMult((SUM(CM_021D_QTY)), (SUM(CM_UNIT_COST))) ,15) FROM PS_CM_021_CST_TMP GROUP BY BUSINESS_UNIT , CM_BOOK , INV_ITEM_ID , COST_ELEMENT , CM_DT_TIMESTAMP_P , PRODUCTION_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW

4 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
5 CM_DT_TIMESTAMP_P DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0:
6 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
7 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
8 CM_021_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Prdn Completion Qty
9 CM_021D_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Reserve Prdn Completion Qty
10 QTY_BASE_NEW Signed Number(17,4) DECIMAL(15,4) NOT NULL New Base Quantity
11 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
12 CM_UNIT_REC_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL Cost Per Unit