RBT_PROD_ITEM(SQL Table) |
Index Back |
|---|---|
Telco base object for CIProduct extension record for telco used in ci for product configuration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | RBTFEATURE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Service Feature Flag used in Product Model
N=Not a Feature of a Product Y=Feature of Product Default Value: N |
| 4 | RBTSERVICETYPE | Character(4) | VARCHAR2(4) NOT NULL |
Service Type Wireless/Wireline
MO=Wireless Number PH=Wire line Number |
| 5 | RBTPLAN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to mark product as plan or service required
N=No Plan Y=Plan Default Value: N |
| 6 | RBTSERVICE_ID | Character(18) | VARCHAR2(18) NOT NULL |
Service ID used in product model
Prompt Table: RBT_SERVICE_VW |
| 7 | RBT_SO_UNINSTALL | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate if the product needs a service order to unintall the product.
Default Value: N |
| 8 | RBT_UNINSTSERV_ID | Character(20) | VARCHAR2(20) NOT NULL |
Service ID
Prompt Table: RF_SERV_IPRD_VW |
| 9 | RBT_SIM_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Flag to capture if a SIM number is required.
N=N Y=Y Default Value: N |
| 10 | RBT_NBR_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Flag to capture if a Phone number is required.
N=N Y=Y Default Value: N |
| 11 | RBT_LINE_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Line Usage for the service - either data, fax, or voice.
D=Data Line F=Fax Line V=Voice Line |
| 12 | RBT_ACCOUNT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Field to indicate what billing account can be used with this service.
EI=Either PO=Postpaid Only PP=Prepaid Only Default Value: EI |
| 13 | INST_AS_SERVICE | Character(1) | VARCHAR2(1) NOT NULL |
Install as Service' flag used bu Product Definition page for defining new Multilevel Product Bundles
Y/N Table Edit Default Value: N |
| 14 | RBT_ACCOUNT_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Field used for storing Billing Account Selectable flag value
Y/N Table Edit |
| 15 | RBT_ACCOUNT_SBIL | Character(1) | VARCHAR2(1) NOT NULL |
Field used for storing Split Billing flag value
Y/N Table Edit |