RBF_ACCT_DSP_VW

(SQL View)
 Index Back

Account Display View

This view is used to display all the financial accounts.

SELECT FA.FIN_ACCOUNT_ID , %TrimSubstr(XL.XLATLONGNAME, 1, 30) %Concat ' ' %Concat FA.CUST_ACCT_NBR , %TrimSubstr(FA.FIN_ACCT_NICKNAME, 1, 20) %Concat ' ' %Concat FA.CUST_ACCT_NBR , %TrimSubstr(FA.REGISTRATION_NAME, 1, 50) %Concat ' ' %Concat FA.CUST_ACCT_NBR FROM PS_RBF_FIN_ACCOUNT FA , PSXLATITEM XL WHERE XL.FIELDNAME = 'FIN_ACCOUNT_TYPE' AND FA.FIN_ACCOUNT_TYPE = XL.FIELDVALUE

  • Related Language Record: RBF_ACCT_DSPLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
    2 ACCT_DESCR1 Character(51) VARCHAR2(51) NOT NULL Account Type and Account Number
    3 ACCT_DESCR2 Character(41) VARCHAR2(41) NOT NULL Account Nickname and Account Number
    4 ACCT_DESCR3 Character(71) VARCHAR2(71) NOT NULL Account Registration Name and Account Number