BANK_CF_ACCT_VW (SQL View)	Index Back
GL Account View Uses BUS_UNIT_TBL_GL

BANK_CF_ACCT_VW

(SQL View)

GL Account View

Uses BUS_UNIT_TBL_GL

SELECT b.business_unit , a.account , a.descr , a.descrshort , a.account_type FROM PS_GL_ACCOUNT_TBL a , ps_bus_unit_tbl_gl b , ps_set_cntrl_rec c WHERE b.business_unit = c.setcntrlvalue AND c.recname = 'GL_ACCOUNT_TBL' AND c.setid = a.setid AND a.statistics_account = 'N' AND a.eff_status = 'A' AND a.effdt = ( SELECT MAX(d.effdt) FROM PS_GL_ACCOUNT_TBL d WHERE d.account = a.account AND d.setid = a.setid AND d.effdt <= %CurrentDateIn)

Related Language Record: BANK_CF_ACCT_L2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
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.