AUC_TILE_USER

(SQL Table)
Index Back

PO Tile User Prefernces

  • Parent Record Of AUC_BU_SL_FL
  • # 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