RDFCOMP_ACCT_VW (SQL View)	Index Back
FSI Company accounts tab All accounts owned by the company is displayed in this record

RDFCOMP_ACCT_VW

(SQL View)

FSI Company accounts tab

All accounts owned by the company is displayed in this record

SELECT c.SETID , c.COMPANYID , a.FIN_ACCOUNT_ID ,a.CUST_ACCT_NBR , a.FIN_ACCOUNT_TYPE , a.FIN_ACCT_NICKNAME , a.FIN_ACCOUNT_STATUS , a.SYNCID , a.SYNCDTTM FROM PS_RD_COMPANY c , PS_RBF_FIN_ACCOUNT a WHERE c.BO_ID = a.BO_ID_OWNER

# 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 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID

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

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

5 FIN_ACCOUNT_TYPE Character(3) VARCHAR2(3) NOT NULL Account type
CHK=Checking
CRE=Credit
INV=Investment
LON=Loan
POL=Insurance
SAV=Savings

6 FIN_ACCT_NICKNAME Character(20) VARCHAR2(20) NOT NULL Accoutn nickname -------->FSI Account

7 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

8 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

9 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	COMPANYID	Character(15)	VARCHAR2(15) NOT NULL	Company ID
3	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
4	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account
5	FIN_ACCOUNT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Account type CHK=Checking CRE=Credit INV=Investment LON=Loan POL=Insurance SAV=Savings
6	FIN_ACCT_NICKNAME	Character(20)	VARCHAR2(20) NOT NULL	Accoutn nickname -------->FSI Account
7	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
8	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
9	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time