AR_ACCT_CNTL_VW

(SQL View)
Index Back

Account non-Control View

This view is used for prompting on selected pages, for non-controlled (control_flag=N) and non-budgetary-only (budgetary_only=N) accounts.

SELECT SETID , ACCOUNT , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , ACCOUNT_TYPE , CONTROL_FLAG , SYNCID , SYNCDTTM FROM PS_GL_ACCOUNT_TBL WHERE CONTROL_FLAG = 'N' AND BUDGETARY_ONLY = 'N'

  • Related Language Record: AR_ACCNT_LNGVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 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.
    8 CONTROL_FLAG Character(1) VARCHAR2(1) NOT NULL This flag in used to desginate an Account or Alternate Account as Control Accounts and Control Alternate Accounts, respectively.
    9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

    Default Value: %datetime