PSDMT_OWNER_VW

(SQL View)
 Index Back

MTM Search Record


SELECT %Substring(A.FIELDVALUE, 1, 2) , A.XLATLONGNAME FROM %Table(XLATTABLE_VW) A WHERE FIELDNAME = 'PS_OWNER' AND %EffdtCheck(XLATTABLE_VW B, A, %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Parent Record Of PSDMT_UNIT_HDR PSDMT_UNIT_H_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description