KK_PANEL_EVENT

(SQL Table)
 Index Back

Comm Cntrl Activity Inq/Excptn

This record is a child of KK_SOURCE_TRAN. It is used to eliminiate the hardcoding of line view, header views, exception views, message numbers, and secondary panel names in Commitment Control Exception Handling and Inquiry.

  • Parent record: KK_SOURCE_TRAN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type
    2 KK_HEADER_VW Character(15) VARCHAR2(15) NOT NULL Source Header View

    Prompt Table: RECDEFN_VW

    3 KK_HEADER_ID_FIELD Character(18) VARCHAR2(18) NOT NULL Source Header ID Field Name

    Prompt Table: KK_HEADER_ID_VW

    4 KK_HEADER_ID_LBL Character(4) VARCHAR2(4) NOT NULL Source Header ID Label
    AP=Voucher ID:
    AR1=Customer ID:
    AR2=Deposit ID:
    BI=Invoice:
    CM=Item ID:
    EX1=Travel Auth ID:
    EX2=Report ID:
    EX3=Document Id:
    GEN=Transaction Nbr:
    GL=Journal ID:
    GM=Project ID:
    HP=Document ID
    HR=Run Date:
    HYP=Hyperion Budget Transaction ID
    PC=Interface ID:
    PO1=Purchase Order:
    PO2=Requisition ID:
    PO3=Employee ID:
    PO4=Receiver ID:
    5 KK_LINE_VW Character(15) VARCHAR2(15) NOT NULL Source Line View

    Prompt Table: RECDEFN_VW

    6 KK_LINE_PROMPT_VW Character(15) VARCHAR2(15) NOT NULL Source Line # Prompt View

    Prompt Table: RECDEFN_VW

    7 KK_LINE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Source Line # Field Name

    Prompt Table: KK_LINEFIELD_VW

    8 KK_DRL_SRC_PNLNAME Character(18) VARCHAR2(18) NOT NULL Source Drill Down Page

    Prompt Table: KK_SEC_PNL_VW

    9 KK_EXCPTN_VW Character(15) VARCHAR2(15) NOT NULL Source Exception Line View

    Prompt Table: RECDEFN_VW

    10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    11 KK_INQ_SHDR_FLD1 Character(18) VARCHAR2(18) NOT NULL 1st Source Header ID Field

    Prompt Table: KK_SHDR_ID_VW

    12 KK_INQ_SHDR_FLD2 Character(18) VARCHAR2(18) NOT NULL 2nd Source Header ID Field

    Prompt Table: KK_SHDR_ID_VW

    13 KK_INQ_SHDR_PRMT1 Character(15) VARCHAR2(15) NOT NULL 1st Source Header ID Prompt

    Prompt Table: RECDEFN_VW

    14 KK_INQ_SHDR_PRMT2 Character(15) VARCHAR2(15) NOT NULL 2nd Source Header ID Prompt

    Prompt Table: RECDEFN_VW

    15 KK_INQ_SHDR_LBL1 Character(4) VARCHAR2(4) NOT NULL 1st Source Header ID Label
    16 KK_INQ_SHDR_LBL2 Character(4) VARCHAR2(4) NOT NULL 2nd Source Header ID Label