RESP_LN_FCTR_VW

(SQL View)
 Index Back

SELECT C.BUSINESS_UNIT , C.AUC_ID , C.AUC_ROUND , C.AUC_VERSION , C.BIDDER_SETID , C.BIDDER_ID , C.BIDDER_TYPE , C.BIDDER_LOC , C.BIDNUM , C.LINE_NBR , C.BID_FACTOR_NBR , C.GRP_LINE_NBR , C.GRP_LN_BF_NBR , C.SETID , C.BID_FACTOR_CD , C.BID_FACTOR_TYPE , C.BID_RESP_QTY , C.BID_RESP_DT , C.BID_RESP_YN , C.AUC_BF_LIST_LINE , C.BID_LIST_ITEM , C.AUC_BF_DISPLAY_FLG , C.PRICE_FLG , C.BID_SCORE , C.COMMENTS_254 , A.AUC_BID_STATUS , A.RESP_DTTM_POST , B.BID_QTY , AH.AUC_STATUS , AH.AUC_FORMAT , AH.AUC_TYPE ,ALF.BID_INCREMENT ,ALF.MIN_QTY AS BID_ST_PRICE_EVENT , B.DESCR254_MIXED FROM PS_RESP_HDR A ,PS_RESP_LN B ,PS_RESP_LN_FACTOR C , PS_AUC_HDR AH , PS_AUC_LN_BID_FCTR ALF 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.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.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.AUC_ID = C.AUC_ID AND B.AUC_ROUND = C.AUC_ROUND AND B.AUC_VERSION = C.AUC_VERSION AND B.BIDNUM = C.BIDNUM AND B.LINE_NBR = C.LINE_NBR AND B.BIDDER_SETID = C.BIDDER_SETID AND B.BIDDER_ID = C.BIDDER_ID AND B.BIDDER_TYPE = C.BIDDER_TYPE AND B.BIDDER_LOC = C.BIDDER_LOC AND A.BUSINESS_UNIT = AH.BUSINESS_UNIT AND A.AUC_ID = AH.AUC_ID AND A.AUC_ROUND = AH.AUC_ROUND AND A.AUC_VERSION =AH.AUC_VERSION AND ALF.BUSINESS_UNIT = C.BUSINESS_UNIT AND ALF.AUC_ID = C.AUC_ID AND ALF.AUC_ROUND = C.AUC_ROUND AND ALF.AUC_VERSION = C.AUC_VERSION AND ALF.LINE_NBR = C.LINE_NBR

# 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 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
12 GRP_LINE_NBR Number(5,0) INTEGER NOT NULL Group Line Number
13 GRP_LN_BF_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number for group line member
14 SETID Character(5) VARCHAR2(5) NOT NULL SetID
15 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

Prompt Table: BID_FACTOR_VW

16 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
17 BID_RESP_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Quantity
18 BID_RESP_DT Date(10) DATE Bid Response Date
19 BID_RESP_YN Character(1) VARCHAR2(1) NOT NULL Bid Response Yes/No
N=No
Y=Yes
20 AUC_BF_LIST_LINE Signed Number(6,0) DECIMAL(5) NOT NULL List Line number
21 BID_LIST_ITEM Character(60) VARCHAR2(60) NOT NULL List Item
22 AUC_BF_DISPLAY_FLG Character(1) VARCHAR2(1) NOT NULL Display Bid factor
23 PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Price Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

24 BID_SCORE Number(8,4) DECIMAL(7,4) NOT NULL Score
25 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
26 AUC_BID_STATUS Character(1) VARCHAR2(1) NOT NULL Bid Status
D=Disqualified
P=Posted
S=Saved
W=Disallowed
X=Cancelled
27 RESP_DTTM_POST DateTime(26) TIMESTAMP Response Date Time
28 BID_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
29 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
A=Awarded
C=Collaborating Event
D=Collaborating Bid Analysis
E=Evaluating
F=RFI Reviewed
I=Pending RFI Review
N=Not Awarded
O=Open
P=Posted
Q=Paused
R=Pending Scheduled Review
S=Pending Post Approval
T=Pending Award
U=Pending Award Approval
W=Post to Third Party Failed
X=Cancelled
Z=Inactive Version
30 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
31 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
32 BID_INCREMENT Number(13,2) DECIMAL(12,2) NOT NULL Bid Increment
33 BID_ST_PRICE_EVENT Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
34 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description