RBT_BACT_V2

(SQL View)
 Index Back

Billing Account/Person View

This view is used to derive all the persons related to an account

SELECT PERS.BO_ID ,BACT.RBTACCTID ,BACT.RBTACCTNAME ,BACT.RBTACCTNO FROM PS_RBT_ACCOUNT BACT , PS_BO_REL REL , PS_RD_PERSON PERS ,PS_BO_NAME BON ,PS_BO_NAME NM WHERE REL.BO_ID_2 = BACT.BO_ID AND REL.BO_ID_1 = PERS.BO_ID AND PERS.BO_ID = BON.BO_ID AND BON.PRIMARY_IND = 'Y' AND BACT.RBTCUST_BO_ID = NM.BO_ID AND NM.PRIMARY_IND = 'Y' AND REL.REL_TYPE_ID IN ( 535,536) AND REL.START_DT <= %CurrentDateIn AND REL.END_DT > %CurrentDateIn AND BACT.RBTCUST_BO_ID = BACT.RBTCONT_BO_ID 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 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
3 RBTACCTNAME Character(30) VARCHAR2(30) NOT NULL Account Name
4 RBTACCTNO Character(20) VARCHAR2(20) NOT NULL Account No