CCON_PARAMETER

Description


Technical Data


Schema Version 4.5.13
Filegroup CATALOG_DATA
Partitioned No

Summary


The CCON_PARAMETER table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
INDEX_IN_CCON          
NAME          
DESCRIPTION          
PARAMETER_NAME          
VALUE_TYPE          
NUMBER_VALUE          
STRING_VALUE          
DATE_VALUE          
CCON_OID     IX_CCPA_CCON  CHARGE_CONDITION (OID)
 
 
VALIDATION_DATE          

Column Details


INDEX_IN_CCON

Definition The index of the parameter in the charge condition
Type DECIMAL(5), NOT NULL

NAME

Definition The name of the parameter
Type NVARCHAR(256), NULL

DESCRIPTION

Definition The description of the parameter
Type NVARCHAR(2000), NULL

PARAMETER_NAME

Definition The parameter in the charge condition can be linked to a parameter with the same type defined in the offer
Description The parameter in the charge condition can be linked to a parameter with the same type defined in the offer. The PARAMETER_NAME field gives the name of the parameter defined in the offer.
Type NVARCHAR(256), NULL

VALUE_TYPE

Definition The type of the parameter
Format

The possible values are:

  • 0: number
  • 1: string
  • 2: date

Type DECIMAL(1), NOT NULL

NUMBER_VALUE

Definition The value of the parameter when it is a number
Type DECIMAL(28,6), NULL

STRING_VALUE

Definition The value of the parameter when it is a string
Type NVARCHAR(2000), NULL

DATE_VALUE

Definition The value of the parameter when it is a date
Type DATETIME, NULL

CCON_OID

Definition The identifier of the charge condition owning the parameter
Type DECIMAL(28), NOT NULL
Available Index IX_CCPA_CCON

VALIDATION_DATE

Definition The date when the parameter becomes valid
Type DATETIME, NULL

Index Details


The following database indexes are available in the CCON_PARAMETER database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_CCPA_CCON

Indexed Column(s) CCON_OID
Unique No
Partitioned No
Clustered No
Filegroup CATALOG_INDX