RESP_HDR_LN_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDNUM , A.LINE_NBR , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.BID_CNTR_ACTION , A.AUC_LN_BF_SCR_TTL , B.BID_QTY , B.ITM_SETID , B.INV_ITEM_ID , B.CATEGORY_ID , B.DESCR254_MIXED , B.IS_NOBID FROM PS_RESP_TOT_LNW_VW A , PS_RESP_LN B 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.LINE_NBR =B.LINE_NBR 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

# 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
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
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 AUC_LN_BF_SCR_TTL Number(11,7) DECIMAL(10,7) NOT NULL Total Line Bid Factor Score
13 BID_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
14 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE26

16 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
17 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
18 IS_NOBID Character(1) VARCHAR2(1) NOT NULL No Bid

Y/N Table Edit