UPG_AUC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	BID_FACTOR_CD	Character(18)	VARCHAR2(18) NOT NULL	Bid Factor Code
4	EFFDT	Date(10)	DATE	Effective Date
5	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
6	MIN_QTY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Minimum Quantity
7	MAX_QTY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Maximum Quantity
8	IDEAL_QTY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Ideal Quantity
9	MIN_DT	Date(10)	DATE	Minimum Date
10	MAX_DT	Date(10)	DATE	Max Date
11	IDEAL_DT	Date(10)	DATE	Ideal DateTime
12	IDEAL_TXT	Character(254)	VARCHAR2(254) NOT NULL	Ideal Text
13	IDEAL_YN	Character(1)	VARCHAR2(1) NOT NULL	Ideal Yes/No Y/N Table Edit
14	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
15	BID_FCTR_RULE	Number(3,0)	SMALLINT NOT NULL	Bid Factor Rule