Table:
USAGE_RATE
|
Table Name
|
USAGE_RATE |
| Table Description |
The USAGE_RATE table contains information about usage rates. |
| Tablespace |
CATALOG_DATA |
| Database |
Core Database |
|
Columns
|
|
Columns of the Table
The USAGE_RATE database table is defined by the following columns.
Column: OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
Primary Key: PK_USAGE_RATE |
Foreign K.:
- Foreign table: PRICE_PLAN
- Foreign field(s): OID
|
| Index(es) |
IX_USAGE_RATE_PP
|
| Column Description |
The usage rate unique identifier. |
Column: INDEX_IN_PLAN
| Value Type |
DECIMAL(5), NOT NULL |
|
| Column Description |
The position of the usage rate in the price plan. |
Column: NAME
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The name of the rate. |
Column: DESCRIPTION
| Value Type |
VARCHAR(2000) |
|
| Column Description |
The description of the rate. |
Column: DESCRIPTION_NAME
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The name of the chargeable item that is rated. |
Column: GUIDING_NAME
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The name used for the guiding of the chargeable item. |
Column: PRODUCT_CODE
| Value Type |
VARCHAR(256) |
|
| Column Description |
The product code for this rate. |
Column: PLAN_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: PRICE_PLAN
- Foreign field(s): OID
|
| Index(es) |
IX_USAGE_RATE_PP
|
| Column Description |
The ID of the price plan for the usage rate. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.