CM_PDAV_COST_VW (SQL View)	Index Back
Periodic Avg - Summed Costs 8/02 LEE: S-MERENDA88 - Initial create. This view holds periodioc average costs. The unit cost is summed, for all cost elements, within the default book.

CM_PDAV_COST_VW

(SQL View)

Periodic Avg - Summed Costs

8/02 LEE: S-MERENDA88 - Initial create. This view holds periodioc average costs. The unit cost is summed, for all cost elements, within the default book.

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.DT_TIMESTAMP , A.EFFDT , A.CM_QTY_BASE , A.UNIT_MEASURE_STD , SUM(A.CM_UNIT_COST) , A.CURRENCY_CD FROM PS_CM_PERDAVG_COST A , PS_CM_INQ_BOOK_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CM_BOOK = B.CM_BOOK AND A.EFF_STATUS = 'A' GROUP BY A.BUSINESS_UNIT , A.INV_ITEM_ID , A.DT_TIMESTAMP , A.EFFDT , A.CM_QTY_BASE , A.UNIT_MEASURE_STD , A.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

4 EFFDT Date(10) DATE Effective Date

5 CM_QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL 07/99 GMG CN800-9.0:

6 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

7 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
4	EFFDT	Date(10)	DATE	Effective Date
5	CM_QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	07/99 GMG CN800-9.0:
6	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
7	CM_UNIT_COST	Signed Number(27,15)	DECIMAL(25,15) NOT NULL	07/99 GMG CN800-9.0:
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code