PREPAID_ACCOUNT
Prepaid Accounts (in Customer Master Data)
Description
The PREPAID_ACCOUNT table stores all the
prepaid accounts defined in a subscriber account.
Each prepaid account includes a balance that is stored as a particular counter.
Technical Data
| Schema Version |
4.5.13 |
| Filegroup |
SUBSCRIBER_DATA |
| Partitioned |
Yes, when you use the partitioning scheme and corresponding SQL scripts |
Summary
The PREPAID_ACCOUNT table is defined by the
following columns.
See the column details for more information.
Column Details
SUAC_OID
| Definition |
The identifier of the subscriber account containing the prepaid account |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_PRAC_SUAC |
CODE
| Definition |
The identification code (or codename) of the account in the subscriber account |
| Type |
NVARCHAR(256), NOT NULL |
DESCRIPTION
| Definition |
The comprehensive description of the prepaid account |
| Type |
NVARCHAR(2000), NULL |
CURRENCY_CODE
| Definition |
The currency code of the prepaid account |
| Type |
NVARCHAR(5), NOT NULL |
EMPTY_LIMIT_AMOUNT
| Definition |
The empty limit amount of the prepaid account |
| Description |
The empty limit amount of the prepaid account. If the balance comes under this amount,
the usage of the customer services is not authorized.
|
| Type |
DECIMAL(28,6), NULL |
OVERRUN_CODE
| Definition |
The identification code of an external (postpaid) account or of another prepaid account
to charge in case of overrun
|
| Type |
NVARCHAR(256), NULL |
OVERRUN_TYPE
| Definition |
The type of the account (prepaid or external) to charge in case of overrun |
| Format |
The possible values are:
0: Undefined
1: Prepaid account
2: External (postpaid) account
|
| Type |
DECIMAL(1), NULL |
CLIENT_ID
| Definition |
Deprecated since version 1.0 of SAP CC. It was the identifier of the owner of the
prepaid account in BnR module (former billing services).
|
| Description |
Deprecated since version 1.0 of SAP Convergent Charging.
This column is not used anymore by the SAP CC system. It was the identifier of
the owner of the prepaid account in BnR module.
|
| Type |
NVARCHAR(256), NULL |
IS_DEFAULT
| Definition |
The IS_DEFAULT field indicates if the prepaid account is the default account for the
subscriber account
|
| Format |
The possible values are:
|
| Type |
DECIMAL(1), NOT NULL |
COUN_KEY
| Definition |
The identifier key of the counter that contains the value of the balance of the prepaid
account
|
| Type |
DECIMAL(6), NOT NULL |
BLOCKED_DATE_KEY
| Definition |
The key of the counter containing the date when the account is blocked |
| Type |
DECIMAL(6), NOT NULL |
LOCKED_DATE_KEY
| Definition |
The key of the counter containing the date when the account is locked |
| Type |
DECIMAL(6), NOT NULL |
CLOSED_DATE_KEY
| Definition |
The key of the counter containing the date when the account is closed |
| Type |
DECIMAL(6), NOT NULL |
PARTITION_ID
| Definition |
The partition of the subscriber account including the prepaid account |
| Type |
DECIMAL(4), NOT NULL |
Index Details
The following database indexes are available in the
PREPAID_ACCOUNT database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_PRAC_SUAC
| Indexed Column(s) |
SUAC_OID |
| Unique |
No |
| Partitioned |
Yes |
| Clustered |
No |
| Filegroup |
SUBSCRIBER_INDX |
