The COUNTER table contains all the counters configured in subscriptions, charging
contracts and charge activation objects.
These counters are first declared in offers and charge conditions (of offers),
or in charge plans (see CAPA_COUNTER) and
charges customized in charge plans (see CAPI_COUNTER).
Then they are initialized in a subscription or in a charge activation.
Note
Consider the following tables that can include shared or pooled counters:
| Schema Version | 5.0.6 | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The COUNTER 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 |
|---|---|---|---|---|---|---|
| COUN_KEY | PK_COUNTER |
|
The internal identification key of the counter | |||
| VALUE |
|
The numerical value of the counter | ||||
| SUAC_OID | PK_COUNTER | SUBSCRIBER_ACCOUNT (OID)
|
|
The identifier of the subscriber account holding the subscription, the charging contract, or the charge activation | ||
| HOLD_OID | PK_COUNTER |
|
The identifier of the holder of the numerical counter | |||
| PARTITION_ID | PK_COUNTER |
|
The partition of the subscriber account holding the subscription, the charging contract, or the charge activation |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The internal identification key of the counter |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_COUNTER |
| Definition | The numerical value of the counter |
| Description |
The numerical value of the counter. Note It is rounded according to the configuration set with the COUNTER_PRECISION and the
COUNTER_ROUNDING_MODE parameters of the SAP CC system.
|
| Type | DECIMAL(28,6), NULL |
| Definition | The identifier of the subscriber account holding the subscription, the charging contract, or the charge activation |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_COUNTER |
| Definition | The identifier of the holder of the numerical counter |
| Format |
The possible values are:
|
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_COUNTER |
| Definition | The partition of the subscriber account holding the subscription, the charging contract, or the charge activation |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_COUNTER |
See the primary key information:
| Column(s) | PARTITION_ID,SUAC_OID,HOLD_OID,COUN_KEY |
| Segment | COUNTER_INDX |
