CM_ACCT_REV_VW (SQL View)	Index Back
Revaluation Entries GMG CN# CM750-8.0 Drilldown; View joins Revaluation transactions to Accounting Lines to show the Entries caused by a transaction. KDN CM800-7.1: Added ALTACCT & AFFILIATE fields. 07/21/99 ebn CN#CM800-9.0 Changed join to reflect changes made to ce_itemcvar_pst keys. 10/07/99 ej CN#CM800-9.0 Replace CM_ACCTG_GRP with CM_ACCTG_GRP_D 11/30/01 8.4 for row level security, change the bu prompt table from CM_DRILL_BU_VW to SP_CMACTG_NONVW

CM_ACCT_REV_VW

(SQL View)

Revaluation Entries

GMG CN# CM750-8.0 Drilldown; View joins Revaluation transactions to Accounting Lines to show the Entries caused by a transaction. KDN CM800-7.1: Added ALTACCT & AFFILIATE fields. 07/21/99 ebn CN#CM800-9.0 Changed join to reflect changes made to ce_itemcvar_pst keys. 10/07/99 ej CN#CM800-9.0 Replace CM_ACCTG_GRP with CM_ACCTG_GRP_D 11/30/01 8.4 for row level security, change the bu prompt table from CM_DRILL_BU_VW to SP_CMACTG_NONVW

SELECT A.BUSINESS_UNIT , A.MG_PROC_INSTANCE , A.INV_ITEM_ID , A.CONFIG_CODE , A.REVALUE_TYPE , A.SEQ_NBR , A.PRODUCTION_ID , A.STORAGE_AREA , B.PRODUCTION_AREA , A.PRODUCTION_TYPE , A.COST_ELEMENT , A.DT_TIMESTAMP , A.TRANSACTION_GROUP , A.ACCOUNTING_DT , A.ACCTG_LINE_NO , A.DISTRIB_TYPE , A.INV_ITEM_GROUP , A.TRANS_LINE_TYPE , A.AP_SEQ_NBR , A.DESTIN_BU , A.DEBIT_CREDIT , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF16_AN_SBR,a) , %subrec(PC_CF1_N_SBR,a) , A.STATISTICS_CODE , A.MONETARY_AMOUNT , A.CURRENCY_CD , A.STATISTIC_AMOUNT , A.BUSINESS_UNIT_GL , A.LEDGER , A.JOURNAL_ID , A.JOURNAL_DATE , A.JOURNAL_LINE , A.CM_BOOK FROM PS_CM_ACCTG_LINE A , PS_CE_ITEMCVAR_PST B WHERE A.MG_PROC_INSTANCE = B.MG_PROC_INSTANCE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.STORAGE_AREA = B.STORAGE_AREA AND A.CONFIG_CODE = B.CONFIG_CODE AND A.COST_ELEMENT = B.COST_ELEMENT AND A.REVALUE_TYPE = B.REVALUE_TYPE AND A.SEQ_NBR = B.SEQ_NBR AND A.TRANSACTION_GROUP IN ( SELECT TRANSACTION_GROUP FROM PS_CM_ACCTG_GRP_D WHERE CM_SOURCE_RECORD = 'CE_ITEMCVAR_PST')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_CMACTG_NONVW

2 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
Prompt Table: CM_DRILL_PRI_VW

3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: CM_DRILL_IID_VW

4 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

5 REVALUE_TYPE Character(2) VARCHAR2(2) NOT NULL 1/25/99 - CRC EN800-6.0 : added revalue type = '05' for co/by product
01=Inventory
02=Inspection
03=WIP - Comp
04=WIP - Assy
05=WIP - Waste

6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

7 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

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

9 PRODUCTION_AREA Character(10) VARCHAR2(10) NOT NULL Production Area

10 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown

11 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

12 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

13 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.

14 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

15 ACCTG_LINE_NO Number(15,0) DECIMAL(15) NOT NULL Accounting Line Number

16 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

17 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

18 TRANS_LINE_TYPE Character(3) VARCHAR2(3) NOT NULL Transaction Line Type
0=Regular
1=Interunit Transfer
2=Gain
3=Loss
4=PPV (Favorable)
5=PPV (Unfavorable)
6=ERV (Favorable)
7=ERV (Unfavorable)
8=InterCompany Transfer

19 AP_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Payables Sequence Number

20 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

21 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit

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

23 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

24 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPTID_BUGL_VW

25 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

26 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

27 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

28 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

29 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

30 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

31 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

32 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

33 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

34 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

35 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

36 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

37 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

38 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

39 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

40 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

41 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

42 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

43 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

44 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

45 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.

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

47 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.

48 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

49 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

50 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

51 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

52 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.

53 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
Prompt Table: CM_BU_BOOK_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_CMACTG_NONVW
2	MG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance Prompt Table: CM_DRILL_PRI_VW
3	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: CM_DRILL_IID_VW
4	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
5	REVALUE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	1/25/99 - CRC EN800-6.0 : added revalue type = '05' for co/by product 01=Inventory 02=Inspection 03=WIP - Comp 04=WIP - Assy 05=WIP - Waste
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
8	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area
9	PRODUCTION_AREA	Character(10)	VARCHAR2(10) NOT NULL	Production Area
10	PRODUCTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	JNW 11/1/98 (CN#SF800-13) activated teardown xlat PR=Production RW=Rework SV=Service TD=Teardown
11	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
12	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
13	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
14	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
15	ACCTG_LINE_NO	Number(15,0)	DECIMAL(15) NOT NULL	Accounting Line Number
16	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
17	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group
18	TRANS_LINE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Transaction Line Type 0=Regular 1=Interunit Transfer 2=Gain 3=Loss 4=PPV (Favorable) 5=PPV (Unfavorable) 6=ERV (Favorable) 7=ERV (Unfavorable) 8=InterCompany Transfer
19	AP_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Payables Sequence Number
20	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
21	DEBIT_CREDIT	Character(2)	VARCHAR2(2) NOT NULL	Debit / Credit Indicator CR=Credit DR=Debit
22	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
23	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
24	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
25	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
26	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
27	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
28	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
29	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
30	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
31	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
32	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
33	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
34	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
35	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
36	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
37	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
38	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
39	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
40	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
41	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
42	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
43	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
44	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
45	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.
46	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
47	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
48	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
49	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
50	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
51	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
52	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
53	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book Prompt Table: CM_BU_BOOK_VW