PSDMT_SRCHS_AUX

(SQL Table)
 Index Back

MTM In Search Keys

  • 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 PSDMUNIT_FIELDSEQ Number(3,0) SMALLINT NOT NULL Field Sequence
    5 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label
    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    7 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    8 LENGTH Number(5,0) INTEGER NOT NULL Length
    9 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    10 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

    11 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

    12 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

    13 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    16 FIELDVALUE_CHAR1 Character(30) VARCHAR2(30) NOT NULL Value
    17 FIELDVALUE_CHAR2 Character(30) VARCHAR2(30) NOT NULL Value
    18 FIELDVALUE_NUM1 Signed Number(29,0) DECIMAL(28) NOT NULL Value
    19 FIELDVALUE_NUM2 Signed Number(29,0) DECIMAL(28) NOT NULL Value
    20 FIELDVALUE_DT1 Date(10) DATE Value
    21 FIELDVALUE_DT2 Date(10) DATE Value
    22 FIELDVALUE_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Value
    23 FIELDVALUE_AMT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Value
    24 FIELDVALUE_DEC1 Signed Number(31,6) DECIMAL(29,6) NOT NULL Value
    25 FIELDVALUE_DEC2 Signed Number(31,6) DECIMAL(29,6) NOT NULL Value
    26 UPPER_SW Character(1) VARCHAR2(1) NOT NULL Upper Case
    27 USER_DEFINED Character(1) VARCHAR2(1) NOT NULL User Defined Combination Data

    Default Value: N