SCP_AUC_NAWD_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
5	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
6	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
7	AUC_NAME	Character(50)	VARCHAR2(50) NOT NULL	Event Name
8	AUC_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Event Format F=Sell I=RFI R=Buy S=Service
9	AUC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Event Type E=Auction S=RFx
10	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
11	BIDNUM	Signed Number(6,0)	DECIMAL(5) NOT NULL	Bid ID
12	BIDDER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Bidder Setid
13	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
14	BIDDER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Bidder C=Customer P=Public U=Uploaded V=Supplier
15	BIDDER_LOC	Character(10)	VARCHAR2(10) NOT NULL	Bidder Location
16	AUC_AWARD_NBR	Number(3,0)	SMALLINT NOT NULL	Award Number
17	RESP_BIDDER_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	RESP_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
20	AUC_AWARD_CURR	Character(1)	VARCHAR2(1) NOT NULL	Award Currency E=Event Currency R=Bid Currency
21	AUC_BID_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Bid Status D=Disqualified P=Posted S=Saved W=Disallowed X=Cancelled
22	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
23	AUC_POST_PB	Character(1)	VARCHAR2(1) NOT NULL	Post Event
24	PO_DT	Date(10)	DATE	Date
25	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban
26	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
27	CNTRCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
28	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
29	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
30	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
31	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard
32	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule
33	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user
34	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
35	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
36	SPECIFIC_VNDR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Specific Supplier
37	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit
38	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
39	AUC_AWARD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Award Type C=PO Contract E=Procurement Contract G=General Contract P=Purchase Order S=Single Release PO Contract V=Recurring Voucher Contract
40	AUC_HDR_BF_SCORE	Number(11,7)	DECIMAL(10,7) NOT NULL	Header Bid Factor Score
41	AUC_LN_BF_SCR_TTL	Number(11,7)	DECIMAL(10,7) NOT NULL	Total Line Bid Factor Score
42	AUC_BID_AMT_TTL	Number(18,5)	DECIMAL(17,5) NOT NULL	Total Bid Amount
43	AUC_BID_AWARD	Character(1)	VARCHAR2(1) NOT NULL	Award Event A=Award Bid C=Counter Bid N=No Action Taken R=Reject Bid W=Disallow Bid
44	AUC_RSN_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
45	AUC_AWD_RSN_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Award Reason Description
46	EMAIL_LDESC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	E-mail long description Y/N Table Edit
47	AUC_AWARD_PER	Number(7,3)	DECIMAL(6,3) NOT NULL	Award by Percent
48	AUC_AWARD_LOCK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Lines awarded and locked
49	AUC_BID_VERSION	Number(5,0)	INTEGER NOT NULL	Event Bid Version
50	BID_CNTR_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Bid Counter Action A=Accept C=Counter W=Withdrawal