Table:
CREDIT_LIMIT_BALANCE
|
Table Name
|
CREDIT_LIMIT_BALANCE |
| Table Description |
The CREDIT_LIMIT_BALANCE table represents a credit limit balance in a subscriber account. |
| Tablespace |
SUBSCRIBER_DATA |
| Database |
Core Database |
|
Partitioned
|
Yes
|
|
Columns
|
|
Columns of the Table
The CREDIT_LIMIT_BALANCE database table is defined by the following columns.
Column: SUAC_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: SUBSCRIBER_ACCOUNT
- Foreign field(s): OID
|
| Index(es) |
IX_CLBA_SUAC
IX_CLBA_SUAC_G (unique) (oracle)
|
| Column Description |
The identifier of the subscriber account containing the credit limit balance. |
Column: CODE
| Value Type |
VARCHAR(256), NOT NULL |
|
| Index(es) |
IX_CLBA_SUAC_G (unique) (oracle)
|
| Column Description |
The code (and the name) of the credit limit balance. |
Column: DESCRIPTION
| Value Type |
VARCHAR(2000) |
|
| Column Description |
The description of the credit limit balance. |
Column: CURRENCY_CODE
| Value Type |
VARCHAR(5), NOT NULL |
|
| Column Description |
The currency code of the credit limit balance. |
Column: CREDIT_LIMIT
| Value Type |
DECIMAL(28,6) |
|
| Column Description |
The amount of the balance when resetting the credit limit balance. |
Column: RESET_FREQUENCY
| Value Type |
VARCHAR(256) |
|
| Column Description |
The frequency for resetting the credit limit balance. |
Column: REFERENCE_DATE
| Value Type |
DATE |
|
| Column Description |
The reference date for automatically resetting the credit limit balance. |
Column: LAST_RESET_DATE_KEY
| Value Type |
DECIMAL(6) |
|
| Column Description |
The key of the counter containing the last date when the credit limit balance was reset. |
Column: COUN_KEY
| Value Type |
DECIMAL(6), NOT NULL |
|
| Column Description |
The key of the counter containing the current value of the credit limit balance. |
Column: IS_DEFAULT
| Value Type |
DECIMAL(1), NOT NULL |
|
| Column Description |
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. Possible values are:
- 0: the credit limit balance is not charged by default
- 1: the credit limit balance is charged by default
|
Column: PARTITION_ID
| Value Type |
SMALLINT, NOT NULL |
|
| Column Description |
The partition of the subscriber account owning the credit limit balance. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.