CM_CST_WIPA1_VW (SQL View)	Index Back
Wip Inventory Reval Upd 07/21/99 ebn CN#CM800-9.0 New table for accounting line generation to update CE_ITEMCVARPSB records.

CM_CST_WIPA1_VW

(SQL View)

Wip Inventory Reval Upd

07/21/99 ebn CN#CM800-9.0 New table for accounting line generation to update CE_ITEMCVARPSB records.

SELECT mg_proc_instance , business_unit , production_id , inv_item_id , storage_area , config_code , cost_element , revalue_type , seq_nbr , cm_book , '210' , process_instance , posted_flag , process_flag , ' ' FROM PS_CE_ITEMCVAR_PSB WHERE revalue_type BETWEEN '03' AND '04' AND posted_flag = 'N' AND cm_cost_mode = 'L'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_IN

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

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: MASTER_ITEM_TBL

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

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

7 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
Prompt Table: CM_ELEMENT

8 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

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

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

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

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

13 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted
Y/N Table Edit
Default Value: N

14 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

15 ADJUST_TYPE Character(1) VARCHAR2(1) NOT NULL Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_IN
3	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: MASTER_ITEM_TBL
5	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area
6	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
7	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element Prompt Table: CM_ELEMENT
8	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
9	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
10	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
11	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
12	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
13	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program. N=Not Posted X=Don't Post Y=Posted Y/N Table Edit Default Value: N
14	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
15	ADJUST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Type 0=CM Only A=VMI Return D=Decrease I=Increase M=Misc Issue R=Misc Return S=Scrap V=Scrap RTV