CAPI_COUNTER_REF

Definition

The CAPI_COUNTER_REF table shows which charge plan counter is referenced by a charge plan item counter

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by	Definition
CAPI_OID			IX_CAPA_CREF	CAPI (OID)		The identifier of the charge plan item
NAME						The name of the charge plan item counter
TARGET_NAME						The name of the charge plan counter
START_DATE						The start date of the counter reference period in the chronology
END_DATE						The end date of the counter reference period in the chronology

Column Details

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

CAPI_OID

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

NAME

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

TARGET_NAME

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

START_DATE

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

END_DATE

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

Index Details

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

IX_CAPA_CREF

Indexed Column(s)	CAPI_OID
Unique	No
Partitioned	No