BUSINESS_UNITAUC_IDAUC_ROUNDDefault Value: 1
AUC_VERSIONDefault Value: 1
BIDDER_SETIDBIDDER_IDBIDDER_TYPEB=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
AUC_LN_HD_AW_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,A.BIDDER_SETID ,A.BIDDER_ID ,A.BIDDER_TYPE ,SUM(A.BPU_QTY_AUC) ,SUM(%DecMult(A.BPU_QTY_AUC,A.AUC_BID_AMT)) ,%DecMult( %DecDiv(SUM(A.QTY_AUC),( SELECT SUM(B.QTY_AUC) FROM PS_AUC_LINE B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AUC_ID = A.AUC_ID AND B.AUC_ROUND = A.AUC_ROUND AND B.AUC_VERSION = A.AUC_VERSION)),100) FROM PS_AUC_AWARD_LN A GROUP BY A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,A.BIDDER_SETID ,A.BIDDER_ID , A.BIDDER_TYPE |
| # | 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 | BIDDER_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Bidder Setid |
| 6 | BIDDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 7 | BIDDER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Bidder C=Customer P=Public U=Uploaded V=Supplier |
| 8 | BPU_QTY_AUC | Number(16,4) | DECIMAL(15,4) NOT NULL | Event Quantity |
| 9 | AUC_BID_LN_AMT | Number(16,4) | DECIMAL(15,4) NOT NULL | Extended Price |
| 10 | AUC_AWARD_PER | Number(7,3) | DECIMAL(6,3) NOT NULL | Award by Percent |