PSDMT_FILLUEVVW

(SQL View)
 Index Back

MTM Fill User Entered Values


SELECT DISTINCT A.PS_OWNER , A.PSDMUNIT_ID , A.FIELDNAME , A.LABEL_ID , B.LONGNAME , C.FIELDTYPE , C.LENGTH , C.DECIMALPOS , A.PROMPT_EDITTYPE , A.PROMPT_TBL , A.FIELDNUM , 'A' , %subrec(PSDMT_SRCHPROPS, A) , A.PSDMT_REQUIRED_SW , A.PSDMT_ALLOW_EMPTY , CASE WHEN A.FIELD_ORDER = 0 THEN 999 ELSE A.FIELD_ORDER END FROM %Table(PSDMT_UNITARG) A , %Table(PSDBFLDLABL) B , %Table(PSDBFIELD) C , %Table(PSRECFIELDDB) D , %Table(MTM_PRODUCT_CFG) E WHERE A.FIELDNAME NOT IN ( SELECT I.FIELDNAME FROM %Table(PSDMT_INACTCHVW) I) AND A.FIELDNAME = B.FIELDNAME AND A.LABEL_ID = B.LABEL_ID AND B.FIELDNAME = C.FIELDNAME AND C.FIELDNAME = D.FIELDNAME AND E.PS_OWNER = A.PS_OWNER AND D.RECNAME = E.MTM_UEV_SBR

  • Related Language Record: PSDMT_FILUEW_LG

    • # 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 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFIELDALL

    4 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    5 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label
    6 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    7 LENGTH Number(5,0) INTEGER NOT NULL Length
    8 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    9 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
    10 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table

    Prompt Table: PSRECDEFN_VW3

    11 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    12 MTM_UPDT_ACTION Character(1) VARCHAR2(1) NOT NULL Update Action
    A=Set equal to
    B=Set to Empty
    13 UPDT_SETID_FROM Number(4,0) SMALLINT NOT NULL Field Number
    14 UPDT_BUS_UNIT_FROM Number(4,0) SMALLINT NOT NULL Field Number
    15 UPDT_KEY_FROM Number(4,0) SMALLINT NOT NULL Field Number
    16 UPDT_KEY_CURR_FROM Number(4,0) SMALLINT NOT NULL Field Number
    17 SETID_FIELD Character(18) VARCHAR2(18) NOT NULL SetID Field
    18 RECNAME_SETID Character(15) VARCHAR2(15) NOT NULL Set Id Record Name
    19 PSDMT_REQUIRED_SW Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    20 PSDMT_ALLOW_EMPTY Character(1) VARCHAR2(1) NOT NULL Allow Empty
    21 FIELD_ORDER Number(3,0) SMALLINT NOT NULL Field Order