RBF_PSH_ACCT_VW

(SQL View)
 Index Back

Partnership accounts tab

all financial accounts owned by the partnership.

SELECT p.PARTNERSHIP_ID , a.FIN_ACCOUNT_ID ,a.CUST_ACCT_NBR , a.FIN_ACCOUNT_TYPE , a.FIN_ACCT_NICKNAME , a.FIN_ACCOUNT_STATUS FROM PS_RBF_PARTSHP p , PS_RBF_FIN_ACCOUNT a WHERE p.BO_ID = a.BO_ID_OWNER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PARTNERSHIP_ID Character(15) VARCHAR2(15) NOT NULL partnership id
2 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
3 CUST_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL This is the Customer defined Account Number for a financial account
4 FIN_ACCOUNT_TYPE Character(3) VARCHAR2(3) NOT NULL Account type
CHK=Checking
CRE=Credit
INV=Investment
LON=Loan
POL=Insurance
SAV=Savings
5 FIN_ACCT_NICKNAME Character(20) VARCHAR2(20) NOT NULL Accoutn nickname -------->FSI Account
6 FIN_ACCOUNT_STATUS Character(3) VARCHAR2(3) NOT NULL Financial account status
CLO=Closed
HLD=Hold
INA=Inactive
OPE=Open
PC=Pending Close
PO=Pending Open