PSDMT_INSTANCEU

(SQL Table)
Index Back

Saved Search User Entered Val

  • Parent record: PSDMT_SRCHH_AUX
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    2 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
    3 PSDMUNIT_ID Character(30) VARCHAR2(30) NOT NULL Transaction
    4 SEARCH_SAVE_ID Character(30) VARCHAR2(30) NOT NULL Save Search As
    5 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    11 KEY_CHAR_30_01 Character(30) VARCHAR2(30) NOT NULL Key Char(30) 01
    12 KEY_DATE_01 Date(10) DATE Key Date 01
    13 KEY_SIGN_NUM_28_0 Signed Number(29,0) DECIMAL(28) NOT NULL Key 1
    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    15 MTM_UPDT_ACTION Character(1) VARCHAR2(1) NOT NULL Update Action
    A=Set equal to
    B=Set to Empty
    16 FIELDVALUE_CHAR1 Character(30) VARCHAR2(30) NOT NULL Value
    17 FIELDVALUE_CHR_DD1 Character(30) VARCHAR2(30) NOT NULL Value

    Prompt Table: DUMMY_PROMPT_VW

    18 FIELDVALUE_NUM1 Signed Number(29,0) DECIMAL(28) NOT NULL Value
    19 FIELDVALUE_DT1 Date(10) DATE Value
    20 FIELDVALUE_CHAR1P Character(30) VARCHAR2(30) NOT NULL Value

    Prompt Table: %EDITTABLE4

    21 FIELDVALUE_DT1P Date(10) DATE Value

    Prompt Table: %EDITTABLE6

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

    Prompt Table: %EDITTABLE5

    23 FIELDVALUE_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Value
    24 FIELDVALUE_DEC1 Signed Number(31,6) DECIMAL(29,6) NOT NULL Value