PL_MM_CONS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
5	PL_PLAN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	11/01/01 PCL (CN#PL900-1): Added 05=Planned 15=Firmed 90=Canceled
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
8	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
9	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database
10	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code
11	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
12	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
13	TOTAL_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Total Quantity
14	TARGET_DATE	DateTime(26)	TIMESTAMP	12/10/02 NRA (CN#PL880-1): Defined
15	PRIORITY_RANK	Number(3,0)	SMALLINT NOT NULL	Priority rank value of demand prioritization rule
16	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
17	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
18	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
19	SELECT_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Select Clause
20	SELECT_CLAUSE2	Character(254)	VARCHAR2(254) NOT NULL	Select Clause 2
21	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive