FEC_ACCOUNT_TBL (SQL Table)	Index Back
FEC ACCOUNT TABLE

FEC_ACCOUNT_TBL

(SQL Table)

FEC ACCOUNT TABLE

Related Language Record: FEC_ACT_LAN_TBL

Parent record: FEC_SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

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
Y/N Table Edit

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
2	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
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 Y/N Table Edit
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.