AUC_REJ_LN_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDNUM , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.AUC_AWARD_NBR , A.LINE_NBR , A.AUC_LINE_TYPE , A.AUC_GROUP_ID , B.RESP_BIDDER_NAME1 , A.INV_ITEM_ID , A.DESCR254_MIXED , C.DESCRLONG FROM PS_AUC_AWARD_LN A , PS_AUC_AWARD_HDR B , ps_auc_awd_rsn_rej C WHERE %Join(COMMON_KEYS, AUC_AWARD_LN A, AUC_AWARD_HDR B) AND A.AUC_BID_AWARD = 'R' AND C.SETID = A.BIDDER_SETID AND C.REASON_CD = A.AUC_RSN_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 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
6 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
7 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
8 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
9 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
10 AUC_AWARD_NBR Number(3,0) SMALLINT NOT NULL Award Number
11 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
12 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item
13 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
14 RESP_BIDDER_NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
16 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
17 DESCRLONG Long Character CLOB Long Description