CAPI_PARAMETER_REF

Definition

The CAPI_PARAMETER_REF table shows which charge plan parameter is referenced by a charge plan item parameter

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The CAPI_PARAMETER_REF 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_REF			CIPR_ADDITIONAL_INFO (CIPR_OID)	The unique identifier of the charge plan parameter reference More...
CAPI_OID		IX_CAPA_PREF	CAPI (OID)		The identifier of the charge plan item
NAME					The name of the charge plan item parameter
TARGET_NAME					The name of the charge plan parameter referenced by the charge plan item parameter
VALUE_TYPE					The type of the charge plan item parameter More...
START_DATE					The start date of the parameter reference period in the chronology
END_DATE					The end date of the parameter reference 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 reference
Description	The unique identifier of the charge plan parameter reference. It is generated by the system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CAPI_PARAMETER_REF

CAPI_OID

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

NAME

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

TARGET_NAME

Definition	The name of the charge plan parameter referenced by the charge plan item parameter
Type	NVARCHAR(256), NOT NULL

VALUE_TYPE

Definition The type of the charge plan item parameter

Format

The possible values are:

0: number
1: string
2: date

Type DECIMAL(1), NULL

START_DATE

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

END_DATE

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

Primary Key Details

See the primary key information:

PK_CAPI_PARAMETER_REF

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

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

IX_CAPA_PREF

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