AUC_SOURCING_EV

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