SF_ERNCNCS_TEO2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	MG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
5	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
6	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
7	TRANS_DATE	Date(10)	DATE	Transaction Date
8	TRANS_TIME	Time(15)	TIMESTAMP	Transaction Time
9	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
10	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
11	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 Default Value: N
12	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
13	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
14	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
15	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
16	CONVERSION_AMT	Signed Number(12,4)	DECIMAL(10,4) NOT NULL	Conversion Amount
17	RATE_AMOUNT	Number(11,4)	DECIMAL(10,4) NOT NULL	Rate Amount
18	RATE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Rate Per HR=Hourly UN=Per Unit
19	OP_TIME_RATE	Number(9,2)	DECIMAL(8,2) NOT NULL	Operation Time/Rate
20	OP_TIME_RATE_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Operation Time/Rate Unit DY=Days HR=Hours MN=Minutes UD=Units per Day UH=Units per Hour UM=Units per Minute
21	OVERHEAD_RATE	Number(11,4)	DECIMAL(10,4) NOT NULL	Conversion Overhead Rate
22	OVERHEAD_PERCENT	Number(5,1)	DECIMAL(4,1) NOT NULL	Conversion Overhead %
23	OH_RATE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Conversion Ovhd Rate Type %L=% of Labor Amt %M=% of Mach Amt PL=Amt Per Labor Hr PM=Amt Per Mach Hr PU=Per Unit Amt
24	OH_LAB_MACH_AMT	Signed Number(12,4)	DECIMAL(10,4) NOT NULL	Lab/Mach Amt for Ovhd Cal
25	EARN_COST_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Earned Cost Quantity
26	PRORATE_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Maximum Quantity
27	PERCENT_COMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Scrap Prdn Pct
28	DAILY_CAPACITY	Number(5,2)	DECIMAL(4,2) NOT NULL	Average Daily Hours
29	CREWSIZE	Number(7,2)	DECIMAL(6,2) NOT NULL	Crew Size
30	MACH_RESOURCES	Number(7,2)	DECIMAL(6,2) NOT NULL	Machine Resources
31	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity Default Value: 1
32	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
33	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 Default Value: N
34	PRDN_SPLIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	02/26/99 SCC CN#SF800-9.0: New field. Y/N Table Edit Default Value: N
35	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least Y/N Table Edit Default Value: N
36	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
37	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
38	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code