RCF_CUST_AC_VW (SQL View)	Index Back
Financial Account View This view is used to prompt for Financial accounts from case search.

RCF_CUST_AC_VW

(SQL View)

Financial Account View

This view is used to prompt for Financial accounts from case search.

SELECT B.SETID , A.CUST_ACCT_NBR , A.REGISTRATION_NAME , %Substring(C.BO_NAME_DISPLAY,1,50) FROM PS_RBF_FIN_ACCOUNT A , PS_BC B , PS_BO_NAME C WHERE A.BO_ID_OWNER = B.BO_ID AND B.BO_ID = C.BO_ID AND C.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 CUST_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL This is the Customer defined Account Number for a financial account

3 REGISTRATION_NAME Character(50) VARCHAR2(50) NOT NULL Registration Name --------> FSI Account

4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account
3	REGISTRATION_NAME	Character(50)	VARCHAR2(50) NOT NULL	Registration Name --------> FSI Account
4	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object