BUSINESS_UNITPrompt Table: AUC_BU_ASSGN_VW
AUC_IDF=Sell
I=RFI
R=Buy
S=Service
E=Auction
S=RFx
AUC_HDR_PLN_VW(SQL View) |
Index Back |
|---|---|
Sourcing events for Planning |
| SELECT DISTINCT business_unit , auc_id , auc_format , auc_type , auc_name FROM PS_AUC_HDR WHERE auc_tmplte_flg <> 'Y' AND auc_format <> 'S' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: AUC_BU_ASSGN_VW |
| 2 | AUC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 3 | AUC_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Event Format
F=Sell I=RFI R=Buy S=Service |
| 4 | AUC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
E=Auction S=RFx |
| 5 | AUC_NAME | Character(50) | VARCHAR2(50) NOT NULL | Event Name |