Table:
CAPI_CITM_ENTRY
|
Table Name
|
CAPI_CITM_ENTRY |
| Table Description |
The CAPI_CITM_ENTRY table describes the entries of the charged item mapping in the charge plan item. |
| Tablespace |
CATALOG_DATA |
| Database |
Core Database |
|
Columns
|
|
Columns of the Table
The CAPI_CITM_ENTRY database table is defined by the following columns.
Column: CITM_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: CAPI_CHARGED_ITEM_MAPPING
- Foreign field(s): OID
|
| Index(es) |
IX_CAPI_CITM_ENTRY
|
| Column Description |
The OID of the charged item mapping. |
Column: CITC_FIELD_NAME
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The name of the field in the charged item class. It must be unique for a charged item mapping. |
Column: VALUE_TYPE
| Value Type |
DECIMAL(1), NOT NULL |
|
| Column Description |
The type of the field.
Possible values are:
- 0: number
- 1: string
- 2: date
- 3: boolean
|
Column: STRING_VALUE
| Value Type |
VARCHAR(64) |
|
| Column Description |
The value of the field when it is a string. |
Column: NUMBER_VALUE
| Value Type |
DECIMAL(28,6) |
|
| Column Description |
The value of the field when it is a number. |
Column: DATE_VALUE
| Value Type |
DATE |
|
| Column Description |
The value of the field when it is a date. |
Column: BOOLEAN_VALUE
| Value Type |
DECIMAL(1) |
|
| Column Description |
The value of the field when it is a boolean. |
Column: PROPERTY_NAME
| Value Type |
VARCHAR(256) |
|
| Column Description |
The name of the property to map. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.