CM_OH_SNP2_VW (SQL View)	Index Back
On Hand Value View 04/21/00 WHS - Copied from CM_ONHAND2_VW. Used to present onhand value by bu.book/item.

CM_OH_SNP2_VW

(SQL View)

On Hand Value View

04/21/00 WHS - Copied from CM_ONHAND2_VW. Used to present onhand value by bu.book/item.

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.