RBF_SRTM_ACT_VW(SQL View) |
Index Back |
---|---|
Security Matrix account ViewSecurity Matrix account View is used for display |
SELECT DISTINCT CUST_ACCT_NBR ,FIN_ACCOUNT_ID , FIN_ACCT_NICKNAME , FIN_ACCOUNT_TYPE , b.SYNCID FROM PS_RBF_FIN_ACCOUNT a , PS_RBF_SRTY_MATRIX b WHERE a.BO_ID = b.ACCOUNT_REF_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(20) | VARCHAR2(20) NOT NULL | This is the Customer defined Account Number for a financial account | |
2 | FIN_ACCOUNT_ID | Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
3 | FIN_ACCT_NICKNAME | Character(20) | VARCHAR2(20) NOT NULL | Accoutn nickname -------->FSI 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 | 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. |