RDM_FIN_ACCT_VW(SQL View) |
Index Back |
|---|---|
rep accounts tabThis tab represents all accounts for a contact |
| SELECT DISTINCT p.PERSON_ID , a.FIN_ACCOUNT_ID ,a.CUST_ACCT_NBR , a.BO_ID_OWNER , b.BO_NAME , a.OWNER_BO_TYPE , a.FIN_ACCOUNT_TYPE , a.FIN_ACCT_NICKNAME , a.FIN_ACCOUNT_STATUS , a.SYNCID , a.SYNCDTTM FROM PS_RD_PERSON p , PS_RBF_SRTY_MATRIX s , PS_RBF_FIN_ACCOUNT a , PS_RBF_BO_NAME_VW b WHERE p.BO_ID = s.BUS_CONTACT_ID AND s.ACCOUNT_REF_ID = a.BO_ID AND a.BO_ID_OWNER = b.BO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person 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 | BO_ID_OWNER | Number(31,0) | DECIMAL(31) NOT NULL |
Financial Account Business Object ID
Prompt Table: RBF_BO_NAME_VW |
| 5 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | OWNER_BO_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
owner of the bo type
ALT=Alternate Capacity COM=Company PAR=Partnership PER=Person |
| 7 | FIN_ACCOUNT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Account type
CHK=Checking CRE=Credit INV=Investment LON=Loan POL=Insurance SAV=Savings |
| 8 | FIN_ACCT_NICKNAME | Character(20) | VARCHAR2(20) NOT NULL | Accoutn nickname -------->FSI Account |
| 9 | 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 |
| 10 | 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. |
| 11 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |