KK_EXCL_ACCT_VW (SQL View)	Index Back
Non Statistics Account View This view is used for prompting on the CC budget definition excluded accounts page. It filters out account values where the Control Flag = 'Y' and Statistics Account = 'N' and retrieves the maximum effective dated account value where there is atleast one effective dated row that is active. This is not how effective dated logic is typically handled. However, this approach was taken to avoid having the customer create a new effective dated row in the budget definition each time they added a new account that they wanted to be excluded from budget checking.

KK_EXCL_ACCT_VW

(SQL View)

Non Statistics Account View

This view is used for prompting on the CC budget definition excluded accounts page. It filters out account values where the Control Flag = 'Y' and Statistics Account = 'N' and retrieves the maximum effective dated account value where there is atleast one effective dated row that is active. This is not how effective dated logic is typically handled. However, this approach was taken to avoid having the customer create a new effective dated row in the budget definition each time they added a new account that they wanted to be excluded from budget checking.

SELECT A.SETID , A.ACCOUNT , A.DESCR , A.DESCRSHORT , A.ACCOUNT_TYPE , A.BUDGETARY_ONLY FROM PS_GL_ACCOUNT_TBL A WHERE A.CONTROL_FLAG = 'N' AND A.STATISTICS_ACCOUNT = 'N' AND A.EFFDT= ( SELECT MAX(B.EFFDT) FROM PS_GL_ACCOUNT_TBL B WHERE B.SETID=A.SETID AND B.ACCOUNT=A.ACCOUNT AND B.EFF_STATUS<>'I')

Related Language Record: KK_EXLACCT_LANG

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

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.

6 BUDGETARY_ONLY Character(1) VARCHAR2(1) NOT NULL Budgetary Only

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
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.
6	BUDGETARY_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Budgetary Only