AUC_BID_RESP_FL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
2 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
3 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 DESCR50_MIXED Character(50) VARCHAR2(50) NOT NULL Description 50 characters, mixed case
7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
8 WARNING_ONLY_1 Character(1) VARCHAR2(1) NOT NULL WARNING_ONLY
9 AUC_DTTM_START DateTime(26) TIMESTAMP Date Time Start
10 AUC_DTTM_FINISH DateTime(26) TIMESTAMP Date Time Finish
11 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
12 AUC_IMG_WARNING Image Reference(30) VARCHAR2(30) Warning
13 MIN_BID_REQUIRED Number(5,0) INTEGER NOT NULL Minimum number of bid response
14 MIN_DAYS_WARNING Number(5,0) INTEGER NOT NULL Number of days warning prior
15 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
16 DESCR100B Character(100) VARCHAR2(100) NOT NULL Description
17 DESCR100C Character(100) VARCHAR2(100) NOT NULL Description
18 DESCR100D Character(100) VARCHAR2(100) NOT NULL Description
19 DESCR100E Character(100) VARCHAR2(100) NOT NULL Description
20 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
21 AUC_LINE_NBR Number(5,0) INTEGER NOT NULL Strategic Sourcing Line Number
22 START_DATE Date(10) DATE Start Date for Gen Standing PO
23 END_DATE Date(10) DATE End Date
24 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
25 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
26 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
27 BLIND_FLAG Character(3) VARCHAR2(3) NOT NULL Sealed Event
N=No
Y=Yes
28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
29 BID_RESP Character(254) VARCHAR2(254) NOT NULL Bid Response
30 AUC_EXT_PRICE Number(18,5) DECIMAL(17,5) NOT NULL Auction Extended Price
31 PUBLIC_FLG_AUC Character(3) VARCHAR2(3) NOT NULL Send to Vendor
N=No
Y=Yes
32 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
33 DESCR100A Character(100) VARCHAR2(100) NOT NULL Description
34 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.
35 WARNING_ONLY Character(1) VARCHAR2(1) NOT NULL WARNING_ONLY
N=No
Y=Yes
36 DESCR100F Character(100) VARCHAR2(100) NOT NULL Description
37 DESCR100G Character(100) VARCHAR2(100) NOT NULL Description
38 TOTAL_AMOUNT_1 Signed Number(15,3) DECIMAL(13,3) NOT NULL Total Amount
39 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address