BUSINESS_UNITDefault Value: AUC_HDR.BUSINESS_UNIT
AUC_FORMATF=Sell
I=RFI
R=Buy
S=Service
Default Value: AUC_HDR.AUC_FORMAT
AUC_TYPEE=Auction
S=RFx
Default Value: AUC_COPY_WRK.AUC_TYPE
AUC_IDB=Business Unit
D=Department
P=Personal
AUC_TMPLTE_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT BUSINESS_UNIT , AUC_FORMAT , AUC_TYPE , AUC_ID , AUC_TMPLTE_TYPE , AUC_TMPLTE_ID , AUC_TMPLTE_DESCR FROM PS_AUC_HDR WHERE AUC_TMPLTE_FLG = 'Y' AND AUC_TMPLTE_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AUC_HDR.BUSINESS_UNIT |
| 2 | AUC_FORMAT |
Character(1) | VARCHAR2(1) NOT NULL |
Event Format
F=Sell I=RFI R=Buy S=Service Default Value: AUC_HDR.AUC_FORMAT |
| 3 | AUC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Event Type
E=Auction S=RFx Default Value: AUC_COPY_WRK.AUC_TYPE |
| 4 | AUC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 5 | AUC_TMPLTE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Template Type
B=Business Unit D=Department P=Personal |
| 6 | AUC_TMPLTE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID |
| 7 | AUC_TMPLTE_DESCR | Character(25) | VARCHAR2(25) NOT NULL | Template Description |