RECURRING_RATE
Definition
The RECURRING_RATE table contains information about recurring rates
Technical Data
| Schema Version |
4.5.13 |
| Tablespace |
CATALOG_DATA |
| Partitioned |
No |
Summary
The RECURRING_RATE table is defined by the
following columns.
See the column details for more information.
Column Details
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 |
VARCHAR2(256 CHAR), NOT NULL |
DESCRIPTION
| Definition |
The description of the rate |
| Type |
VARCHAR2(2000 CHAR), 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:
- the type of the recurring date (daily, weekly, and so on)
- the day of the week for a weekly recurring date
- the day of the month for a monthly recurring date
- the month
- the hour and the minute for this recurring date
- the number of periods of this type
|
| Type |
VARCHAR2(256 CHAR), NULL |
PREPAID
| Definition |
The PREPAID field indicates if the recurring rate is prepaid |
| Format |
The possible values are:
0: Not prepaid
1: prepaid
|
| Type |
DECIMAL(1), NOT NULL |
PRORATABLE
| Definition |
The PRORATABLE field indicates if the recurring rate can be prorated |
| Format |
The possible values are:
0: Cannot be prorated
1: Can be prorated
|
| Type |
DECIMAL(1), NOT NULL |
TIME_UNIT
| Definition |
The time unit used for prorating |
| Format |
The possible values are:
0: Seconds
1: minutes
2: hours
3: days
|
| 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:
0: round up
1: round down
2: round to the nearest
|
| 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 |
VARCHAR2(256 CHAR), 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:
0: Cannot be prorated with a split refund
1: Can be prorated with a split refund
|
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
Primary Key Details
PK_RECURRING_RATE
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 |
| Tablespace |
CATALOG_INDX |
