RBF_CUST_VW_LNG

(SQL View)
 Index Back

View to display customer acct

Related Language View to display customer account

SELECT DISTINCT a.BUS_CONTACT_ID ,b.FIN_ACCOUNT_ID ,b.FIN_ACCOUNT_TYPE ,c.LANGUAGE_CD ,C.DESCR FROM PS_RBF_SRTY_MATRIX a , PS_RBF_FIN_ACCOUNT b , PS_PROD_ITEM_LNG C WHERE a.ACCOUNT_REF_ID = b.BO_ID AND b.PROD_SETID = C.SETID AND b.PRODUCT_ID = C.PRODUCT_ID AND b.FIN_ACCOUNT_TYPE <> 'POL'

  • Related Language Record for RBF_CUSTACT_VW1 RBF_CUST_ACT_VW

    • # 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 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
    3 FIN_ACCOUNT_TYPE Character(3) VARCHAR2(3) NOT NULL Account type
    CHK=Checking
    CRE=Credit
    INV=Investment
    LON=Loan
    POL=Insurance
    SAV=Savings
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description