RECURRING_RATE
Definition
The RECURRING_RATE table contains information about recurring rates
Technical Data
| Schema Version | 4.6.2 | |
| Partitioned | No | |
Summary
The RECURRING_RATE table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| OID | PK_RECURRING_RATE |
|
The recurring rate unique ID | |||
| INDEX_IN_PLAN |
|
The position of the rate in the price plan | ||||
| NAME |
|
The name of the rate | ||||
| DESCRIPTION |
|
The description of the rate | ||||
| PROPAGATED_EVENT |
|
The PROPAGATED_EVENT field indicates if the recurring rate is activated on propagated events | ||||
| FREQUENCY |
|
The recurring date for this recurring rate | ||||
| PREPAID |
|
The PREPAID field indicates if the recurring rate is prepaid | ||||
| PRORATABLE |
|
The PRORATABLE field indicates if the recurring rate can be prorated | ||||
| TIME_UNIT |
|
The time unit used for prorating | ||||
| ROUNDING_STEP |
|
The maximum roundoff error when prorating | ||||
| ROUNDING_MODE |
|
The rounding mode when prorating | ||||
| FRACTION |
|
The fraction for the pro rata | ||||
| PREPAID_PERIOD |
|
The number of prepaid periods | ||||
| BIRTHDAY_PROP_NAME |
|
The name of the property used as birthday property | ||||
| PLAN_OID | IX_RECURRING_RATE_PP | PRICE_PLAN (OID)
|
|
The ID of price plan for the rate component | ||
| SPLIT_REFUND |
|
The SPLIT_REFUND field indicates if the recurring rate can be prorated with a split refund |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
OID
| Definition | The recurring rate unique ID |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_RECURRING_RATE |
INDEX_IN_PLAN
| Definition | The position of the rate in the price plan |
| Type | DECIMAL(5), NOT NULL |
NAME
| Definition | The name of the rate |
| Type | NVARCHAR(256), NOT NULL |
DESCRIPTION
| Definition | The description of the rate |
| Type | NVARCHAR(2000), NULL |
PROPAGATED_EVENT
| Definition | The PROPAGATED_EVENT field indicates if the recurring rate is activated on propagated events |
| Format |
The possible values:
|
| Type | DECIMAL(1), NOT NULL |
FREQUENCY
| Definition | The recurring date for this recurring rate |
| Description | The recurring date for this recurring rate. It is represented by a string containing 7 values separated by /. |
| Format |
These values represent in order:
|
| Type | NVARCHAR(256), NULL |
PREPAID
| Definition | The PREPAID field indicates if the recurring rate is prepaid |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
PRORATABLE
| Definition | The PRORATABLE field indicates if the recurring rate can be prorated |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
TIME_UNIT
| Definition | The time unit used for prorating |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NULL |
ROUNDING_STEP
| Definition | The maximum roundoff error when prorating |
| Type | DECIMAL(28,6), NULL |
ROUNDING_MODE
| Definition | The rounding mode when prorating |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NULL |
FRACTION
| Definition | The fraction for the pro rata |
| Type | DECIMAL(28,6), NULL |
PREPAID_PERIOD
| Definition | The number of prepaid periods |
| Type | DECIMAL(3), NULL |
BIRTHDAY_PROP_NAME
| Definition | The name of the property used as birthday property |
| Type | NVARCHAR(256), NULL |
PLAN_OID
| Definition | The ID of price plan for the rate component |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_RECURRING_RATE_PP |
SPLIT_REFUND
| Definition | The SPLIT_REFUND field indicates if the recurring rate can be prorated with a split refund |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Default | 0 |
Primary Key Details
See the primary key information:
PK_RECURRING_RATE
| Column(s) | OID |
| Tablespace | CATALOG_INDX |
Index Details
The following database indexes are available in the RECURRING_RATE database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
IX_RECURRING_RATE_PP
| Indexed Column(s) | PLAN_OID |
| Unique | No |
| Partitioned | No |