RESP_AUCDTL_VW(SQL View) |
Index Back |
---|---|
Resp confirm ViewResp confirm View |
SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , B.AUC_STATUS , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , 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_DTTM_START , B.AUC_DTTM_FINISH FROM PS_AUC_DISP_HDR A , PS_AUC_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 B.AUC_STATUS IN( 'P','Q') AND A.BIDDER_TYPE IN ('P','V') AND B.AUC_TYPE IN ('E','S') AND B.AUC_FORMAT IN ('F','R','I') AND B.AUC_DTTM_FINISH >= %CurrentDateTimeIn AND 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 | 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 | AUC_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Event Format
F=Sell I=RFI R=Buy S=Service |
10 | AUC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
E=Auction S=RFx |
11 | BLIND_FLG | Character(1) | VARCHAR2(1) NOT NULL | Sealed Event |
12 | AUC_NAME | Character(50) | VARCHAR2(50) NOT NULL | Event Name |
13 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
14 | AUC_DTTM_START | DateTime(26) | TIMESTAMP | Date Time Start |
15 | AUC_DTTM_FINISH | DateTime(26) | TIMESTAMP | Date Time Finish |
16 | AUC_DTTM_PREVIEW | DateTime(26) | TIMESTAMP | Date Time Preview |
17 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
18 | DESCRLONG | Long Character | CLOB | Long Description |
19 | 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. |
20 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
21 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
22 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
23 | AUC_DSP_RNDVER | Character(1) | VARCHAR2(1) NOT NULL |
Display Round/Version
N=Do Not Display R=Display Round V=Display Round and Version |
24 | 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 |
25 | AUC_INFO_SMSG2 | Character(50) | VARCHAR2(50) NOT NULL | Informational Message |
26 | MULTIPLE_BIDS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Bids Allowed
N=Not Allowed Y=Allowed |
27 | SCP_STRT_DATE_CHAR | Character(26) | VARCHAR2(26) NOT NULL | Generic space field |
28 | SCP_END_DATE_CHAR | Character(26) | VARCHAR2(26) NOT NULL | Generic space field |