BUSINESS_UNITDefault Value: AUC_COPY_WRK.BUSINESS_UNIT
Prompt Table: AUC_BU_ASSGN_VW
AUC_FORMATF=Sell
I=RFI
R=Buy
S=Service
Default Value: AUC_COPY_WRK.AUC_FORMAT
AUC_TYPEE=Auction
S=RFx
Default Value: AUC_COPY_WRK.AUC_TYPE
AUC_IDAUC_HDR_COPY_VW(SQL View) |
Index Back |
|---|---|
Eligible events for copy |
| SELECT DISTINCT business_unit , auc_format , auc_type , auc_id , auc_name FROM PS_AUC_HDR WHERE auc_tmplte_flg <> 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AUC_COPY_WRK.BUSINESS_UNIT Prompt Table: AUC_BU_ASSGN_VW |
| 2 | AUC_FORMAT |
Character(1) | VARCHAR2(1) NOT NULL |
Event Format
F=Sell I=RFI R=Buy S=Service Default Value: AUC_COPY_WRK.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_NAME | Character(50) | VARCHAR2(50) NOT NULL | Event Name |