BUSINESS_UNITAUC_IDAUC_ROUNDDefault Value: 1
AUC_VERSIONDefault Value: 1
BIDNUMLINE_NBRBIDDER_SETIDBIDDER_IDBIDDER_TYPEB=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
BIDDER_LOCA=Accept
C=Counter
W=Withdrawal
Y/N Table Edit
RESP_TOT_LNX_VW(SQL View) |
Index Back |
|---|---|
Response LineUsed to store Response Line details |
| SELECT B.BUSINESS_UNIT , B.AUC_ID , B.AUC_ROUND , B.AUC_VERSION , B.BIDNUM , B.LINE_NBR , B.BIDDER_SETID , B.BIDDER_ID , B.BIDDER_TYPE , B.BIDDER_LOC , B.BID_CNTR_ACTION , B.IS_NOBID , C.BID_SCORE , D.WEIGHTING , B.BID_QTY , C.BID_RESP_QTY , %Round( (%DecMult(B.BID_QTY , C.BID_RESP_QTY) ) , 5) FROM PS_RESP_HDR A , PS_RESP_LN B , PS_RESP_LN_FACTOR C , PS_AUC_LN_BID_FCTR D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND A.BIDNUM = B.BIDNUM AND A.BIDDER_SETID = B.BIDDER_SETID AND A.BIDDER_ID = B.BIDDER_ID AND A.BIDDER_TYPE = B.BIDDER_TYPE AND A.BIDDER_LOC = B.BIDDER_LOC AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.AUC_ID = C.AUC_ID AND B.BIDNUM = C.BIDNUM AND C.AUC_ROUND = C.AUC_ROUND AND C.AUC_VERSION = C.AUC_VERSION AND B.BIDDER_SETID = C.BIDDER_SETID AND B.BIDDER_ID = C.BIDDER_ID AND B.BIDDER_TYPE = C.BIDDER_TYPE AND B.BIDDER_LOC = C.BIDDER_LOC AND B.LINE_NBR = C.LINE_NBR AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.AUC_ID = D.AUC_ID AND C.AUC_ROUND = D.AUC_ROUND AND C.AUC_VERSION =D.AUC_VERSION AND C.LINE_NBR = D.LINE_NBR AND C.BID_FACTOR_NBR = D.BID_FACTOR_NBR AND C.SETID = D.SETID AND C.BID_FACTOR_CD = D.BID_FACTOR_CD AND A.AUC_BID_STATUS = 'P' AND C.PRICE_FLG = 'Y' AND C.GRP_LINE_NBR = 0 AND C.BIDNUM = ( SELECT MAX(Y.BIDNUM) FROM PS_RESP_LN_FACTOR Y ,PS_RESP_HDR HY WHERE HY.BUSINESS_UNIT = Y.BUSINESS_UNIT AND HY.AUC_ID = Y.AUC_ID AND HY.AUC_ROUND = Y.AUC_ROUND AND HY.AUC_VERSION = Y.AUC_VERSION AND HY.BIDNUM = Y.BIDNUM AND HY.BIDDER_SETID = Y.BIDDER_SETID AND HY.BIDDER_ID = Y.BIDDER_ID AND HY.BIDDER_TYPE = Y.BIDDER_TYPE AND HY.BIDDER_LOC = Y.BIDDER_LOC AND HY.AUC_BID_STATUS = 'P' AND Y.BUSINESS_UNIT = B.BUSINESS_UNIT AND Y.AUC_ID = B.AUC_ID AND Y.AUC_ROUND = B.AUC_ROUND AND Y.AUC_VERSION = B.AUC_VERSION AND Y.BIDDER_SETID = B.BIDDER_SETID AND Y.BIDDER_ID = B.BIDDER_ID AND Y.BIDDER_TYPE = B.BIDDER_TYPE AND Y.BIDDER_LOC = B.BIDDER_LOC AND Y.LINE_NBR = B.LINE_NBR AND Y.BID_SCORE = ( SELECT MAX(X.BID_SCORE) FROM PS_RESP_LN_FACTOR X ,PS_RESP_HDR HX WHERE HX.BUSINESS_UNIT = X.BUSINESS_UNIT AND HX.AUC_ID = X.AUC_ID AND HX.AUC_ROUND = X.AUC_ROUND AND HX.AUC_VERSION = X.AUC_VERSION AND HX.BIDNUM = X.BIDNUM AND HX.BIDDER_SETID = X.BIDDER_SETID AND HX.BIDDER_ID = X.BIDDER_ID AND HX.BIDDER_TYPE = X.BIDDER_TYPE AND HX.BIDDER_LOC = X.BIDDER_LOC AND HX.AUC_BID_STATUS = 'P' AND X.BUSINESS_UNIT = B.BUSINESS_UNIT AND X.AUC_ID = B.AUC_ID AND X.AUC_ROUND = B.AUC_ROUND AND X.AUC_VERSION = B.AUC_VERSION AND X.BIDDER_SETID = B.BIDDER_SETID AND X.BIDDER_ID = B.BIDDER_ID AND X.BIDDER_TYPE = B.BIDDER_TYPE AND X.BIDDER_LOC = B.BIDDER_LOC AND X.LINE_NBR = B.LINE_NBR )) |
| # | 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 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 7 | BIDDER_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Bidder Setid |
| 8 | BIDDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 9 | BIDDER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Bidder C=Customer P=Public U=Uploaded V=Supplier |
| 10 | BIDDER_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Bidder Location |
| 11 | BID_CNTR_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Bid Counter Action
A=Accept C=Counter W=Withdrawal |
| 12 | IS_NOBID | Character(1) | VARCHAR2(1) NOT NULL |
No Bid
Y/N Table Edit |
| 13 | AUC_LN_BF_SCR_TTL | Number(11,7) | DECIMAL(10,7) NOT NULL | Total Line Bid Factor Score |
| 14 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 15 | BID_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Bid Quantity |
| 16 | BID_RESP_QTY | Number(19,6) | DECIMAL(18,6) NOT NULL | Bid Response Quantity |
| 17 | AUC_BID_LN_AMT_TTL | Number(18,5) | DECIMAL(17,5) NOT NULL | Total Line Amount |