RBT_CUSTACCT_VW

(SQL View)
Index Back

Telco Account Prompt

Account Prompt for Talco Field Service.

SELECT A.RBTCUST_BO_ID , A.RBTACCTID , B.BO_NAME , A.RBTPARENTACCTID , A.RBTSPONSOREDACCTID , A.RBTACCTNO , A.RBTACCTNAME , A.RBTACCTTYPE , A.RBTACCTSTATUS FROM PS_RBT_ACCOUNT A , PS_BO B WHERE A.RBTCUST_BO_ID = B.BO_ID(+)

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

Prompt Table: RBT_ACCOUNT
Set Control Field: RBTACCTID

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

Prompt Table: RBT_ACCOUNT
Set Control Field: RBTACCTID

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