AUC_GPL_COST_VW

(SQL View)
 Index Back

SELECT B.business_unit , B.auc_id , B.AUC_ROUND , B.AUC_VERSION , B.bidnum , B.bidder_setid , B.bid_factor_nbr , B.bidder_id , B.bidder_type , B.bidder_loc , B.line_nbr , B.grp_line_nbr , %Round(B.bid_resp_qty , 5) , B.BPU_RESP_QTY , B.BPU_PRICE_PGKEYD FROM PS_RESP_LN_factor B INNER JOIN PS_RESP_LN A ON 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 A.LINE_NBR = B.LINE_NBR WHERE price_flg = 'Y' AND grp_line_nbr > 0

# 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

Default Value: NEXT

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 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
12 GRP_LINE_NBR Number(5,0) INTEGER NOT NULL Group Line Number
13 AUC_PRICE Number(17,5) DECIMAL(16,5) NOT NULL Event Start price
14 BPU_RESP_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Quantity
15 BPU_PRICE_PGKEYD Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price