SUBSCRIBER_ACCOUNT
Definition
The SUBSCRIBER_ACCOUNT table stores the subscriber account in master data for each end customer (subscriber) who uses any services offered by a service provider
Description
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:
Technical Data
| Schema Version | 4.6.2 | |
| Filegroup | SUBSCRIBER_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
Summary
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 contracting service provider of the subscriber account. It is the codename of the service provider that offers the customer service and that is the owner of all the data objects in master data. | ||
| DESCRIPTION |
|
The comprehensive description of the 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. |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
OID
| 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 |
CODE
| 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 |
SUBSCRIBER
| 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 |
SERVICE_PROVIDER
| Definition | The contracting service provider of the subscriber account. It is the codename of the service provider that offers the customer service and that is the owner of all the data objects in master data. |
| Description |
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 |
DESCRIPTION
| Definition | The comprehensive description of the subscriber account |
| Type | NVARCHAR(2000), NULL |
TAXATION_MODULE
| Definition | The tax system defined for the subscriber account |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Default | 0 |
TAX_CODE
| Definition | The code of the tax defined for the subscriber account |
| Format |
The possible values are:
|
| Type | NVARCHAR(256), NOT NULL |
TAXATION_MODE
| Definition | The taxation mode for the subscriber account |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Default | 0 |
TAX_DATA
| 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 |
PREPAID_TAXATION_TYPE
| Definition | The prepaid balance taxation type |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Default | 0 |
PREPAID_TRANSAC_PARTITION_ID
| Definition | The partition ID for the prepaid transactions |
| Type | DECIMAL(3), NOT NULL |
| Default | -1 |
PARTITION_ID
| 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 |
Primary Key Details
See the primary key information:
PK_SUBSCRIBER_ACCOUNT
| Column(s) | PARTITION_ID,OID |
| Filegroup | SUBSCRIBER_DATA |
Index Details
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:
IX_SUAC_CODE
| Indexed Column(s) | PARTITION_ID,CODE,SERVICE_PROVIDER |
| Unique | Yes |
| Partitioned | No |
| Clustered | No |
| Filegroup | SUBSCRIBER_INDX |
IX_SUAC_OID
| Indexed Column(s) | OID |
| Unique | No |
| Partitioned | No |
| Clustered | No |
| Filegroup | SUBSCRIBER_INDX |