RCF_BILL_AC_VW2

(SQL View)
Index Back

CUST_ACCT_NBR Issue search vw

Issue search view for CUST_ACCT_NBR

SELECT A.RBTCUST_BO_ID , A.RBTACCTID , A.RBTACCTNO , A.RBTACCTNAME FROM PS_RBT_ACCOUNT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
2 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
3 RBTACCTNO Character(20) VARCHAR2(20) NOT NULL Account No
4 RBTACCTNAME Character(30) VARCHAR2(30) NOT NULL Account Name