KK_INCL_ACCTS

(SQL Table)
Index Back

  • Parent record: KK_EX_ACCT_TYPE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value
    2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    5 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue.

    Prompt Table: ACCT_TYPE_TBL

    6 SETID_ACCOUNT Character(5) VARCHAR2(5) NOT NULL Account Table Setid

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: KK_ACCT_EXCP_VW

    8 ACCOUNT_TO Character(10) VARCHAR2(10) NOT NULL To Account

    Prompt Table: KK_ACCT_EXCP_VW

    9 KK_STATUS_LN Character(1) VARCHAR2(1) NOT NULL Line Status
    E=Error
    N=Not Validated
    V=Valid

    Default Value: N

    10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.