RBTACCTIDBSCS=BSCS
DOX=AmDocs
KEN=Kenan
PRSF=Portal
RBF_BILLACCT_VW(SQL View) |
Index Back |
|---|---|
Billing account Search recordBilling account search record for address fields |
| SELECT A.RBTACCTID ,A.SYNCID ,A.RBTACCTNO ,A.RBTBILLSYSTEM ,A.RBTCUST_BO_ID ,C.CITY ,C.STATE ,C.POSTAL FROM PS_RBT_ACCOUNT A , PS_CM C WHERE A.CM_ID = C.CM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBTACCTID |
Character(15) | VARCHAR2(15) NOT NULL | Unique service account indentifier |
| 2 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 3 | RBTACCTNO | Character(20) | VARCHAR2(20) NOT NULL | Account No |
| 4 | RBTBILLSYSTEM | Character(4) | VARCHAR2(4) NOT NULL |
Billing System
BSCS=BSCS DOX=AmDocs KEN=Kenan PRSF=Portal |
| 5 | RBTCUST_BO_ID | Number(31,0) | DECIMAL(31) NOT NULL | Customer BO ID |
| 6 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 7 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 8 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |