Overview | Core Database Schema | All Tables All Columns

Table: RECURRING_RATE

Table Name RECURRING_RATE
Table Description The RECURRING_RATE table contains information about recurring rates.
Tablespace CATALOG_DATA
Database Core Database
Columns
OID
INDEX_IN_PLAN
NAME
DESCRIPTION
PROPAGATED_EVENT
FREQUENCY
PREPAID
PRORATABLE
TIME_UNIT
ROUNDING_STEP
ROUNDING_MODE
FRACTION
PREPAID_PERIOD
BIRTHDAY_PROP_NAME
PLAN_OID
SPLIT_REFUND

Columns of the Table

The RECURRING_RATE database table is defined by the following columns.

Column: OID

Value Type BIGINT, NOT NULL
Key(s) Primary Key: PK_RECURRING_RATE

Foreign K.:

  • Foreign table: PRICE_PLAN
  • Foreign field(s): OID
Index(es) IX_RECURRING_RATE_PP
Column Description The recurring rate unique ID.


Column: INDEX_IN_PLAN

Value Type DECIMAL(5), NOT NULL
Column Description The position of the 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: PROPAGATED_EVENT

Value Type DECIMAL(1), NOT NULL
Column Description

The PROPAGATED_EVENT field indicates if the recurring rate is activated on propagated events.

Possible values:

  • 0: false
  • 1: true


Column: FREQUENCY

Value Type VARCHAR(256)
Column Description The recurring date for this recurring rate. It is represented by a string containing 7 values separated by /. These values represent: 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.


Column: PREPAID

Value Type DECIMAL(1), NOT NULL
Column Description

The PREPAID field indicates if the recurring rate is prepaid.

Possible values are:

  • 0: not prepaid
  • 1: prepaid


Column: PRORATABLE

Value Type DECIMAL(1), NOT NULL
Column Description

The PRORATABLE field indicates if the recurring rate can be prorated.

Possible values are:

  • 0: can not be prorated
  • 1: can be prorated


Column: TIME_UNIT

Value Type DECIMAL(1)
Column Description

The time unit used for prorating.

Possible values are:

  • 0: seconds
  • 1: minutes
  • 2: hours
  • 3: days


Column: ROUNDING_STEP

Value Type DECIMAL(28,6)
Column Description The maximum roundoff error when prorating.


Column: ROUNDING_MODE

Value Type DECIMAL(1)
Column Description

The rounding mode when prorating.

Possible values are:

  • 0: round up
  • 1: round down
  • 2: round to the nearest


Column: FRACTION

Value Type DECIMAL(28,6)
Column Description The fraction for the pro rata.


Column: PREPAID_PERIOD

Value Type DECIMAL(3)
Column Description The number of prepaid periods.


Column: BIRTHDAY_PROP_NAME

Value Type VARCHAR(256)
Column Description The name of the property used as birthday property.


Column: PLAN_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

  • Foreign table: PRICE_PLAN
  • Foreign field(s): OID
Index(es) IX_RECURRING_RATE_PP
Column Description The ID of price plan for the rate component.


Column: SPLIT_REFUND

Value Type DECIMAL(1), NOT NULL
Default Value 0
Column Description

The SPLIT_REFUND field indicates if the recurring rate can be prorated with a split refund.

Possible values are:

  • 0: can not be prorated with a split refund
  • 1: can be prorated with a split refund


Top of the list


SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.