RBF_MOD_ACCT_VW (SQL View)	Index Back
Acct Number View for Transfer This view is used to populate the drop down for the from account number field of the Transfer Fund component as well as automatic funds transfer setup component.

RBF_MOD_ACCT_VW

(SQL View)

Acct Number View for Transfer

This view is used to populate the drop down for the from account number field of the Transfer Fund component as well as automatic funds transfer setup component.

SELECT DISTINCT BUS_CONTACT_ID , FIN_ACCOUNT_ID ,b.CUST_ACCT_NBR FROM PS_RBF_SRTY_MATRIX a , PS_RBF_FIN_ACCOUNT b WHERE a.ACCOUNT_REF_ID = b.BO_ID AND a.SRTY_FUNCTION_CD IN ('ALL','MDAC') AND a.APPROVAL_FLG = 'Y' AND FIN_ACCOUNT_STATUS = 'OPE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 ACCOUNT_NUMBER Character(20) VARCHAR2(20) NOT NULL Account number ---------> FSI Account

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	ACCOUNT_NUMBER	Character(20)	VARCHAR2(20) NOT NULL	Account number ---------> FSI Account
3	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account