ACCT_TYPE2_VW (SQL View)	Index Back
SrchRec for Account Types NEW IN GL9. set control field is set to SETID since this is used ias prompt table for GL_ACCT_ALL_VW.ACCOUNT_TYPE on the prompt page for Account. Since there is no Business Unit on the prompt page, we need to use SETID as set control field to drive the list.

ACCT_TYPE2_VW

(SQL View)

SrchRec for Account Types

NEW IN GL9. set control field is set to SETID since this is used ias prompt table for GL_ACCT_ALL_VW.ACCOUNT_TYPE on the prompt page for Account. Since there is no Business Unit on the prompt page, we need to use SETID as set control field to drive the list.

SELECT SETID , ACCOUNT_TYPE , DESCR , DESCRSHORT , BALANCE_FWD_SW FROM PS_ACCT_TYPE_TBL

Related Language Record: ACCT_TYPE_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
Prompt Table: SP_SETID_NONVW

2 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.

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

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

5 BALANCE_FWD_SW Character(1) VARCHAR2(1) NOT NULL A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year.
N=Not Carry Forward
O=Other
Y=Carry Forward

#	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 Prompt Table: SP_SETID_NONVW
2	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.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	BALANCE_FWD_SW	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year. N=Not Carry Forward O=Other Y=Carry Forward