AUC_AWARD_LN(SQL Table) |
Index Back |
---|---|
Award LineUsed 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 |