RBTCUST_BO_IDPrompt Table: BO
RBTCONT_BO_IDPrompt Table: BO
RBTACCTNOACT=Active
CLOS=Closed
HOLD=On Hold
PEND=Pending Activation
Default Value: NEXT
RBT_PER_ACCT_VW(SQL View) |
Index Back |
|---|---|
My Accounts ViewThis is the account and person realtionship view |
| SELECT ACCT.RBTCUST_BO_ID ,ACCT.RBTCONT_BO_ID , ACCT.RBTACCTNO ,ACCT.RBTACCTNAME ,ACCT.RBTACCTSTATUS ,ACCT.RBTACCTID ,ACCT.ROLE_TYPE_ID_CUST ,ACCT.ROLE_TYPE_ID_CNTCT FROM PS_RBT_ACCOUNT ACCT WHERE ACCT.RBTACCTSTATUS='ACT' AND RBTACCTNO <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBTCUST_BO_ID |
Number(31,0) | DECIMAL(31) NOT NULL |
Customer BO ID
Prompt Table: BO |
| 2 | RBTCONT_BO_ID |
Number(31,0) | DECIMAL(31) NOT NULL |
Contact BO ID
Prompt Table: BO |
| 3 | RBTACCTNO |
Character(20) | VARCHAR2(20) NOT NULL | Account No |
| 4 | RBTACCTNAME | Character(30) | VARCHAR2(30) NOT NULL | Account Name |
| 5 | RBTACCTSTATUS | Character(4) | VARCHAR2(4) NOT NULL |
Account Status
ACT=Active CLOS=Closed HOLD=On Hold PEND=Pending Activation |
| 6 | RBTACCTID | Character(15) | VARCHAR2(15) NOT NULL |
Unique service account indentifier
Default Value: NEXT |
| 7 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 8 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |