SAC_SS_RSPLN_VW

(SQL View)
Index Back

Response Line

Used to store Response Line details

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_QTY , A.ITM_SETID , A.INV_ITEM_ID , A.CATEGORY_ID , A.BID_PBK_QTY_TYPE , A.BID_PBK_RESP_TYPE , A.BID_PBK_BASE_QTY , A.BID_PBK_BASE_PRICE , A.DESCR254_MIXED , A.BID_CNTR_ACTION , A.BID_LAST_LINE_NBR , A.BID_LAST_QTY , A.BID_CNTR_QTY , A.AUC_INVITED_FLG , B.BID_RESP_QTY FROM PS_RESP_LN A , PS_RESP_LN_FACTOR 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.BIDNUM = B.BIDNUM AND A.LINE_NBR = B.LINE_NBR 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.PRICE_FLG = 'Y'

# 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_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
12 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE26

14 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
15 BID_PBK_QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Price Break Order Quantity
C=Cumulative Order Quantity
I=Individual Order Quantity
16 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
17 BID_PBK_BASE_QTY Number(16,4) DECIMAL(15,4) NOT NULL Price Brake Base Qty
18 BID_PBK_BASE_PRICE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Price
19 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
20 BID_CNTR_ACTION Character(1) VARCHAR2(1) NOT NULL Bid Counter Action
A=Accept
C=Counter
W=Withdrawal
21 BID_LAST_LINE_NBR Number(5,0) INTEGER NOT NULL Last Line Round Number
22 BID_LAST_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Last Quantity
23 BID_CNTR_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Counter Quantity
24 AUC_INVITED_FLG Character(1) VARCHAR2(1) NOT NULL Sourcing Bidder Invite Flag
25 BID_RESP_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Quantity