SF_VAR_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	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	VARIANCE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	9/9/02 CRC: added variance type '15' for Yield Variance 01=Configuration Variance 02=Usage Variance 03=Component Yield Variance 04=Labor Lot Size Variance 05=Process Routing Variance 06=Efficiency Variance 07=Rate Variance 08=Material Lot Size Variance 09=Rework Expense 10=Rework Labor Expense 11=Outside Processing PPV 12=Mix Variance 13=Teardown Material Expense 14=Teardown Conversion Expense 15=Yield Variance 16=Co-Product Rate Var 17=Material Rate Variance
5	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element Prompt Table: CM_ELEMENT
6	VARIANCE_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Variance Source C=Close O=Re-Open R=Report
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
8	VARIANCE_AMOUNT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Variance Amount
9	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type Prompt Table: CM_DISTR_TYPE
10	TRANS_DATE	Date(10)	DATE	Transaction Date
11	TRANS_TIME	Time(15)	TIMESTAMP	Transaction Time
12	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
13	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
14	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
15	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
16	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
17	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code