AUC_TILE_USER(SQL Table) |
Index Back |
---|---|
PO Tile User Prefernces |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | PUBLIC_FLG_AUC | Character(3) | VARCHAR2(3) NOT NULL |
Send to Vendor
N=No Y=Yes |
3 | BID_RESP_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Bid Response Selection
N=No Y=Yes |
4 | END_DATE_SEL | Character(1) | VARCHAR2(1) NOT NULL |
End Date Selection
N=No Y=Yes |
5 | EVENT_ID_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Event ID selection
N=No Y=Yes |
6 | START_DATE_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Start Date Selection
N=No Y=Yes |
7 | SEALED_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Sealed Selection
N=No Y=Yes |
8 | BUYER_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Buyer Selection
N=No Y=Yes |
9 | TOTAL_AMOUNT_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Total Amount Selection
N=No Y=Yes |
10 | STATUS_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Status Selection
N=No Y=Yes |
11 | FROM_DATE | Date(10) | DATE | From Date |
12 | TO_DATE | Date(10) | DATE | To Date |
13 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
15 | EVENT_AMOUNT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Event Amount Flag
N=No Y=Yes |
16 | RFX_DAYS_PRIOR | Number(5,0) | INTEGER NOT NULL |
Days Prior
Default Value: 0 |
17 | BU_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Business Units
E=Show All N=Show All S=Specify Business Unit Y=Specify Business Units Default Value: E |
18 | AUC_ITEM_CAT_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Item/Category Selection
A=Specific Items E=Show All I=Specify Items N=All S=Specify Categories Y=Specific Categories Default Value: E |
19 | BUYER_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Buyers
E=Show All N=Show All S=Specify Buyer Y=Specify Buyers Default Value: E |
20 | DATA_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Data Selection
N=All Y=Specific Default Value: N |
21 | NUM_BID_INVITED | Character(1) | VARCHAR2(1) NOT NULL |
Number of Bidders Invited
N=All Y=Specific Default Value: Y |
22 | NUM_BID_RESPONSE | Character(1) | VARCHAR2(1) NOT NULL |
Number of Bidders Responding
N=All Y=Specific Default Value: Y |
23 | NUM_UNSOLICIT_BID | Character(1) | VARCHAR2(1) NOT NULL |
Number of Unsolicited Bidders
N=All Y=Specific Default Value: Y |
24 | RFX_CLOSE_DATE | Character(1) | VARCHAR2(1) NOT NULL |
RFX Close Date
N=All Y=Specific Default Value: Y |
25 | RFX_AWARD | Character(1) | VARCHAR2(1) NOT NULL |
RFX Awarded
N=All Y=Specific Default Value: Y |
26 | DEFINE_FILTERS | Character(1) | VARCHAR2(1) NOT NULL |
Define Filters
N=Include All Y=Define Filters |