SF_SCRAP_ARCH

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