Table:
SUBS_PARAMETER
|
Table Name
|
SUBS_PARAMETER |
| Table Description |
The SUBS_PARAMETER table contains parameters in subscriptions. These parameters are first created in the offer corresponding
to
the subscription. Then they are redefined in the subscription.
|
| Tablespace |
SUBSCRIBER_DATA |
| Database |
Core Database |
|
Partitioned
|
Yes
|
|
Columns
|
|
Columns of the Table
The SUBS_PARAMETER database table is defined by the following columns.
Column: PARA_KEY
| Value Type |
DECIMAL(6), NOT NULL |
|
| Column Description |
The identifier of the parameter. |
Column: INDEX_IN_SUBS
| Value Type |
DECIMAL(5), NOT NULL |
|
| Column Description |
The position of the parameter in the subscription. |
Column: DESCRIPTION
| Value Type |
VARCHAR(2000) |
|
| Column Description |
The description of the parameter. |
Column: VALUE_TYPE
| Value Type |
DECIMAL(1), NOT NULL |
|
| Column Description |
The type of the parameter.
Possible values are:
- 0: number
- 1: string
- 2: date
|
Column: NUMBER_VALUE
| Value Type |
DECIMAL(28,6) |
|
| Column Description |
The value of the parameter when it is a number. |
Column: STRING_VALUE
| Value Type |
VARCHAR(2000) |
|
| Column Description |
The value of the parameter when it is a string. |
Column: DATE_VALUE
| Value Type |
DATE |
|
| Column Description |
The value of the parameter when it is a date. |
Column: SUBS_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: SUBSCRIPTION
- Foreign field(s): OID
|
| Index(es) |
IX_SUB_PARA
IX_SP_ROOT_SUBS_OID
|
| Column Description |
The identifier of the subscription owning the parameter. |
Column: VALIDATION_DATE
| Value Type |
DATE |
|
| Column Description |
The date when the parameter becomes valid. |
Column: ROOT_SUBS_OID
| Value Type |
BIGINT, NOT NULL |
|
| Index(es) |
IX_SP_ROOT_SUBS_OID
|
| Column Description |
The identifier of the root subscription. |
Column: PARTITION_ID
| Value Type |
SMALLINT, NOT NULL |
|
| Column Description |
The partition of the subscriber account owning the subscription which contains the parameter. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.