RBT_CUSREPAC_VW

(SQL View)
Index Back

Telco Account Prompt

Telco Account Prompt View for Existing Accounts

SELECT A.RBTCUST_BO_ID , A.RBTCONT_BO_ID , A.RBTACCTID , B.BO_NAME , C.BO_NAME , A.RBTPARENTACCTID , A.RBTSPONSOREDACCTID , A.RBTACCTNO , A.RBTACCTNAME , A.RBTACCTTYPE , A.RBTACCTSTATUS FROM PS_RBT_ACCOUNT A , PS_BO B , PS_BO C WHERE A.RBTCUST_BO_ID = B.BO_ID(+) AND A.RBTCONT_BO_ID = C.BO_ID(+) AND A.RBTACCTSTATUS = 'ACT' AND A.RBTACCTTYPE <> 'PRE'

# 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 RBTPARENTACCTID Character(15) VARCHAR2(15) NOT NULL Parent Account Id

Prompt Table: RBT_ACCOUNT
Set Control Field: RBTACCTID

7 RBTSPONSOREDACCTID Character(15) VARCHAR2(15) NOT NULL Sponsored Account Id

Prompt Table: RBT_ACCOUNT
Set Control Field: RBTACCTID

8 RBTACCTNO Character(20) VARCHAR2(20) NOT NULL Account No
9 RBTACCTNAME Character(30) VARCHAR2(30) NOT NULL Account Name
10 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
11 RBTACCTSTATUS Character(4) VARCHAR2(4) NOT NULL Account Status
ACT=Active
CLOS=Closed
HOLD=On Hold
PEND=Pending Activation