RBT_PARACCT_VW (SQL View)	Index Back
Parent Accounts View Parent Accounts View used in Order Capture Account selections

RBT_PARACCT_VW

(SQL View)

Parent Accounts View

Parent Accounts View used in Order Capture Account selections

SELECT A.RBTCUST_BO_ID , A.RBTCONT_BO_ID , A.RBTACCTID , B.BO_NAME , C.BO_NAME , A.RBTACCTNO , A.RBTACCTNAME FROM PS_RBT_ACCOUNT A LEFT OUTER JOIN PS_BO B ON B.BO_ID = A.RBTCUST_BO_ID LEFT OUTER JOIN PS_BO C ON C.BO_ID = A.RBTCONT_BO_ID WHERE A.RBTACCTTYPE = 'NSUB' AND A.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 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 REP_NAME Character(50) VARCHAR2(50) NOT NULL Name

6 RBTACCTNO Character(20) VARCHAR2(20) NOT NULL Account No

7 RBTACCTNAME Character(30) VARCHAR2(30) NOT NULL Account Name

#	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	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	REP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	RBTACCTNO	Character(20)	VARCHAR2(20) NOT NULL	Account No
7	RBTACCTNAME	Character(30)	VARCHAR2(30) NOT NULL	Account Name