SUBSCRIBER_ACCOUNT
Subscriber Accounts (Customer Master Data)
Description
The SUBSCRIBER_ACCOUNT table stores the subscriber account master data for
each end customer (subscriber) who uses a 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.
Note
Consider the customer data that belongs to a subscriber account:
Technical Data
| Schema Version |
4.5.13 |
|
| Partitioned |
No |
Summary
The SUBSCRIBER_ACCOUNT table is defined by the
following columns.
See the column details for more information.
Column Details
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 of 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, this is the end customer who
uses the services from the service provider.
|
| Type |
NVARCHAR(256), NOT NULL |
SERVICE_PROVIDER
| Definition |
The service provider for the subscriber account. It is the owner of the subscriber
account.
|
| 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:
0: VAT
1: EZTax
2: No tax system
|
| 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:
-
NO_TAX
-
BY_RULE
-
/EZTAX_AREA/
if using EZTax
-
The following syntax for VAT taxation
/<country code>/<sort of
tax>#<timestamp>
where:
-
<country code>
is the ISO code of the country
-
<sort of tax>
gives the tax rate to apply:
0: NORMAL_TAX_RATE
1: INTERMEDIARY_TAX_RATE
2: REDUCED_TAX_RATE
3: SUPER_REDUCED_TAX_RATE
4: ZERO_TAX_RATE
5: SPECIAL_TAX_RATE
-
<timestamp>
is the number of days before applying the tax rate from the 1st
of January 1970.
|
| Type |
NVARCHAR(256), NOT NULL |
TAXATION_MODE
| Definition |
The taxation mode for the subscriber account |
| Format |
The possible values are:
0: VENDOR_SUBJECT_TO_PAY
1: BUYER_SUBJECT_TO_PAY
2: BUYER_EXEMPTED
3: NOBODY_SUBJECT_TO_PAY
|
| 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:
0: Tax excluded
1: Tax included
|
| 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 of the subscriber account |
| Type |
DECIMAL(4), NOT NULL |
Primary Key Details
PK_SUBSCRIBER_ACCOUNT
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) |
CODE,SERVICE_PROVIDER |
| Unique |
Yes |
| Partitioned |
No |
IX_SUAC_OID
| Indexed Column(s) |
OID |
| Unique |
No |
| Partitioned |
No |
