SCP_AUC_AWD_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	AUC_NAME	Character(50)	VARCHAR2(50) NOT NULL	Event Name
6	AUC_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Event Format F=Sell I=RFI R=Buy S=Service
7	AUC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Event Type E=Auction S=RFx
8	AUC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Event Status A=Awarded C=Collaborating Event D=Collaborating Bid Analysis E=Evaluating F=RFI Reviewed I=Pending RFI Review N=Not Awarded O=Open P=Posted Q=Paused R=Pending Scheduled Review S=Pending Post Approval T=Pending Award U=Pending Award Approval W=Post to Third Party Failed X=Cancelled Z=Inactive Version
9	BIDNUM	Signed Number(6,0)	DECIMAL(5) NOT NULL	Bid ID
10	BIDDER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Bidder Setid
11	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
12	BIDDER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Bidder C=Customer P=Public U=Uploaded V=Supplier
13	BIDDER_LOC	Character(10)	VARCHAR2(10) NOT NULL	Bidder Location
14	AUC_AWARD_NBR	Number(3,0)	SMALLINT NOT NULL	Award Number
15	AUC_AWARD_BUSETID	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
16	RESP_BIDDER_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	RESP_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	AUC_AWARD_CURR	Character(1)	VARCHAR2(1) NOT NULL	Award Currency E=Event Currency R=Bid Currency
20	AUC_BID_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Bid Status D=Disqualified P=Posted S=Saved W=Disallowed X=Cancelled
21	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
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
51	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
52	RESP_OBO_BID	Character(1)	VARCHAR2(1) NOT NULL	Bid on Behalf of Flag
53	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.
54	SCP_TRANSACTION	Character(2)	VARCHAR2(2) NOT NULL	Transaction Status A=Approved C=Complete CX=Closed D=Dispatched DA=Denied H=On-Hold I=Initial LD=Line Denied O=Open P=Pre-Approved PA=Pending Approval/Approved PX=Pending Cancel X=Canceled