AUC_HDR_EXT_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_AUC_BU_NONVW
2	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID Default Value: NEXT
3	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round Default Value: 1
4	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version Default Value: 1
5	AUC_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Event Format F=Sell I=RFI R=Buy S=Service
6	AUC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Event Type E=Auction S=RFx
7	AUC_NAME	Character(50)	VARCHAR2(50) NOT NULL	Event Name
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 Default Value: O
9	DESCRLONG	Long Character	CLOB	Long Description
10	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
11	AUC_DTTM_PREVIEW	DateTime(26)	TIMESTAMP	Date Time Preview
12	AUC_DTTM_START	DateTime(26)	TIMESTAMP NOT NULL	Date Time Start
13	AUC_DTTM_FINISH	DateTime(26)	TIMESTAMP NOT NULL	Date Time Finish
14	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. Prompt Table: PYMT_TR_EFF_VW
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
16	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
17	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT
18	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID Default Value: BUS_UNIT_TBL_A1.TAX_EXEMPT_ID
19	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_A1.BILL_LOCATION Prompt Table: LOCATION_TBL
20	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
21	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id Prompt Table: RQSTR_ACTIVE_VW
22	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: %EDIT_BUYER
23	AUC_ORIGINAL_ENDDT	DateTime(26)	TIMESTAMP	Original End Date
24	BLIND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sealed Event Y/N Table Edit Default Value: N
25	AUC_ALL_LINES_FLG	Character(1)	VARCHAR2(1) NOT NULL	Bid Required on all lines Y/N Table Edit Default Value: N
26	MULTIPLE_BIDS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Multiple Bids Allowed N=Not Allowed Y=Allowed Default Value: Y
27	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
28	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
29	RATE_DATE	Date(10)	DATE	Exchange Rate Date
30	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Default Value: BUS_UNIT_TBL_A1.RT_TYPE Prompt Table: RT_TYPE_TBL
31	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
32	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
33	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
34	AUC_MULTI_CUR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow MultiCurrency Events N=No Y=Yes Default Value: N
35	AUC_DISP_WEIGHTING	Character(1)	VARCHAR2(1) NOT NULL	Display Weights Y/N Table Edit Default Value: Y
36	AUC_PRELIM_BID	Character(1)	VARCHAR2(1) NOT NULL	Allow Preliminary Bids Y/N Table Edit Default Value: N
37	AUC_EDIT_RESP	Character(1)	VARCHAR2(1) NOT NULL	Edit Posted Response Y/N Table Edit Default Value: N
38	AUC_SCORE_RFI	Character(1)	VARCHAR2(1) NOT NULL	Score RFI Event Y/N Table Edit Default Value: N
39	BID_CNTR_BINDING	Character(1)	VARCHAR2(1) NOT NULL	Counter Offer Binding Y/N Table Edit Default Value: N
40	AUC_DISP_SCORE_DEF	Character(1)	VARCHAR2(1) NOT NULL	Display Scoring Algorithm Y/N Table Edit Default Value: N
41	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
42	AUC_SD_ID	Number(5,0)	INTEGER NOT NULL	Source Definition ID
43	AUC_CREATE_XML_FLG	Character(1)	VARCHAR2(1) NOT NULL	Event PDF File Flag Y/N Table Edit
44	AUC_DISP_ALL_BIDS	Character(1)	VARCHAR2(1) NOT NULL	Display all Bids Y/N Table Edit Default Value: N
45	AUC_DISP_AWD_DET	Character(1)	VARCHAR2(1) NOT NULL	Show Award Details Y/N Table Edit Default Value: N
46	AUC_DISP_BID_SCORE	Character(1)	VARCHAR2(1) NOT NULL	Display Bid Scores Y/N Table Edit Default Value: N
47	AUC_DISP_TOT_BID	Character(1)	VARCHAR2(1) NOT NULL	Display Total Y/N Table Edit Default Value: N
48	AUC_DISP_BID_FCTR	Character(1)	VARCHAR2(1) NOT NULL	Display Bid Factors Y/N Table Edit Default Value: N
49	AUC_BID_SCORE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Bid Score Optimization B=Own Bid W=Winning Bid Default Value: B
50	AUC_PRC_ONLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Price Only Flag Y/N Table Edit Default Value: N
51	AUC_ALLOW_IDENTITY	Character(1)	VARCHAR2(1) NOT NULL	Allow Identity Y/N Table Edit Default Value: N
52	AUC_DSP_BID_HIST	Character(1)	VARCHAR2(1) NOT NULL	Display Bid History Y/N Table Edit Default Value: Y
53	AUC_DSP_WIN_SCORE	Character(1)	VARCHAR2(1) NOT NULL	Display Winning Score Y/N Table Edit Default Value: N
54	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
55	AUC_PREV_LOT_ID	Character(10)	VARCHAR2(10) NOT NULL	Previous Lot ID Prompt Table: AUC_NON_LOT_VW
56	AUC_BEAT_PRC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Bidder must beat Start Price Y/N Table Edit Default Value: Y
57	AUC_PROXY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Proxy Flag N=Disabled Y=Enabled Default Value: N
58	AUC_EVENT_BASE	Character(1)	VARCHAR2(1) NOT NULL	Event Base P=Price Based S=Score Based Default Value: S
59	AUC_START_PRC_RL	Character(1)	VARCHAR2(1) NOT NULL	Start Price D=Display - Not Required to Beat N=Do Not Display Y=Display and Also Must Beat Default Value: Y
60	AUC_RANK_OPTIONS	Character(3)	VARCHAR2(3) NOT NULL	Rank Options BID=Display Rank\Total # of Bids NON=Do Not Rank RNK=Display Rank Only Default Value: NON
61	AUC_BID_COMPETE	Character(1)	VARCHAR2(1) NOT NULL	Bid Compete L=Line Level T=Event Level Default Value: T
62	AUC_DSP_RNDVER	Character(1)	VARCHAR2(1) NOT NULL	Display Round/Version N=Do Not Display R=Display Round V=Display Round and Version Default Value: V
63	AUC_SCORE_FCTR	Character(1)	VARCHAR2(1) NOT NULL	Score Factor B=Line Score and Total Score L=Line Score T=Total Score Default Value: T
64	AUC_COMP_BID	Character(1)	VARCHAR2(1) NOT NULL	Competitor Bids X=Do Not Display Y=Display and Show Identity Z=Display but Hide Identity Default Value: Z
65	AUC_ALLOW_GRP	Character(1)	VARCHAR2(1) NOT NULL	Allow Groups Y/N Table Edit Default Value: N
66	AUC_ALLOW_GRP_PBRK	Character(1)	VARCHAR2(1) NOT NULL	Allow Group Pricebreak Y/N Table Edit Default Value: N
67	AUC_SAVE_DTTM	DateTime(26)	TIMESTAMP	Save DateTime
68	AUC_POST_DTTM	DateTime(26)	TIMESTAMP	Post DateTime