PREPAID_ACCOUNT
Definition
The PREPAID_ACCOUNT table stores all the prepaid accounts defined in a subscriber account
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.6.2 | |
| 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 in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| SUAC_OID | IX_PRAC_SUAC | SUBSCRIBER_ACCOUNT (OID)
|
|
The identifier of the subscriber account containing the prepaid account | ||
| CODE |
|
The identification code (or codename) of the account in the subscriber account | ||||
| DESCRIPTION |
|
The comprehensive description of the prepaid account | ||||
| EXTERNAL_ACCOUNT_NAME |
|
Field used to reference an account in an external system. For example, it is used by SAP ERP FICA to store the VKONT identifier. | ||||
| EXTERNAL_ACCOUNT_CODE |
|
Field used to reference an account in an external system. For example, it is used by SAP ERP FICA to store the GPART identifier. | ||||
| CURRENCY_CODE |
|
The currency code of the prepaid account | ||||
| EMPTY_LIMIT_AMOUNT |
|
The empty limit amount of the prepaid account | ||||
| OVERRUN_CODE | EXTERNAL_ACCOUNT (CODE)
PREPAID_ACCOUNT (CODE) |
|
The identification code of an external (postpaid) account or of another prepaid account to charge in case of overrun | |||
| OVERRUN_TYPE |
|
The type of the account (prepaid or external) to charge in case of overrun | ||||
| CLIENT_ID |
|
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). | ||||
| IS_DEFAULT |
|
The IS_DEFAULT field indicates if the prepaid account is the default account for the subscriber account | ||||
| COUN_KEY | COUNTER (COUN_KEY)
|
|
The identifier key of the counter that contains the value of the balance of the prepaid account | |||
| BLOCKED_DATE_KEY |
|
The key of the counter containing the date when the account is blocked | ||||
| LOCKED_DATE_KEY |
|
The key of the counter containing the date when the account is locked | ||||
| CLOSED_DATE_KEY |
|
The key of the counter containing the date when the account is closed | ||||
| PARTITION_ID |
|
The partition of the subscriber account including the prepaid account |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
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 |
EXTERNAL_ACCOUNT_NAME
| Definition | Field used to reference an account in an external system. For example, it is used by SAP ERP FICA to store the VKONT identifier. |
| Type | NVARCHAR(256), NULL |
EXTERNAL_ACCOUNT_CODE
| Definition | Field used to reference an account in an external system. For example, it is used by SAP ERP FICA to store the GPART identifier. |
| Type | NVARCHAR(256), 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:
|
| 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 |