CE_SCRAPCST_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_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	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
7	ACTION_FLAG	Character(2)	VARCHAR2(2) NOT NULL	Action Flag
8	PRD_TL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	Production This Lvl Cost
9	PRD_LL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	Production Lower Lvl Cost
10	NEW_TL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	New This Level Cost
11	NEW_LL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	New Lower Level Cost
12	VAR_TL_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This level Cost Variance
13	VAR_LL_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Lower Level Cost Variance
14	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
15	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
16	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
17	SCRAPPED_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Scrapped Qty
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	AOQ	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Average Order Qty
22	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
23	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
24	JOB_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance