ACCOUNT_EVENT_RATE
Definition
The ACCOUNT_EVENT_RATE table contains information about account event refill components
Technical Data
Summary
The ACCOUNT_EVENT_RATE table is defined by the
following columns.
See the column details for more information.
Column Details
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 which triggered the account event refill |
| Type |
NVARCHAR(256), NOT NULL |
PLAN_OID
| Definition |
The unique identifier of the refill plan which 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
PK_ACCOUNT_EVENT_RATE
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 |
| Clustered |
No |
| Filegroup |
CATALOG_INDX |
