AUC_HDR_UNQ_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , 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.CURRENCY_CD , A.ORIGIN , A.BILL_LOCATION , A.REQUESTOR_ID , A.BUYER_ID , A.BLIND_FLG , A.AUC_ALL_LINES_FLG FROM PS_AUC_HDR A WHERE A.AUC_ROUND = ( SELECT MAX(AUC_ROUND) FROM PS_AUC_HDR X WHERE X.BUSINESS_UNIT = A.BUSINESS_UNIT AND X.AUC_ID = A.AUC_ID) AND A.AUC_VERSION = ( SELECT MAX(AUC_VERSION) FROM PS_AUC_HDR Y WHERE Y.BUSINESS_UNIT = A.BUSINESS_UNIT AND Y.AUC_ID = A.AUC_ID AND Y.AUC_ROUND = A.AUC_ROUND AND Y.AUC_STATUS NOT IN ('O', 'z') )

# 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

Default Value: NEXT

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

Default Value: 1

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

Default Value: 1

5 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
6 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
7 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
8 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

Default Value: O

9 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE

10 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
11 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
12 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_A1.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

14 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
15 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

Default Value: BUS_UNIT_TBL_A1.BILL_LOCATION

Prompt Table: LOCATION_TBL

16 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Prompt Table: RQSTR_ACTIVE_VW

17 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_ACTIVE_VW

18 BLIND_FLG Character(1) VARCHAR2(1) NOT NULL Sealed Event

Y/N Table Edit

Default Value: N

19 AUC_ALL_LINES_FLG Character(1) VARCHAR2(1) NOT NULL Bid Required on all lines

Y/N Table Edit

Default Value: N