SP_AC_CNT_OPRVW (SQL View)	Index Back
Account non-Control View This view is used for prompting on selected pages, for non-controlled (control_flag=N) and non-budgetary-only (budgetary_only=N) accounts.

SP_AC_CNT_OPRVW

(SQL View)

Account non-Control View

This view is used for prompting on selected pages, for non-controlled (control_flag=N) and non-budgetary-only (budgetary_only=N) accounts.

SELECT C.OPRID , A.SETID , A.ACCOUNT , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.ACCOUNT_TYPE , A.CONTROL_FLAG , A.SYNCID , A.SYNCDTTM FROM PS_GL_ACCOUNT_TBL A , PS_SEC_SETID_OPR C WHERE A.SETID = C.SETID AND A.CONTROL_FLAG = 'N' AND A.BUDGETARY_ONLY = 'N'

Related Language Record: SP_ACCOUNT_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID

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

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

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

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

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

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID
3	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
8	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.
9	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.
10	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.
11	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time Default Value: %datetime