CM_ONHAND2_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_ONHAND2_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(monetary_amount) FROM PS_CM_ONHAND2_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 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

#	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	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.