RBTCUST_BO_IDRBTCONT_BO_IDRBTACCTIDRBT_BACT_V12(SQL View) |
Index Back |
|---|---|
Billing Account/Person ViewThis view is used to derive all the persons related to an account |
| SELECT BACT.RBTCUST_BO_ID ,PERS.BO_ID RBTCONT_BO_ID ,BACT.RBTACCTID ,BACT.RBTACCTNAME ,BACT.RBTACCTNO FROM PS_RBT_ACCOUNT BACT , PS_BO_REL REL , PS_RD_PERSON PERS WHERE REL.BO_ID_2 = BACT.BO_ID AND REL.BO_ID_1 = PERS.BO_ID AND REL.REL_TYPE_ID IN ( 535,536) AND REL.START_DT <= %CurrentDateIn AND REL.END_DT > %CurrentDateIn AND BACT.RBTACCTSTATUS = 'ACT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBTCUST_BO_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Customer BO ID |
| 2 | RBTCONT_BO_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Contact BO ID |
| 3 | RBTACCTID |
Character(15) | VARCHAR2(15) NOT NULL | Unique service account indentifier |
| 4 | RBTACCTNAME | Character(30) | VARCHAR2(30) NOT NULL | Account Name |
| 5 | RBTACCTNO | Character(20) | VARCHAR2(20) NOT NULL | Account No |