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

SEC_ACCT_CT_RVW

(SQL View)

CFS: Account non-Control View

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

SELECT DISTINCT C.ROLEUSER , B.PRODSRCID , 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_ACCT_ROLE B , PSROLEUSER C WHERE %Join(COMMON_KEYS,GL_ACCOUNT_TBL A, GL_ACCOUNT_TBL B, EFFDT) AND C.ROLENAME = B.ROLENAME AND A.CONTROL_FLAG = 'N' AND A.BUDGETARY_ONLY = 'N'

Related Language Record: SEC_ACCT_RLANG

# 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 PRODSRCID Character(4) VARCHAR2(4) NOT NULL Chartfield Security: Source Product
DBI=Billing
DCM=Cost Management
DIN=Inventory
DMI=Mobile Inventory
DOM=Order Management
DPO=Purchasing
DPV=eProcurement
DSP=Service Procurement
FAM=Asset Management
FAP=Payables
FAR=Receivables
FCA=Contracts
FEX=Expenses
FGL=General Ledger
FGM=Grants Management
FPC=Project Costing
FTR=Treasury
KK=Commitment Control

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

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

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

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

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

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

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

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

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

12 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	PRODSRCID	Character(4)	VARCHAR2(4) NOT NULL	Chartfield Security: Source Product DBI=Billing DCM=Cost Management DIN=Inventory DMI=Mobile Inventory DOM=Order Management DPO=Purchasing DPV=eProcurement DSP=Service Procurement FAM=Asset Management FAP=Payables FAR=Receivables FCA=Contracts FEX=Expenses FGL=General Ledger FGM=Grants Management FPC=Project Costing FTR=Treasury KK=Commitment Control
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID
4	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
9	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.
10	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.
11	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.
12	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time Default Value: %datetime