Table:
AMOUNT_ALERT
|
Table Name
|
AMOUNT_ALERT |
| Table Description |
The AMOUNT_ALERT table represents an amount alert in a subscriber account. |
| Tablespace |
SUBSCRIBER_DATA |
| Database |
Core Database |
|
Partitioned
|
Yes
|
|
Columns
|
|
Columns of the Table
The AMOUNT_ALERT database table is defined by the following columns.
Column: SUAC_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: SUBSCRIBER_ACCOUNT
- Foreign field(s): OID
|
| Index(es) |
IX_AMAL_SUAC
IX_AMAL_SUAC_G (unique) (oracle)
|
| Column Description |
The identifier of the subscriber account. |
Column: CODE
| Value Type |
VARCHAR(256), NOT NULL |
|
| Index(es) |
IX_AMAL_SUAC_G (unique) (oracle)
|
| Column Description |
The code of the alert. |
Column: AMOUNT
| Value Type |
DECIMAL(28,6), NOT NULL |
|
| Column Description |
The amount that triggers the alert. |
Column: BALANCE_TYPE
| Value Type |
DECIMAL(1), NOT NULL |
|
| Column Description |
The type of balance owning the alert. Possible values are:
- 1: balance of a prepaid account
- 2: credit limit balance
|
Column: BALANCE_CODE
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The code (and the name) of the balance owning the alert. |
Column: PARTITION_ID
| Value Type |
SMALLINT, NOT NULL |
|
| Column Description |
The partition of the subscriber account. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.