SF_SCRPCST_TEO1

#	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	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
11	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
12	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
13	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
14	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
15	SCRAPPED_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Scrapped Qty
16	TL_SCRAP_AMT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This Level Scrap Amount
17	LL_SCRAP_AMT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Lower Level Scrap Amount
18	PERCENT_COMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Scrap Prdn Pct
19	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
20	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity Default Value: 1
21	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
22	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
23	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
24	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
25	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
26	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code