CREDIT_LIMIT_BALANCE
Credit Limit Balances (in Subscriber Accounts)
Definition
The CREDIT_LIMIT_BALANCE table represents a credit limit balance in a subscriber account
Technical Data
| Schema Version |
4.5.13 |
| Tablespace |
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.
See the column details for more information.
Column Details
SUAC_OID
| Definition |
The identifier of the subscriber account containing the credit limit balance |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_CLBA_SUAC |
| Available Index |
IX_CLBA_SUAC_G |
CODE
| Definition |
The identification code (or code name) of the credit limit balance in the subscriber
account
|
| Type |
VARCHAR2(256 CHAR), NOT NULL |
| Available Index |
IX_CLBA_SUAC_G |
DESCRIPTION
| Definition |
The comprehnsive description of the credit limit balance |
| Type |
VARCHAR2(2000 CHAR), NULL |
CURRENCY_CODE
| Definition |
The currency code of the credit limit balance |
| Type |
VARCHAR2(5 CHAR), 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 |
VARCHAR2(256 CHAR), NULL |
REFERENCE_DATE
| Definition |
The reference date for automatically resetting the credit limit balance |
| Type |
DATE, 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:
0: the credit limit balance is not charged by default
1: the credit limit balance is charged by default
|
| 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 |
| Tablespace |
SUBSCRIBER_INDX |
IX_CLBA_SUAC_G
| Indexed Column(s) |
SUAC_OID, CODE |
| Unique |
No |
| Partitioned |
No |
| Tablespace |
SUBSCRIBER_INDX |
