COUNTER
Description
CAPA_COUNTERCAPI_COUNTER
Note
Consider the following tables that can include shared or pooled counters:
Technical Data
| Schema Version | 4.5.13 | |
| Tablespace | COUNTER_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
Summary
The COUNTER table is defined by the following columns. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by |
|---|---|---|---|---|---|
| COUN_KEY | PK_COUNTER | PREPAID_ACCOUNT (COUN_KEY)
CREDIT_LIMIT_BALANCE (COUN_KEY) |
|||
| VALUE | |||||
| SUAC_OID | PK_COUNTER | SUBSCRIBER_ACCOUNT (OID)
|
|||
| HOLD_OID | PK_COUNTER | ||||
| PARTITION_ID | PK_COUNTER |
Column Details
COUN_KEY
| Definition | The internal identification key of the counter |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_COUNTER |
VALUE
| 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 |
SUAC_OID
| 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 |
HOLD_OID
| Definition | The identifier of the holder of the numerical counter |
| Format |
The possible values are:
|
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_COUNTER |
PARTITION_ID
| 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 |
Primary Key Details
PK_COUNTER
| Column(s) | PARTITION_ID,SUAC_OID,HOLD_OID,COUN_KEY |
| Tablespace | COUNTER_INDX |