CM_ONHAND3_VW (SQL View)	Index Back
On Hand Value View Created on 05/25/99 RML CM800-9.0 On hand value by bu, book, and item. Data in temporary table is only for transactions for a specific date; may not be current date. Specifically created for Movement report (CMS2020). On hand quantity and view are kept in separate views and temporary tables because of cost element.

CM_ONHAND3_VW

(SQL View)

On Hand Value View

Created on 05/25/99 RML CM800-9.0 On hand value by bu, book, and item. Data in temporary table is only for transactions for a specific date; may not be current date. Specifically created for Movement report (CMS2020). On hand quantity and view are kept in separate views and temporary tables because of cost element.

select process_instance, business_unit, cm_book, inv_item_id, sum(cm_onhand_value) from PS_CM_ONHAND3_TMP group by process_instance, business_unit, cm_book, inv_item_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

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

5 CM_ONHAND_VALUE Number(19,6) DECIMAL(18,6) NOT NULL 08/30/99 RML Changed from "onhand" to "on hand"

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
5	CM_ONHAND_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	08/30/99 RML Changed from "onhand" to "on hand"