PSDMT_UNITARG

(SQL Table)
 Index Back

MTM User Entered Values

  • Parent record: PSDMT_UNIT_SEQ

    • # 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 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDMT_UEVFLDSVW

    5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    6 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

    Prompt Table: PSDMT_SRCHLBLVW

    7 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

    Default Value: 1

    8 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table

    Prompt Table: IT_PSRECDEFN

    9 UPDT_SETID_FROM Number(4,0) SMALLINT NOT NULL Field Number
    10 UPDT_BUS_UNIT_FROM Number(4,0) SMALLINT NOT NULL Field Number
    11 UPDT_KEY_FROM Number(4,0) SMALLINT NOT NULL Field Number
    12 UPDT_KEY_CURR_FROM Number(4,0) SMALLINT NOT NULL Field Number
    13 SETID_FIELD Character(18) VARCHAR2(18) NOT NULL SetID Field

    Prompt Table: PSRECFIELDALL

    14 RECNAME_SETID Character(15) VARCHAR2(15) NOT NULL Set Id Record Name

    Prompt Table: IT_CNTRL_REC_VW

    15 PSDMT_REQUIRED_SW Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    16 PSDMT_ALLOW_EMPTY Character(1) VARCHAR2(1) NOT NULL Allow Empty

    Y/N Table Edit

    17 FIELD_ORDER Number(3,0) SMALLINT NOT NULL Field Order
    18 PSDMT_CUSTOM_SW Character(1) VARCHAR2(1) NOT NULL Custom