CAPI_PARAMETER

Definition

The CAPA_PARAMETER table contains the parameters of the charge plan items

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

The CAPI_PARAMETER table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	IX	Uses	Used by	Definition
OID	PK_CAPI_PARAMETER			CIPA_ADDITIONAL_INFO (CIPA_OID)	The unique identifier of the charge plan parameter More...
CAPI_OID		IX_CAPA_IPR	CAPI (OID)		The identifier of the charge plan item
NAME					The name of the parameter
VALUE_TYPE					The type of the parameter More...
NUMBER_VALUE					The value of the parameter when it is a number
STRING_VALUE					The value of the parameter when it is a string
DATE_VALUE					The value of the parameter when it is a date
START_DATE					The start date of the parameter period in the chronology
END_DATE					The end date of the parameter period in the chronology

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

Definition	The unique identifier of the charge plan parameter
Description	The unique identifier of the charge plan parameter. It is generated by the system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CAPI_PARAMETER

CAPI_OID

Definition	The identifier of the charge plan item
Type	DECIMAL(28), NOT NULL
Available Index	IX_CAPA_IPR

NAME

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

VALUE_TYPE

Definition The type of the parameter

Format

The possible values are:

0: number
1: string
2: date
3: currency

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	SECONDDATE, NULL

START_DATE

Definition	The start date of the parameter period in the chronology
Type	SECONDDATE, NULL

END_DATE

Definition	The end date of the parameter period in the chronology
Type	SECONDDATE, NULL

Primary Key Details

See the primary key information:

PK_CAPI_PARAMETER

Column(s)	OID
Tablespace	CATALOG_INDX

Index Details

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

IX_CAPA_IPR

Indexed Column(s)	CAPI_OID
Unique	No
Partitioned	No