AUC_AWARD_LN

(SQL Table)
Index Back

Award Line

Used to store Award Line details

# 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

Default Value: 1

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

Default Value: 1

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

Default Value: 1

11 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
12 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item
13 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
14 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
16 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
17 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
18 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
19 AUC_REQ_QTY Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
20 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
21 BPU_UOM Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
22 BPU_RESP_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Quantity
23 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
24 BPU_QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
25 BPU_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
26 BPU_QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Requested Min Qty
27 AUC_AWARD_QTY Number(16,4) DECIMAL(15,4) NOT NULL Total Awarded Qty
28 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes
29 AUC_BID_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
30 AUC_BID_AMT Number(16,4) DECIMAL(15,4) NOT NULL Line Bid Amount
31 AUC_BID_LN_AMT Number(16,4) DECIMAL(15,4) NOT NULL Extended Price
32 AUC_BID_LN_AMT_TTL Number(18,5) DECIMAL(17,5) NOT NULL Each Amount Alternate Currency
33 AUC_BID_LN_AMT_CUR Number(16,4) DECIMAL(15,4) NOT NULL Bidder Amount Alt Currency
34 BPU_PCMT_UNIT_AMT Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Quantity
35 AUC_LN_BF_SCR Number(7,3) DECIMAL(6,3) NOT NULL Line Bid Factor Score
36 AUC_LN_BF_SCR_TTL Number(11,7) DECIMAL(10,7) NOT NULL Total Line Bid Factor Score
37 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

Default Value: N

38 AUC_RSN_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
39 AUC_AWD_RSN_DESCR Character(50) VARCHAR2(50) NOT NULL Award Reason Description
40 DESCRLONG Long Character CLOB Long Description
41 EMAIL_LDESC_FLAG Character(1) VARCHAR2(1) NOT NULL E-mail long description

Y/N Table Edit

Default Value: N

42 AUC_AWARD_PER Number(7,3) DECIMAL(6,3) NOT NULL Award by Percent
43 AUC_AWARD_LOCK_FLG Character(1) VARCHAR2(1) NOT NULL Lines awarded and locked

Y/N Table Edit

Default Value: N

44 BID_CNTR_ACTION Character(1) VARCHAR2(1) NOT NULL Bid Counter Action
A=Accept
C=Counter
W=Withdrawal
45 BID_PBK_RESP_TYPE Character(1) VARCHAR2(1) NOT NULL Price Break Response Type
B=Bidder Defined Price Breaks
N=No Price Breaks
T=Both User/Bidder Price Breaks
U=User Defined Price Breaks
46 BID_PBK_QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Price Break Order Quantity
C=Cumulative Order Quantity
I=Individual Order Quantity
47 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
48 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
49 AUC_VNDR_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL Create Supp Item Relationship

Y/N Table Edit

Default Value: Y

50 AUC_CNTRCT_LN_NBR Number(5,0) INTEGER NOT NULL Contract Line Number