RBF_ACCT_BO_VW (SQL View)	Index Back
Displays accounts This view is used to display accounts for a BO

RBF_ACCT_BO_VW

(SQL View)

Displays accounts

This view is used to display accounts for a BO

SELECT DISTINCT FA.CUST_ACCT_NBR , SM.BUS_CONTACT_ID ,FA.CUST_ACCT_NBR FROM PS_RBF_FIN_ACCOUNT FA , PS_RBF_SRTY_MATRIX SM WHERE FA.BO_ID = SM.ACCOUNT_REF_ID AND SM.APPROVAL_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number

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

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	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
2	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
3	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account