CREDIT_LIMIT_BALANCE
Definition
The CREDIT_LIMIT_BALANCE table represents a credit limit balance in 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 CREDIT_LIMIT_BALANCE 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_CLBA_SUAC | SUBSCRIBER_ACCOUNT (OID)
|
|
The identifier of the subscriber account containing the credit limit balance | ||
| CODE |
|
The identification code (or code name) of the credit limit balance in the subscriber account | ||||
| DESCRIPTION |
|
The comprehensive description of the credit limit balance | ||||
| CURRENCY_CODE |
|
The currency code of the credit limit balance | ||||
| CREDIT_LIMIT |
|
The amount of the balance when resetting the credit limit balance | ||||
| RESET_FREQUENCY |
|
The frequency for resetting the credit limit balance | ||||
| REFERENCE_DATE |
|
The reference date for automatically resetting the credit limit balance | ||||
| LAST_RESET_DATE_KEY |
|
The key of the counter containing the last date when the credit limit balance was reset | ||||
| COUN_KEY | COUNTER (COUN_KEY)
|
|
The key of the counter containing the current value of the credit limit balance | |||
| IS_DEFAULT |
|
Indicates if the credit limit balance is charged by default if the related subscription specifies no charging mapping for the references identified in the charging plan | ||||
| PARTITION_ID |
|
The partition of the subscriber account owning the credit limit balance |
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 credit limit balance |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_CLBA_SUAC |
CODE
| Definition | The identification code (or code name) of the credit limit balance in the subscriber account |
| Type | NVARCHAR(256), NOT NULL |
DESCRIPTION
| Definition | The comprehensive description of the credit limit balance |
| Type | NVARCHAR(2000), NULL |
CURRENCY_CODE
| Definition | The currency code of the credit limit balance |
| Type | NVARCHAR(5), NOT NULL |
CREDIT_LIMIT
| Definition | The amount of the balance when resetting the credit limit balance |
| Type | DECIMAL(28,6), NULL |
RESET_FREQUENCY
| Definition | The frequency for resetting the credit limit balance |
| Type | NVARCHAR(256), NULL |
REFERENCE_DATE
| Definition | The reference date for automatically resetting the credit limit balance |
| Type | DATETIME, NULL |
LAST_RESET_DATE_KEY
| Definition | The key of the counter containing the last date when the credit limit balance was reset |
| Type | DECIMAL(6), NULL |
COUN_KEY
| Definition | The key of the counter containing the current value of the credit limit balance |
| Type | DECIMAL(6), NOT NULL |
IS_DEFAULT
| Definition | Indicates if the credit limit balance is charged by default if the related subscription specifies no charging mapping for the references identified in the charging plan |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
PARTITION_ID
| Definition | The partition of the subscriber account owning the credit limit balance |
| Type | DECIMAL(4), NOT NULL |
Index Details
The following database indexes are available in the CREDIT_LIMIT_BALANCE database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
IX_CLBA_SUAC
| Indexed Column(s) | SUAC_OID |
| Unique | No |
| Partitioned | Yes |
| Clustered | No |
| Filegroup | SUBSCRIBER_INDX |