RBT_ACCOUNT

(SQL Table)
 Index Back

Main Record for Telco Acct

Main record to store information about service accounts.

  • Parent Record Of RBE_ACT_STE_VW

  • Audit Record: AUDIT_RBT_ACCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

    Default Value: NEXT

    2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    3 RBTBILLSYSACCTID Character(15) VARCHAR2(15) NOT NULL Billing System Account Id
    4 RBTBILLSYSTEM Character(4) VARCHAR2(4) NOT NULL Billing System
    BSCS=BSCS
    DOX=AmDocs
    KEN=Kenan
    PRSF=Portal
    5 RBTPARENTACCTID Character(15) VARCHAR2(15) NOT NULL Parent Account Id

    Prompt Table: RBT_PAR_ACT_VW2

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

    Prompt Table: RBT_SPO_ACT_VW2

    7 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    8 RBTCUST_BO_ID Number(31,0) DECIMAL(31) NOT NULL Customer BO ID

    Prompt Table: BO

    9 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    10 RBTCONT_BO_ID Number(31,0) DECIMAL(31) NOT NULL Contact BO ID

    Prompt Table: BO

    11 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    12 RBTACCTNO Character(20) VARCHAR2(20) NOT NULL Account No
    13 RBTACCTNAME Character(30) VARCHAR2(30) NOT NULL Account Name
    14 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
    15 RBTACCTSTATUS Character(4) VARCHAR2(4) NOT NULL Account Status
    ACT=Active
    CLOS=Closed
    HOLD=On Hold
    PEND=Pending Activation

    Default Value: PEND

    16 RBTLASTBILLID Character(15) VARCHAR2(15) NOT NULL Last Bill Id
    17 RBTLASTBILLDT Date(10) DATE Last Bill Date
    18 RBTCURRBILLID Character(15) VARCHAR2(15) NOT NULL Current Bill Id
    19 RBTCURRBILLDT Date(10) DATE Current Bill Date
    20 RBTCURRBILLSTDT Date(10) DATE Current Bill Start Date
    21 RBTCURRBILLENDDT Date(10) DATE Current Bill End Date
    22 RBTNEXTBILLDT Date(10) DATE Service Billing - Next Bills date
    23 RBTNEXTBILLSTDT Date(10) DATE Service Billing - Next Bills Start date
    24 RBTNEXTBILLENDDT Date(10) DATE Service Billing - Next Bills End date
    25 RBTBILLCYCLE Character(4) VARCHAR2(4) NOT NULL Bill Cycle
    MON=Monthly
    QUAT=Quarterly
    26 RBTBILLDAY Character(4) VARCHAR2(4) NOT NULL Bill Day
    1=01
    10=10
    11=11
    12=12
    13=13
    14=14
    15=15
    16=16
    17=17
    18=18
    19=19
    2=02
    20=20
    21=21
    22=23
    23=23
    24=24
    25=25
    26=26
    27=27
    28=28
    3=03
    4=04
    5=05
    6=06
    7=07
    8=08
    9=09
    27 RBTDELMETHOD Character(4) VARCHAR2(4) NOT NULL Delivery Method
    ELEC=Electronic
    MAIL=Mail Delivery
    NONE=None
    28 RBTACCESSQUESTION Character(4) VARCHAR2(4) NOT NULL Access Question
    MOTH=Mother's Maiden Name
    PET=Pet's Name
    SPRT=Favorite Sport
    TVSH=Favorite TV Show
    29 RBTANSWER Character(40) VARCHAR2(40) NOT NULL Answer
    30 RBTPAYMETHOD Character(4) VARCHAR2(4) NOT NULL Different types of payment methods for billing accounts.
    AUTO=Automatic Payment
    BANK=Bank Draft
    CC=Credit Card
    INV=Invoice
    VOUC=Voucher

    Default Value: INV

    31 RBTBANKNAME Character(40) VARCHAR2(40) NOT NULL Bank Name
    32 RBTBANKACCNO Character(15) VARCHAR2(15) NOT NULL Bank Account No
    33 RBTROUTINGNO Character(20) VARCHAR2(20) NOT NULL Routing Number
    34 RBTSERIALNO Character(40) VARCHAR2(40) NOT NULL Serial Number
    35 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM
    36 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL "See OM
    01=Visa
    02=MasterCard
    03=Diners Club/Carte Blanche
    04=AMEX
    05=Discover
    06=EnRoute

    Prompt Table: EOEC_CCI_TP_VW
    Set Control Field: EOEC_CCI_TYPE

    37 CR_CARD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold Credit Card Status. Valid Values 1. Active 2. Inactive
    A=Active
    I=Inactive

    Default Value: A

    38 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
    39 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
    40 CR_NAME_APPEARS Character(80) VARCHAR2(80) NOT NULL Hold Credit Card Name as it appears in the Card
    41 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    42 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
    43 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
    44 CR_CARD_AUTH Character(44) VARCHAR2(44) NOT NULL Holds Credit Card Authorization Number. Few credit cards have some extra numbers, which is required for authoization.
    45 CC_PROF_TOKEN Character(44) VARCHAR2(44) NOT NULL Profile Token ID
    46 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Vendor name for credit card processing

    Prompt Table: EOEC_CCI_INSTAL

    47 RBTSTDATE Date(10) DATE Start Date
    48 RBTENDDATE Date(10) DATE End Date
    49 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
    50 RBT_PAYMENT_TYPE Character(4) VARCHAR2(4) NOT NULL Payment Type for Pre-Paid Account. Can be recurring or one time.
    MONT=Recurring Monthly Top-Up
    ONE=One Time Payment
    THRE=Recurring Threshold Top-Up
    VOUC=Voucher

    Default Value: VOUC

    51 RBT_RELATED_ACCT Character(15) VARCHAR2(15) NOT NULL Field to hold the related account - this could be the pre-paid account or post paid account. Depending on reference.
    52 RBT_THRESHOLD Number(3,0) SMALLINT NOT NULL Field to hold top-up threshold for prepaid phones for the business unit.

    Default Value: 0

    53 RBT_SECURITY Character(50) VARCHAR2(50) NOT NULL Field to hold the default security question for the business unit.
    54 RBT_ACTIVATE_CD Character(24) VARCHAR2(24) NOT NULL Activation code for Activating a phone through Service Management.
    55 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    56 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    57 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    58 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    59 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    60 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    61 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    62 DESCRLONG Long Character CLOB Long Description