CM_WIP_SNP_SEL (SQL Table)	Index Back
WIP Value Extract 2/7/03 Lee: Original Create. This record is used by CM_WIPHIST, the AE that extracts data for the WIP Value Report.

CM_WIP_SNP_SEL

(SQL Table)

WIP Value Extract

2/7/03 Lee: Original Create. This record is used by CM_WIPHIST, the AE that extracts data for the WIP Value Report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

5 CM_GROUP Character(15) VARCHAR2(15) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements

6 CM_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements

7 FROM_ITEMID Character(18) VARCHAR2(18) NOT NULL 04/10/00 SCC (Internet Architecture): Add label ITEM_ID

8 TO_ITEM_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 SCC (Internet Architecture): Add label ITEM_ID

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

10 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

11 SYSTEM_DATE Date(10) DATE System Date

12 DET_SUM_SW Character(1) VARCHAR2(1) NOT NULL Detail or Summary
D=Detail
S=Summary

13 AS_OF_DATE_SW Character(1) VARCHAR2(1) NOT NULL As of Date for CMS2010 report
A=Accounting Period
S=System Date

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
5	CM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
6	CM_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
7	FROM_ITEMID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 SCC (Internet Architecture): Add label ITEM_ID
8	TO_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 SCC (Internet Architecture): Add label ITEM_ID
9	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group
10	INV_PROD_FAM_CD	Character(10)	VARCHAR2(10) NOT NULL	Family
11	SYSTEM_DATE	Date(10)	DATE	System Date
12	DET_SUM_SW	Character(1)	VARCHAR2(1) NOT NULL	Detail or Summary D=Detail S=Summary
13	AS_OF_DATE_SW	Character(1)	VARCHAR2(1) NOT NULL	As of Date for CMS2010 report A=Accounting Period S=System Date
14	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
15	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.