PSDMT_UNIT_HDR

(SQL Table)
 Index Back

MTM Transaction Header

  • Related Language Record: PSDMT_UNIT_H_LG

  • Parent record: PSDMT_OWNER_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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
    A=Active
    I=Inactive
    5 UPDATE_FLAG Character(1) VARCHAR2(1) NOT NULL Update Prior Operations

    Y/N Table Edit

    Default Value: Y

    6 PUBLIC_SW Character(1) VARCHAR2(1) NOT NULL Public

    Y/N Table Edit

    Default Value: N

    7 MTM_USE_AELIB_SW Character(1) VARCHAR2(1) NOT NULL Use Application Engine Library

    Y/N Table Edit

    8 MTM_SHOW_RQST_SW Character(1) VARCHAR2(1) NOT NULL Show Requested Fields Section

    Y/N Table Edit

    9 PSDMT_CUSTOM_SW Character(1) VARCHAR2(1) NOT NULL Custom
    10 PREVIEW_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status
    11 DESCRLONG Long Character CLOB Long Description