ACCOUNT_EVENT_RATE

Definition

The ACCOUNT_EVENT_RATE table contains information about account event refill components

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

The ACCOUNT_EVENT_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_ACCOUNT_EVENT_RATE					The unique identifier of each component
INDEX_IN_PLAN						The position of the component in the refill plan
NAME						The name of the component
DESCRIPTION						The description of the component
EVENT_NAME						The name of the external event that triggered the account event refill
PLAN_OID			IX_ACCOUNT_EVENT_RATE_PP	PRICE_PLAN (OID)		The unique identifier of the refill plan that contains the component
AMOUNT_THRESHOLD						The numeric value specified by users which represents the balance threshold under which the account event refill is immediately triggered
AMOUNT_THRESHOLD_PROPERTY						The name of a numeric property used as a balance threshold under which the account event refill must be immediately triggered

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

Definition	The unique identifier of each component
Type	DECIMAL(28), NOT NULL
Primary Key	PK_ACCOUNT_EVENT_RATE

INDEX_IN_PLAN

Definition	The position of the component in the refill plan
Type	DECIMAL(5), NOT NULL

NAME

Definition	The name of the component
Type	NVARCHAR(256), NOT NULL

DESCRIPTION

Definition	The description of the component
Type	NVARCHAR(2000), NULL

EVENT_NAME

Definition	The name of the external event that triggered the account event refill
Type	NVARCHAR(256), NOT NULL

PLAN_OID

Definition	The unique identifier of the refill plan that contains the component
Type	DECIMAL(28), NOT NULL
Available Index	IX_ACCOUNT_EVENT_RATE_PP

AMOUNT_THRESHOLD

Definition	The numeric value specified by users which represents the balance threshold under which the account event refill is immediately triggered
Type	DECIMAL(28,6), NULL

AMOUNT_THRESHOLD_PROPERTY

Definition	The name of a numeric property used as a balance threshold under which the account event refill must be immediately triggered
Type	NVARCHAR(256), NULL

Primary Key Details

See the primary key information:

PK_ACCOUNT_EVENT_RATE

Column(s)	OID
Tablespace	CATALOG_INDX

Index Details

The following database indexes are available in the ACCOUNT_EVENT_RATE database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_ACCOUNT_EVENT_RATE_PP

Indexed Column(s)	PLAN_OID
Unique	No
Partitioned	No