CM_WC_EOMSU_CVW (SQL View)	Index Back
End of Month Summary This view is the summary detail displayed on the report for End Of Month Reconcilation. All information is summed to the Item level.

CM_WC_EOMSU_CVW

(SQL View)

End of Month Summary

This view is the summary detail displayed on the report for End Of Month Reconcilation. All information is summed to the Item level.

SELECT PROCESS_INSTANCE , OPRID , A.BUSINESS_UNIT , CM_BOOK , INV_ITEM_ID , DESCR , FISCAL_YEAR , ACCOUNTING_PERIOD , CM_PAST_VALUE , CM_CURRENT_VALUE , CM_VALUE_DIFFERENC , CM_ACCTG_VALUE , CM_ACCTG_VARIANCE , CM_THRESHOLD , TOLERANCE_PCT , CURRENCY_CD , DRILLDOWN_FLG , B.OPRCLASS FROM PS_CM_WC_EOMSUM_VW A , PS_SEC_BU_CLS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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

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

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

8 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

9 CM_PAST_VALUE Signed Number(27,10) DECIMAL(25,10) NOT NULL Past Cost Value

10 CM_CURRENT_VALUE Signed Number(27,10) DECIMAL(25,10) NOT NULL Current Cost Value

11 CM_VALUE_DIFFERENC Signed Number(27,10) DECIMAL(25,10) NOT NULL Different Value

12 CM_ACCTG_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Accounting Value

13 CM_ACCTG_VARIANCE Signed Number(27,10) DECIMAL(25,10) NOT NULL Accounting Variance

14 CM_THRESHOLD Signed Number(20,3) DECIMAL(18,3) NOT NULL Threshold

15 TOLERANCE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Created for Landed Cost Reports - CMS3000, CMS3010, CMS3020 - KDN 10/20/99

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

17 DRILLDOWN_FLG Character(1) VARCHAR2(1) NOT NULL Drilldown Flag
Default Value: N

18 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
9	CM_PAST_VALUE	Signed Number(27,10)	DECIMAL(25,10) NOT NULL	Past Cost Value
10	CM_CURRENT_VALUE	Signed Number(27,10)	DECIMAL(25,10) NOT NULL	Current Cost Value
11	CM_VALUE_DIFFERENC	Signed Number(27,10)	DECIMAL(25,10) NOT NULL	Different Value
12	CM_ACCTG_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Accounting Value
13	CM_ACCTG_VARIANCE	Signed Number(27,10)	DECIMAL(25,10) NOT NULL	Accounting Variance
14	CM_THRESHOLD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Threshold
15	TOLERANCE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Created for Landed Cost Reports - CMS3000, CMS3010, CMS3020 - KDN 10/20/99
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	DRILLDOWN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Drilldown Flag Default Value: N
18	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class