RESP_LN_FLVW

(SQL View)
 Index Back

Response Line

Used to store Response Line details

SELECT BUSINESS_UNIT , AUC_ID , AUC_ROUND , AUC_VERSION , BIDDER_SETID , BIDDER_ID , BIDDER_TYPE , BIDDER_LOC , BIDNUM , LINE_NBR , AUC_LINE_TYPE , BID_QTY , BID_QTY_MIN , ITM_SETID , INV_ITEM_ID , CATEGORY_ID , BID_PBK_QTY_TYPE , BID_PBK_RESP_TYPE , BID_PBK_BASE_QTY , BID_PBK_BASE_PRICE , BID_CNTR_ACTION , BID_LAST_LINE_NBR , BID_LAST_QTY , BID_LAST_QTY_MIN , BID_CNTR_QTY , AUC_INVITED_FLG , CONVERSION_RATE , UNIT_OF_MEASURE , BPU_UOM , BPU_QTY , BPU_QTY_MIN , GRP_AWARD_ONLY , BID_GROUP_SRC , BID_ISPCMPT_FLG , DESCR254_MIXED , IS_NOBID , SEQ_NBR , BID_LIN_STATUS_1 FROM PS_RESP_LN

# 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 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 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
9 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
11 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item
12 BID_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
13 BID_QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Requested Min Qty
14 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
16 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
17 BID_PBK_QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Price Break Order Quantity
C=Cumulative Order Quantity
I=Individual Order Quantity
18 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
19 BID_PBK_BASE_QTY Number(16,4) DECIMAL(15,4) NOT NULL Price Brake Base Qty
20 BID_PBK_BASE_PRICE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Price
21 BID_CNTR_ACTION Character(1) VARCHAR2(1) NOT NULL Bid Counter Action
A=Accept
C=Counter
W=Withdrawal
22 BID_LAST_LINE_NBR Number(5,0) INTEGER NOT NULL Last Line Round Number
23 BID_LAST_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Last Quantity
24 BID_LAST_QTY_MIN Number(19,6) DECIMAL(18,6) NOT NULL Bid Last Quantity
25 BID_CNTR_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Counter Quantity
26 AUC_INVITED_FLG Character(1) VARCHAR2(1) NOT NULL Sourcing Bidder Invite Flag
27 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
28 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
29 BPU_UOM Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
30 BPU_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
31 BPU_QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Requested Min Qty
32 GRP_AWARD_ONLY Character(1) VARCHAR2(1) NOT NULL Group Award Only
33 BID_GROUP_SRC Character(1) VARCHAR2(1) NOT NULL Bid Group Source
B=Bidder Defined
U=User Defined
34 BID_ISPCMPT_FLG Character(1) VARCHAR2(1) NOT NULL Sourcing Field
35 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
36 IS_NOBID Character(1) VARCHAR2(1) NOT NULL No Bid

Y/N Table Edit

Default Value: N

37 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
38 BID_LIN_STATUS_1 Character(1) VARCHAR2(1) NOT NULL Bid Line Status