AUC_ROUND_VW

(SQL View)
Index Back

AUC_ROUND View


SELECT DISTINCT BUSINESS_UNIT , BUSINESS_UNIT , AUC_FORMAT , AUC_ID , AUC_ROUND FROM PS_AUC_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 TO_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field
3 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
4 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
5 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round