AUC_OPT_RES_CMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
3	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
4	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
5	BIDNUM	Signed Number(6,0)	DECIMAL(5) NOT NULL	Bid ID
6	BIDDER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Bidder Setid
7	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
8	BIDDER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Bidder C=Customer P=Public U=Uploaded V=Supplier
9	BIDDER_LOC	Character(10)	VARCHAR2(10) NOT NULL	Bidder Location
10	AUC_BID_NAME	Character(40)	VARCHAR2(40) NOT NULL	Bidder Name
11	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
12	AUC_OPT_CMP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Compare for
13	AUC_OPT_PROC_1	Character(30)	VARCHAR2(30) NOT NULL	Problem Instance 1
14	AUC_OPT_NAME_1	Character(50)	VARCHAR2(50) NOT NULL	Recommendation Name
15	AUC_PRICE_1	Number(17,5)	DECIMAL(16,5) NOT NULL	Unit Price
16	AUC_QTY_1	Number(16,4)	DECIMAL(15,4) NOT NULL	Bid Quantity
17	AUC_OPT_PROC_2	Character(30)	VARCHAR2(30) NOT NULL	Problem Instance 2
18	AUC_OPT_NAME_2	Character(50)	VARCHAR2(50) NOT NULL	Recommendation Name
19	AUC_PRICE_2	Number(17,5)	DECIMAL(16,5) NOT NULL	Unit Price
20	AUC_QTY_2	Number(16,4)	DECIMAL(15,4) NOT NULL	Bid Quantity
21	AUC_OPT_PROC_3	Character(30)	VARCHAR2(30) NOT NULL	Problem Instance 3
22	AUC_OPT_NAME_3	Character(50)	VARCHAR2(50) NOT NULL	Recommendation Name
23	AUC_PRICE_3	Number(17,5)	DECIMAL(16,5) NOT NULL	Unit Price
24	AUC_QTY_3	Number(16,4)	DECIMAL(15,4) NOT NULL	Bid Quantity
25	AUC_OPT_PROC_4	Character(30)	VARCHAR2(30) NOT NULL	Problem Instance 4
26	AUC_OPT_NAME_4	Character(50)	VARCHAR2(50) NOT NULL	Recommendation Name
27	AUC_PRICE_4	Number(17,5)	DECIMAL(16,5) NOT NULL	Unit Price
28	AUC_QTY_4	Number(16,4)	DECIMAL(15,4) NOT NULL	Bid Quantity
29	AUC_OPT_PROC_5	Character(30)	VARCHAR2(30) NOT NULL	Problem Instance 5
30	AUC_OPT_NAME_5	Character(50)	VARCHAR2(50) NOT NULL	Recommendation Name
31	AUC_PRICE_5	Number(17,5)	DECIMAL(16,5) NOT NULL	Unit Price
32	AUC_QTY_5	Number(16,4)	DECIMAL(15,4) NOT NULL	Bid Quantity
33	AUC_OPT_PROC_6	Character(30)	VARCHAR2(30) NOT NULL	Problem Instance 6
34	AUC_OPT_NAME_6	Character(50)	VARCHAR2(50) NOT NULL	Recommendation Name
35	AUC_PRICE_6	Number(17,5)	DECIMAL(16,5) NOT NULL	Unit Price
36	AUC_QTY_6	Number(16,4)	DECIMAL(15,4) NOT NULL	Bid Quantity