RESP_INQA_HD_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,A.BUSINESS_UNIT %Concat '-' %Concat A.AUC_ID ,A.AUC_FORMAT ,A.AUC_TYPE ,A.AUC_NAME ,A.AUC_STATUS ,A.TIMEZONE ,A.AUC_DTTM_PREVIEW ,A.AUC_DTTM_START ,A.AUC_DTTM_FINISH ,A.PYMNT_TERMS_CD ,A.CURRENCY_CD ,A.ORIGIN ,A.BLIND_FLG ,A.AUC_PRELIM_BID ,A.AUC_EDIT_RESP ,A.AUC_SCORE_RFI ,A.CATEGORY_ID ,A.AUC_CREATE_XML_FLG ,A.AUC_DISP_AWD_DET ,A.AUC_DSP_WIN_SCORE FROM PS_AUC_HDR A

# 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_ID_BUS_UNIT Character(18) VARCHAR2(18) NOT NULL Event ID
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 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
9 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
10 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE

11 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
12 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
13 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish
14 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.

Prompt Table: PYMT_TR_EFF_VW

15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

16 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
17 BLIND_FLG Character(1) VARCHAR2(1) NOT NULL Sealed Event

Y/N Table Edit

Default Value: N

18 AUC_PRELIM_BID Character(1) VARCHAR2(1) NOT NULL Allow Preliminary Bids

Y/N Table Edit

Default Value: N

19 AUC_EDIT_RESP Character(1) VARCHAR2(1) NOT NULL Edit Posted Response

Y/N Table Edit

Default Value: N

20 AUC_SCORE_RFI Character(1) VARCHAR2(1) NOT NULL Score RFI Event

Y/N Table Edit

Default Value: N

21 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
22 AUC_CREATE_XML_FLG Character(1) VARCHAR2(1) NOT NULL Event PDF File Flag
23 AUC_DISP_AWD_DET Character(1) VARCHAR2(1) NOT NULL Show Award Details
24 AUC_DSP_WIN_SCORE Character(1) VARCHAR2(1) NOT NULL Display Winning Score