AUC_LN_BF_RSP_V

(SQL View)
 Index Back

Event Line Bid Factor

Used to store event line bid factor details

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.LINE_NBR , A.BID_FACTOR_NBR , B.BIDNUM , B.BIDDER_SETID , B.BIDDER_ID , B.BIDDER_TYPE , B.BIDDER_LOC , A.SETID , A.BID_FACTOR_CD , A.BID_FACTOR_TYPE , A.SEQ_NBR , DECODE(C.DESCR , NULL , A.BID_FACTOR_CD , C.DESCR) , A.COMMENTS_2000 , A.UNIT_OF_MEASURE , A.BID_INCREMENT , A.MIN_QTY , A.MAX_QTY , A.IDEAL_QTY , A.MIN_DT , A.MAX_DT , A.IDEAL_DT , A.IDEAL_TXT , A.IDEAL_YN , B.BID_RESP_QTY , B.BID_RESP_DT , B.BID_RESP_YN , A.WEIGHTING , A.PRICE_FLG , A.CNTRCT_FCTR_FLG , B.BID_RESP_TXT FROM PS_AUC_LN_BID_FCTR A , PS_RESP_LN_FACTOR B , PS_BID_FACTOR_VW2 C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AUC_ID = A.AUC_ID AND B.AUC_ROUND = A.AUC_ROUND AND B.AUC_VERSION = A.AUC_VERSION AND B.LINE_NBR = A.LINE_NBR AND B.BID_FACTOR_NBR = A.BID_FACTOR_NBR AND A.SETID (+)= C.SETID AND A.BID_FACTOR_CD (+)= C.BID_FACTOR_CD

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
7 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
8 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
9 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
10 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
11 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
12 SETID Character(5) VARCHAR2(5) NOT NULL SetID
13 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

Prompt Table: BID_FACTOR_VW

14 BID_FACTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
A=Attachment
C=Monetary
D=Date
L=List
N=Numeric
S=Separator
T=Text
Y=Yes/No
15 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
17 COMMENTS_2000 Long Character CLOB Comment Text
18 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

19 BID_INCREMENT Number(13,2) DECIMAL(12,2) NOT NULL Bid Increment
20 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
21 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
22 IDEAL_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Ideal Quantity
23 MIN_DT Date(10) DATE Minimum Date
24 MAX_DT Date(10) DATE Max Date
25 IDEAL_DT Date(10) DATE Ideal DateTime
26 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
27 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No

Y/N Table Edit

28 BID_RESP_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Quantity
29 BID_RESP_DT Date(10) DATE Bid Response Date
30 BID_RESP_YN Character(1) VARCHAR2(1) NOT NULL Bid Response Yes/No
N=No
Y=Yes
31 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
32 PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Price Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

33 CNTRCT_FCTR_FLG Character(1) VARCHAR2(1) NOT NULL Include on Contract

Y/N Table Edit

Default Value: N

34 BID_RESP_TXT Long Character(2000) VARCHAR2(2000) Bid Response Text