BNK_CF_ALTACT_V (SQL View)	Index Back
GL Account View Uses BUS_UNIT_TBL_GL 12/12/2005 cmh Moved EFFDT field up

BNK_CF_ALTACT_V

(SQL View)

GL Account View

Uses BUS_UNIT_TBL_GL 12/12/2005 cmh Moved EFFDT field up

SELECT b.business_unit , a.altacct , a.effdt , a.descr , a.descrshort , a.account_type FROM ps_altacct_tbl a , PS_BUS_UNIT_TBL_GL b , ps_set_cntrl_rec c WHERE b.business_unit = c.setcntrlvalue AND c.recname = 'ALTACCT_TBL' AND c.setid = a.setid AND a.statistics_account = 'N' AND a.effdt = ( SELECT MAX(d.effdt) FROM ps_altacct_tbl d WHERE d.altacct = a.altacct AND d.setid = a.setid AND d.eff_status = 'A')

Related Language Record: BANK_CF_ACCT_LG

# 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 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

6 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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	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.