EX_ALTACCT_VW (SQL View)	Index Back
AltAcct Control View This view is used for prompting on selected panels. It filters out ALTACCT values where the Control Flag = 'Y'

EX_ALTACCT_VW

(SQL View)

AltAcct Control View

This view is used for prompting on selected panels. It filters out ALTACCT values where the Control Flag = 'Y'

SELECT SETID , ALTACCT , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , ACCOUNT_TYPE , CONTROL_FLAG , SYNCID , SYNCDTTM FROM PS_ALTACCT_TBL WHERE CONTROL_FLAG = 'N'

Related Language Record: EX_ALTACCT_L_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ALTACCT_SETID Character(5) VARCHAR2(5) NOT NULL Alternate Account SetID
Default Value: OPR_DEF_TBL_FS.SETID

2 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

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

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

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

8 CONTROL_FLAG Character(1) VARCHAR2(1) NOT NULL This flag in used to desginate an Account or Alternate Account as Control Accounts and Control Alternate Accounts, respectively.

9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
Default Value: %datetime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ALTACCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Alternate Account SetID Default Value: OPR_DEF_TBL_FS.SETID
2	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	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.
8	CONTROL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This flag in used to desginate an Account or Alternate Account as Control Accounts and Control Alternate Accounts, respectively.
9	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
10	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time Default Value: %datetime