AUC_NOA_BDR_VW

(SQL View)
 Index Back

NOA Bidder

NOA Bidder

SELECT A.* FROM PS_AUC_NOA_BIDDER A , PS_AUC_AWARD_HDR 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.BIDDER_SETID = B.BIDDER_SETID AND A.BIDDER_ID = B.BIDDER_ID AND B.AUC_BID_AWARD = 'A' AND ( B.PO_ID <> ' ' OR B.CNTRCT_ID <> ' ')

# 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 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
10 ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
11 AUC_NOA_BID_RESP Character(1) VARCHAR2(1) NOT NULL Responded
A=Yes
D=No
N=No
12 AUC_AWARDED Character(1) VARCHAR2(1) NOT NULL Awarded
N=No
Y=Yes
13 AUC_LAST_NTFY_DTTM DateTime(26) TIMESTAMP Last Notified DateTime
14 AUC_SELECT Character(1) VARCHAR2(1) NOT NULL Select
N=No
Y=Yes

Default Value: N

15 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
16 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename