KK_NTFY_SOURCE

(SQL Table)
Index Back

Commit Control Source Prefs

  • Parent record: KK_NTFY_BUDGET
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_FS_NONVW

    3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

    Prompt Table: KK_BUDGET_TYPE

    4 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL

    5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    6 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type

    Prompt Table: KK_SOURCE_TRAN

    7 SOURCE_SELECT_FLG Character(1) VARCHAR2(1) NOT NULL Source Selected Flag

    Y/N Table Edit

    Default Value: Y