Table:
CAPI_PARAMETER_REF
|
Table Name
|
CAPI_PARAMETER_REF |
| Table Description |
The CAPI_PARAMETER_REF table shows which charge plan parameter is referenced by a charge plan item parameter. |
| Tablespace |
CATALOG_DATA |
| Database |
Core Database |
|
Columns
|
|
Columns of the Table
The CAPI_PARAMETER_REF database table is defined by the following columns.
Column: OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
Primary Key: PK_CAPI_PARAMETER_REF |
Foreign K.:
- Foreign table: CAPI
- Foreign field(s): OID
|
| Index(es) |
IX_CAPA_PREF
|
| Column Description |
The unique identifier of the charge plan parameter reference. It is generated by the system. |
Column: CAPI_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: CAPI
- Foreign field(s): OID
|
| Index(es) |
IX_CAPA_PREF
|
| Column Description |
The identifier of the charge plan item. |
Column: NAME
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The name of the charge plan item parameter. |
Column: TARGET_NAME
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The name of the charge plan parameter referenced by the charge plan item parameter. |
Column: VALUE_TYPE
| Value Type |
DECIMAL(1) |
|
| Column Description |
The type of the charge plan item parameter. Possible values are:
- 0: number
- 1: string
- 2: date
|
Column: START_DATE
| Value Type |
DATE |
|
| Column Description |
The start date of the parameter reference period in the chronology. |
Column: END_DATE
| Value Type |
DATE |
|
| Column Description |
The end date of the parameter reference period in the chronology. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.