RBF_CUST_ACT_V1

(SQL View)
 Index Back

View to display customer acct

View to display customer account list ........................

SELECT DISTINCT b.FIN_ACCOUNT_ID ,b.BO_ID_OWNER ,b.CUST_ACCT_NBR ,b.FIN_ACCOUNT_TYPE ,C.DESCR ,b.LAST_REFRESH_DTTM ,b.END_DATE ,b.CURRENCY_CD , 1 ,b.BO_ID_PARTNER ,b.ROLE_TYPE_ID_PART ,b.BO_ID_PART_CONT ,b.ROLE_TYPE_ID_PARTC FROM PS_RBF_FIN_ACCOUNT b , PS_PROD_ITEM C WHERE b.PROD_SETID = C.SETID AND b.PRODUCT_ID = C.PRODUCT_ID AND b.FIN_ACCOUNT_TYPE <> 'POL'

  • Related Language Record: RBF_CUST_ACT_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
    2 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
    3 CUST_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL This is the Customer defined Account Number for a financial account
    4 FIN_ACCOUNT_TYPE Character(3) VARCHAR2(3) NOT NULL Account type
    CHK=Checking
    CRE=Credit
    INV=Investment
    LON=Loan
    POL=Insurance
    SAV=Savings
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 LAST_REFRESH_DTTM DateTime(26) TIMESTAMP last refresh datetime
    7 END_DATE Date(10) DATE End date field to store an end date.
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
    9 ATM_CARD_COUNT Number(12,0) DECIMAL(12) NOT NULL Number of ATM Cards
    10 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
    11 ROLE_TYPE_ID_PART Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner
    12 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.
    13 ROLE_TYPE_ID_PARTC Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner contact