PL_CMP_CALC_AET

#	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	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
5	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
6	MG_ORIG_COMP_ID	Character(18)	VARCHAR2(18) NOT NULL	original component ID
7	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order
8	YIELD	Number(8,4)	DECIMAL(7,4) NOT NULL	Component Yield
9	YIELD_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
10	CURR_SCHED_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED
11	ISSUE_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
12	PEND_CONSUME_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME
13	PEND_LOSS_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS
14	SF_QTY_PER	Number(16,10)	DECIMAL(15,10) NOT NULL	07/06/99 SCC CN# SF800-9.0: Added label Quantity
15	QTY_PRECISION	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal W=Whole Nbr
16	ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Round Down N=Natural Round U=Round Up
17	NEW_PRDN_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	Production Start Qty
18	COMPLETED_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Completed Qty
19	SCRAP_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Scrapped Qty
20	SCRAP_REMAIN	Character(1)	VARCHAR2(1) NOT NULL	Scrap Assemblies Remain
21	REMAINING_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	08/16/01 JNW (CN#PL900-1.0): Added