FEC_AAAT_TBL_VW (SQL View)	Index Back
Accounts

FEC_AAAT_TBL_VW

(SQL View)

Accounts

SELECT G.SETID ,G.ALTACCT ,G.DESCR , G.ACCOUNT_TYPE , A.DESCR ,A.BALANCE_FWD_SW ,'N' ,0 ,' ' ,%DateTimeNull FROM PS_ALTACCT_TBL G ,PS_ACCT_TYPE_TBL A WHERE A.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME = 'ACCT_TYPE_TBL' AND SETCNTRLVALUE = G.SETID) AND G.ACCOUNT_TYPE=A.ACCOUNT_TYPE AND G.EFFDT=( SELECT MAX(EFFDT) FROM PS_ALTACCT_TBL D WHERE D.SETID=G.SETID AND D.ALTACCT=G.ALTACCT AND D.EFFDT <= %CurrentDateIn)

# 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 Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: FEC_ACCT_TBL_VW
Set Control Field: SETID

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

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

5 ACCT_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Account Type Description

6 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

7 SELECT_ACT Character(1) VARCHAR2(1) NOT NULL Select

8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
Default Value: 0

9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

10 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: FEC_ACCT_TBL_VW Set Control Field: SETID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	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.
5	ACCT_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Account Type Description
6	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
7	SELECT_ACT	Character(1)	VARCHAR2(1) NOT NULL	Select
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance Default Value: 0
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.