PSDMT_SRCH_AUX

(SQL Table)
 Index Back

MTM Search Table for Subpage

  • Parent record: PSDMT_SRCHH_AUX

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PS_OWNER Character(2) VARCHAR2(2) NOT NULL PeopleSoft Owner
    AM=Asset Management
    AP=Accounts Payable
    AR=Accounts Receivable
    BD=Budgets
    BI=Billing
    CA=Contracts
    CM=Cost Management
    CS=Customer Service
    EN=Engineering
    EX=Expenses
    GL=General Ledger
    HR=Human Resources
    IN=Inventory
    MG=Manufacturing
    OM=Order Management
    PC=Project Costing
    PL=Planning
    PO=Purchasing
    PR=Production Control
    PT=PeopleTools
    TL=Time and Labor
    TR=Treasury
    2 PSDMUNIT_ID Character(30) VARCHAR2(30) NOT NULL Transaction
    3 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    4 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label
    5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    6 RECALIAS Character(15) VARCHAR2(15) NOT NULL Record Alias
    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    8 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    9 LENGTH Number(5,0) INTEGER NOT NULL Length
    10 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    11 PSDMT_LOPER_CHAR Character(1) VARCHAR2(1) NOT NULL Logic Operator
    1==
    2=<>
    3=>
    4=<
    5=>=
    6=<=
    7=Like
    8=Not Like
    9=Is Empty
    A=Between
    B=Not Between
    C=In List
    D=Not In List

    Default Value: 1

    12 PSDMT_LOPER_DATE Character(1) VARCHAR2(1) NOT NULL Logic Operator
    1==
    2=<>
    3=>
    4=<
    5=>=
    6=<=
    7=Begins with
    8=Does NOT begins with
    9=Is Empty
    A=Between
    B=Not Between
    C=In List
    D=Not In List

    Default Value: 1

    13 PSDMT_LOPER_NUM Character(1) VARCHAR2(1) NOT NULL Logic Operator
    1==
    2=<>
    3=>
    4=<
    5=>=
    6=<=
    7=Like
    8=Does NOT begins with
    9=Is Empty
    A=Between
    B=Not Between
    C=In List
    D=Not In List

    Default Value: 1

    14 PROMPT_EDITTYPE Character(1) VARCHAR2(1) NOT NULL Edit Type
    1=No Table Edit
    2=Prompt Table
    3=Translate Table
    4=Yes/No
    5=Currency Controlled
    15 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table
    16 UPDT_SETID_FROM Number(4,0) SMALLINT NOT NULL Field Number
    17 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    18 UPDT_BUS_UNIT_FROM Number(4,0) SMALLINT NOT NULL Field Number
    19 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    20 UPDT_KEY_CHAR_FROM Number(4,0) SMALLINT NOT NULL Field Number
    21 KEY_CHAR_30_01 Character(30) VARCHAR2(30) NOT NULL Key Char(30) 01
    22 UPDT_KEY_DATE_FROM Number(4,0) SMALLINT NOT NULL Field Number
    23 KEY_DATE_01 Date(10) DATE Key Date 01
    24 UPDT_KEY_SIGN_FROM Number(4,0) SMALLINT NOT NULL Field Number
    25 UPDT_KEY_FROM Number(4,0) SMALLINT NOT NULL Field Number
    26 KEY_SIGN_NUM_28_0 Signed Number(29,0) DECIMAL(28) NOT NULL Key 1
    27 UPDT_KEY_CURR_FROM Number(4,0) SMALLINT NOT NULL Field Number
    28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    29 FIELDVALUE_CHAR1 Character(30) VARCHAR2(30) NOT NULL Value
    30 FIELDVALUE_CHAR2 Character(30) VARCHAR2(30) NOT NULL Value
    31 FIELDVALUE_CHR_DD1 Character(30) VARCHAR2(30) NOT NULL Value

    Prompt Table: DUMMY_PROMPT_VW

    32 FIELDVALUE_CHR_DD2 Character(30) VARCHAR2(30) NOT NULL Value

    Prompt Table: DUMMY_PROMPT_VW

    33 FIELDVALUE_NUM1 Signed Number(29,0) DECIMAL(28) NOT NULL Value
    34 FIELDVALUE_NUM2 Signed Number(29,0) DECIMAL(28) NOT NULL Value
    35 FIELDVALUE_DT1 Date(10) DATE Value
    36 FIELDVALUE_DT2 Date(10) DATE Value
    37 FIELDVALUE_CHAR1P Character(30) VARCHAR2(30) NOT NULL Value

    Prompt Table: %EDITTABLE

    38 FIELDVALUE_CHAR2P Character(30) VARCHAR2(30) NOT NULL Value

    Prompt Table: %EDITTABLE

    39 FIELDVALUE_DT1P Date(10) DATE Value

    Prompt Table: %EDITTABLE3

    40 FIELDVALUE_DT2P Date(10) DATE Value

    Prompt Table: %EDITTABLE3

    41 FIELDVALUE_NUM1P Signed Number(29,0) DECIMAL(28) NOT NULL Value

    Prompt Table: %EDITTABLE2

    42 FIELDVALUE_NUM2P Signed Number(29,0) DECIMAL(28) NOT NULL Value

    Prompt Table: %EDITTABLE2

    43 FIELDVALUE_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Value
    44 FIELDVALUE_AMT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Value
    45 FIELDVALUE_DEC1 Signed Number(31,6) DECIMAL(29,6) NOT NULL Value
    46 FIELDVALUE_DEC2 Signed Number(31,6) DECIMAL(29,6) NOT NULL Value
    47 SETID_FIELD Character(18) VARCHAR2(18) NOT NULL SetID Field
    48 RECNAME_SETID Character(15) VARCHAR2(15) NOT NULL Set Id Record Name
    49 UPPER_SW Character(1) VARCHAR2(1) NOT NULL Upper Case
    50 PSDMT_LIST_VALUES Long Character CLOB List of Values
    51 PSDMT_LIST_PB Character(1) VARCHAR2(1) NOT NULL List
    52 PSDMT_LIST_FIELD Character(18) VARCHAR2(18) NOT NULL List Field
    53 PSDMT_LISTBUILT_SW Character(1) VARCHAR2(1) NOT NULL List Built

    Y/N Table Edit

    Default Value: N

    54 PSDMT_REQUIRED_SW Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit