AUC_AN_SRCH(SQL View) |
Index Back |
|---|---|
Event Create add search recordEvent Create add search record |
| SELECT a.business_unit , a.auc_id , a.auc_round , a.auc_version , a.auc_format , a.auc_type , a.auc_proxy_flg , a.auc_tmplte_type , a.auc_tmplte_id FROM PS_AUC_HDR a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_AUC_BU_NONVW |
| 2 | AUC_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Event ID
Default Value: NEXT Prompt Table: AUC_AN_VW |
| 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_PROXY_FLG |
Character(1) | VARCHAR2(1) NOT NULL |
Proxy Flag
N=Disabled Y=Enabled Default Value: BUS_UNIT_TBL_A1.AUC_PROXY_FLG |
| 8 | AUC_TMPLTE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Template Type
B=Business Unit D=Department P=Personal |
| 9 | AUC_TMPLTE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Template ID |