SETIDCOMPANYIDACT=Active
CLOS=Closed
HOLD=On Hold
PEND=Pending Activation
IND=Individual Account
NSUB=Parent Account
PRE=Prepaid Account
SPNR=Sponsored Account
SPON=Sponsoring Account
SUB=Subordinate Account
RBT_COMACT_VW(SQL View) |
Index Back |
|---|---|
Company account ListThis view is used to display all the billing accounts for a company |
| SELECT COM.SETID , COM.COMPANYID ,RBTACCTID ,RBTACCTNO ,RBTACCTNAME ,RBTCUST_BO_ID ,RBTCONT_BO_ID ,BO_NAME_DISPLAY , RBTACCTSTATUS ,ACT.BO_ID ,RBTACCTTYPE FROM PS_RBT_ACCOUNT ACT , PS_RD_COMPANY COM , PS_BO_NAME NM WHERE ACT.RBTCUST_BO_ID = COM.BO_ID AND ACT.RBTCONT_BO_ID = NM.BO_ID AND PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | COMPANYID |
Character(15) | VARCHAR2(15) NOT NULL | Company ID |
| 3 | RBTACCTID | Character(15) | VARCHAR2(15) NOT NULL | Unique service account indentifier |
| 4 | RBTACCTNO | Character(20) | VARCHAR2(20) NOT NULL | Account No |
| 5 | RBTACCTNAME | Character(30) | VARCHAR2(30) NOT NULL | Account Name |
| 6 | RBTCUST_BO_ID | Number(31,0) | DECIMAL(31) NOT NULL | Customer BO ID |
| 7 | RBTCONT_BO_ID | Number(31,0) | DECIMAL(31) NOT NULL | Contact BO ID |
| 8 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 9 | RBTACCTSTATUS | Character(4) | VARCHAR2(4) NOT NULL |
Account Status
ACT=Active CLOS=Closed HOLD=On Hold PEND=Pending Activation |
| 10 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 11 | RBTACCTTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Determines the type of Billing Account.
IND=Individual Account NSUB=Parent Account PRE=Prepaid Account SPNR=Sponsored Account SPON=Sponsoring Account SUB=Subordinate Account |