CAPI_PARAMETER_REF
Definition
The CAPI_PARAMETER_REF table shows which charge plan parameter is referenced by a
charge plan item parameter
Technical Data
Summary
The CAPI_PARAMETER_REF table is defined by the
following columns.
See the column details for more information.
Column Details
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
PK_CAPI_PARAMETER_REF
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 |
| Segment |
CATALOG_INDX |
