BO_IDPrompt Table: RBF_TCON_PER_VW
ACCOUNT_NUMBERPrompt Table: RBF_ACCT_CON_VW
RBF_CONFIG_VW(SQL View) |
Index Back |
|---|---|
Configuration table viewThis view is used for bill pay configuration |
| SELECT a.BO_ID , a.ACCOUNT_NUMBER ,FIN.CUST_ACCT_NBR , b.LAST_NAME ,b.FIRST_NAME FROM PS_RBF_PAYBILL_CON a , PS_RB_PRSN_P_NM_VW b , PS_RBF_FIN_ACCOUNT FIN WHERE a.BO_ID = b.BO_ID AND a.ACCOUNT_NUMBER = FIN.FIN_ACCOUNT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL |
Business Object ID
Prompt Table: RBF_TCON_PER_VW |
| 2 | ACCOUNT_NUMBER |
Character(20) | VARCHAR2(20) NOT NULL |
Account number ---------> FSI Account
Prompt Table: RBF_ACCT_CON_VW |
| 3 | CUST_ACCT_NBR | Character(20) | VARCHAR2(20) NOT NULL | This is the Customer defined Account Number for a financial account |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |