PO_AUC_AWDBU_VW

#	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_AWARD_NBR	Number(3,0)	SMALLINT NOT NULL	Award Number
11	AUC_AWARD_BUSETID	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
12	RESP_BIDDER_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	RESP_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	AUC_AWARD_CURR	Character(1)	VARCHAR2(1) NOT NULL	Award Currency E=Event Currency R=Bid Currency
16	AUC_BID_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Bid Status D=Disqualified P=Posted S=Saved W=Disallowed X=Cancelled
17	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
18	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
19	AUC_POST_PB	Character(1)	VARCHAR2(1) NOT NULL	Post Event
20	PO_DT	Date(10)	DATE	Date
21	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban
22	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
23	CNTRCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
24	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
25	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
26	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
27	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard
28	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule
29	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user
30	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
31	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
32	SPECIFIC_VNDR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Specific Supplier
33	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit
34	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
35	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
36	AUC_HDR_BF_SCORE	Number(11,7)	DECIMAL(10,7) NOT NULL	Header Bid Factor Score
37	AUC_LN_BF_SCR_TTL	Number(11,7)	DECIMAL(10,7) NOT NULL	Total Line Bid Factor Score
38	AUC_BID_AMT_TTL	Number(18,5)	DECIMAL(17,5) NOT NULL	Total Bid Amount
39	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
40	AUC_RSN_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
41	AUC_AWD_RSN_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Award Reason Description
42	EMAIL_LDESC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	E-mail long description Y/N Table Edit
43	AUC_AWARD_PER	Number(7,3)	DECIMAL(6,3) NOT NULL	Award by Percent
44	AUC_AWARD_LOCK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Lines awarded and locked
45	AUC_BID_VERSION	Number(5,0)	INTEGER NOT NULL	Event Bid Version
46	BID_CNTR_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Bid Counter Action A=Accept C=Counter W=Withdrawal
47	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
48	RESP_OBO_BID	Character(1)	VARCHAR2(1) NOT NULL	Bid on Behalf of Flag
49	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.