RCF_BILL_AC_VW2(SQL View) |
Index Back |
---|---|
CUST_ACCT_NBR Issue search vwIssue 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 |