CM_CST_WIPA2_VW (SQL View)	Index Back
WIP Revalue Earned Conv Upd 07/21/99 ebn CN#CM800-9.0 New table for accounting line generation to update SF_EARNCONCOSTB records.

CM_CST_WIPA2_VW

(SQL View)

WIP Revalue Earned Conv Upd

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

SELECT mg_proc_instance , business_unit , production_id , op_sequence , cost_element , conversion_type , trans_date , trans_time , seq_nbr , revalue_flag , cm_book , '211' , posted_flag , process_instance , process_flag , ' ' FROM PS_SF_EARNCONCOSTB WHERE posted_flag = 'N' AND revalue_flag = 'Y' 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

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

4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

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

6 CONVERSION_TYPE Character(4) VARCHAR2(4) NOT NULL Conversion Type
1100=Lab Setup
1200=Lab Fixed
1300=Labor Run
1400=Lab PostPr
1500=Mach Setup
1600=Mach Fixed
1700=Mach Run
1800=MC PostPrd
2100=Ovhd 1
2200=Ovhd 2
2300=Ovhd 3
2400=Ovhd 4

7 TRANS_DATE Date(10) DATE NOT NULL Transaction Date

8 TRANS_TIME Time(15) TIMESTAMP NOT NULL Transaction Time

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

10 REVALUE_FLAG Character(1) VARCHAR2(1) NOT NULL Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
Y/N Table Edit

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

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

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

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

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

16 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
3	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
4	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
5	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
6	CONVERSION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Conversion Type 1100=Lab Setup 1200=Lab Fixed 1300=Labor Run 1400=Lab PostPr 1500=Mach Setup 1600=Mach Fixed 1700=Mach Run 1800=MC PostPrd 2100=Ovhd 1 2200=Ovhd 2 2300=Ovhd 3 2400=Ovhd 4
7	TRANS_DATE	Date(10)	DATE NOT NULL	Transaction Date
8	TRANS_TIME	Time(15)	TIMESTAMP NOT NULL	Transaction Time
9	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
10	REVALUE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated. Y/N Table Edit
11	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
12	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
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
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
15	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
16	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