The SUBSCRIBER_ACCOUNT table stores the subscriber account master data for
each end customer (subscriber) who uses a customer service from a service provider.
A subscriber account may include a set of:
A subscriber account represents a set of subscriptions belonging to a subscriber.
Important Note
The SAP CC system generates the PARTITION_ID. All the data objects associated to a
subscriber account have
the same database partition ID.
Note
Consider the customer data that belongs to a subscriber account:
| Schema Version | 5.0.6 | |
| Filegroup | SUBSCRIBER_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The SUBSCRIBER_ACCOUNT 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_SUBSCRIBER_ACCOUNT | IX_SUAC_OID |
|
The unique identifier of the subscriber account in the customer master data. It is generated by the SAP CC system. | ||
| CODE | IX_SUAC_CODE |
|
The identification code (or code name) of the subscriber account in the customer master data owned by a service provider | |||
| SUBSCRIBER |
|
The subscriber of the subscriber account | ||||
| SERVICE_PROVIDER | IX_SUAC_CODE | CATALOG_ENTRY (OWNER)
|
|
The technical and legible reference for the service provider and the service pricing catalog that handle the subscriber account. | ||
| DESCRIPTION |
|
The textual and understandable description for a subscriber account | ||||
| TAXATION_MODULE |
|
The tax system defined for the subscriber account | ||||
| TAX_CODE |
|
The code of the tax defined for the subscriber account | ||||
| TAXATION_MODE |
|
The taxation mode for the subscriber account | ||||
| TAX_DATA |
|
The TAX_DATA field includes additional information about taxes in a CSV string | ||||
| PREPAID_TAXATION_TYPE |
|
The prepaid balance taxation type | ||||
| PREPAID_TRANSAC_PARTITION_ID |
|
The partition ID for the prepaid transactions | ||||
| PARTITION_ID | IX_SUAC_CODE |
|
The partition ID of the subscriber account. It is generated by the SAP CC system to optimize data management and performances. |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the subscriber account in the customer master data. It is generated by the SAP CC system. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_SUBSCRIBER_ACCOUNT |
| Available Index | IX_SUAC_OID |
| Definition | The identification code (or code name) of the subscriber account in the customer master data owned by a service provider |
| Type | NVARCHAR(256), NOT NULL |
| Available Index | IX_SUAC_CODE |
| Definition | The subscriber of the subscriber account |
| Description |
The subscriber of the subscriber account. Generally, the end customer uses the services
from the service provider.
|
| Type | NVARCHAR(256), NOT NULL |
| Definition | The technical and legible reference for the service provider and the service pricing catalog that handle the subscriber account. | ||||||
| Description |
SERVICE_PROVIDER is a technical and legible reference that is crucial for the SAP Convergent Charging.
The system uses this key to group, associate woith, and ensure data consistency for:
The contracting service provider of the subscriber account. It is the codename of the service provider company that
offers the customer service and
that is the owner of all the data objects in master data:
|
||||||
| Type | NVARCHAR(256), NOT NULL | ||||||
| Available Index | IX_SUAC_CODE | ||||||
| Definition | The textual and understandable description for a subscriber account |
| Type | NVARCHAR(2000), NULL |
| Definition | The tax system defined for the subscriber account |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Default | 0 |
| Definition | The code of the tax defined for the subscriber account |
| Format |
The possible values are:
|
| Type | NVARCHAR(256), NOT NULL |
| Definition | The taxation mode for the subscriber account |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Default | 0 |
| Definition | The TAX_DATA field includes additional information about taxes in a CSV string |
| Description |
The TAX_DATA field includes additional information about taxes in a CSV string. This
information can be needed when using VAT or EZTax.
|
| Type | NVARCHAR(256), NULL |
| Definition | The prepaid balance taxation type |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Default | 0 |
| Definition | The partition ID for the prepaid transactions |
| Type | DECIMAL(3), NOT NULL |
| Default | -1 |
| Definition | The partition ID of the subscriber account. It is generated by the SAP CC system to optimize data management and performances. |
| Description |
The SAP CC system stores data in database partitions. Refer to the SAP CC Application Help for
more information about partitions in SAP Convergent Charging.
|
| Type | DECIMAL(4), NOT NULL |
| Available Index | IX_SUAC_CODE |
See the primary key information:
| Column(s) | PARTITION_ID,OID |
| Filegroup | SUBSCRIBER_DATA |
The following database indexes are available in the SUBSCRIBER_ACCOUNT database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
| Indexed Column(s) | PARTITION_ID,CODE,SERVICE_PROVIDER |
| Unique | Yes |
| Partitioned | No |
| Clustered | No |
| Filegroup | SUBSCRIBER_INDX |
| Indexed Column(s) | OID |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | SUBSCRIBER_INDX |
