CM_WC_EOMDTL_VW (SQL View)	Index Back
Unit cost and on hand value This is the detail information for the Month End Reconciliation. The data will be reported on the detail report and on the drill down. It contains the Previous, Current and Accounting Values in detail grouped by the Account combination.

CM_WC_EOMDTL_VW

(SQL View)

Unit cost and on hand value

This is the detail information for the Month End Reconciliation. The data will be reported on the detail report and on the drill down. It contains the Previous, Current and Accounting Values in detail grouped by the Account combination.

SELECT process_instance , business_unit , cm_book , inv_item_id , transaction_group , storage_area , account , currency_cd , SUM(monetary_amount) FROM PS_CM_EOM_DTL_TBL GROUP BY process_instance , business_unit , cm_book , inv_item_id , transaction_group , storage_area , account , currency_cd

# 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 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.

6 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

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

9 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	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
6	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area
7	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	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.