PSDMT_RUN_VW_LG

(SQL View)
 Index Back

MTM Transactions Prompt


SELECT A.PS_OWNER , A.PSDMUNIT_ID , L.LANGUAGE_CD , L.DESCR50 , B.OPRCLASS FROM %Table(PSDMT_UNIT_HDR) A , %Table(PSDMT_OSECURITY) B , %Table(PSDMT_UNIT_H_LG) L WHERE A.ACTIVE_STATUS = 'A' AND A.PUBLIC_SW = 'Y' AND A.PS_OWNER = B.PS_OWNER AND A.PSDMUNIT_ID = B.PSDMUNIT_ID AND A.PS_OWNER = L.PS_OWNER AND A.PSDMUNIT_ID = L.PSDMUNIT_ID

  • Related Language Record for PSDMT_RUN_AM_VW PSDMT_RUN_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class