RBF_ORTC_SS_VW (SQL View)	Index Back
Acct No View for Traveller Chk This view is used to populate the drop down for the from account number field of the Order Traveller Check component

RBF_ORTC_SS_VW

(SQL View)

Acct No View for Traveller Chk

This view is used to populate the drop down for the from account number field of the Order Traveller Check component

SELECT DISTINCT BUS_CONTACT_ID , FIN_ACCOUNT_ID ,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','ORTC') AND a.APPROVAL_FLG = 'Y' AND b.BILL_PAY_ENABLED = 'Y' AND b.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