SCP_S_AUCDTL_VW

(SQL View)
 Index Back

Bidder Pagelet View

Bidder Pagelet View

SELECT B.BUSINESS_UNIT , B.AUC_ID , B.AUC_ROUND , B.AUC_VERSION , B.AUC_STATUS , B.AUC_FORMAT , B.AUC_TYPE , B.BLIND_FLG , B.AUC_NAME , B.TIMEZONE , B.AUC_DTTM_START , B.AUC_DTTM_FINISH , B.AUC_DTTM_PREVIEW , B.BUYER_ID , B.DESCRLONG , B.PYMNT_TERMS_CD , B.NAME1 , B.PHONE , B.EMAILID , B.AUC_DSP_RNDVER , B.AUC_START_PRC_RL , B.AUC_EDIT_RESP , B.MULTIPLE_BIDS_FLG , B.AUC_CREATE_XML_FLG ,AUC_BID_COMPETE ,AUC_BID_SCORE_OPT ,AUC_PROXY_FLG ,AUC_EVENT_BASE ,AUC_COMP_BID , B.AUC_DTTM_START , B.AUC_DTTM_FINISH ,B.BILL_LOCATION ,B.CURRENCY_CD FROM PS_AUC_HDR B WHERE B.AUC_STATUS IN( 'A', 'P', 'T' ,'U' ,'F', 'I', 'Q') AND B.AUC_TYPE IN ('E','S') AND B.AUC_FORMAT IN ('F','R','I') AND B.AUC_DTTM_FINISH >= %CurrentDateTimeIn AND B.AUC_DTTM_PREVIEW <= %CurrentDateTimeIn

# 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 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
6 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
7 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
8 BLIND_FLG Character(1) VARCHAR2(1) NOT NULL Sealed Event
9 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
10 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
11 AUC_DTTM_START DateTime(26) TIMESTAMP Date Time Start
12 AUC_DTTM_FINISH DateTime(26) TIMESTAMP Date Time Finish
13 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
14 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
15 DESCRLONG Long Character CLOB Long Description
16 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
17 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
18 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
19 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
20 AUC_DSP_RNDVER Character(1) VARCHAR2(1) NOT NULL Display Round/Version
N=Do Not Display
R=Display Round
V=Display Round and Version
21 AUC_START_PRC_RL Character(1) VARCHAR2(1) NOT NULL Start Price
D=Display - Not Required to Beat
N=Do Not Display
Y=Display and Also Must Beat
22 AUC_INFO_SMSG2 Character(50) VARCHAR2(50) NOT NULL Informational Message
23 MULTIPLE_BIDS_FLG Character(1) VARCHAR2(1) NOT NULL Multiple Bids Allowed
N=Not Allowed
Y=Allowed
24 AUC_CREATE_XML_FLG Character(1) VARCHAR2(1) NOT NULL Event PDF File Flag
25 AUC_BID_COMPETE Character(1) VARCHAR2(1) NOT NULL Bid Compete
L=Line Level
T=Event Level
26 AUC_BID_SCORE_OPT Character(1) VARCHAR2(1) NOT NULL Bid Score Optimization
B=Own Bid
W=Winning Bid
27 AUC_PROXY_FLG Character(1) VARCHAR2(1) NOT NULL Proxy Flag
N=Disabled
Y=Enabled
28 AUC_EVENT_BASE Character(1) VARCHAR2(1) NOT NULL Event Base
P=Price Based
S=Score Based
29 AUC_COMP_BID Character(1) VARCHAR2(1) NOT NULL Competitor Bids
X=Do Not Display
Y=Display and Show Identity
Z=Display but Hide Identity
30 SCP_STRT_DATE_CHAR Character(26) VARCHAR2(26) NOT NULL Generic space field
31 SCP_END_DATE_CHAR Character(26) VARCHAR2(26) NOT NULL Generic space field
32 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
33 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code