BO_IDACCOUNT_NUMBERRBF_ACCT_SS_VW7(SQL View) |
Index Back |
|---|---|
Acct Number ViewThis view is used to populate the drop down for the account number field of the Change Account Nickname component |
| SELECT a.BUS_CONTACT_ID , b.FIN_ACCOUNT_ID , AD.ACCT_DESCR1 , AD.ACCT_DESCR2 , AD.ACCT_DESCR3 FROM PS_RBF_SRTY_MATRIX a , PS_RBF_FIN_ACCOUNT b , PS_RBF_ACCT_DSP_VW AD WHERE a.ACCOUNT_REF_ID = b.BO_ID AND a.SRTY_FUNCTION_CD IN ('ALL','PROF') AND a.APPROVAL_FLG = 'Y' AND FIN_ACCOUNT_STATUS = 'OPE' AND b.FIN_ACCOUNT_ID = AD.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 |
| 2 | ACCOUNT_NUMBER |
Character(20) | VARCHAR2(20) NOT NULL | Account number ---------> FSI Account |
| 3 | ACCT_DESCR1 | Character(51) | VARCHAR2(51) NOT NULL | Account Type and Account Number |
| 4 | ACCT_DESCR2 | Character(41) | VARCHAR2(41) NOT NULL | Account Nickname and Account Number |
| 5 | ACCT_DESCR3 | Character(71) | VARCHAR2(71) NOT NULL | Account Registration Name and Account Number |