Table:
IN_MACRO_PROPERTY
|
Table Name
|
IN_MACRO_PROPERTY |
| Table Description |
The IN_MACRO_PROPERTY table contains the descriptions of rating context properties in the pricing macros. |
| Tablespace |
CATALOG_DATA |
| Database |
Core Database |
|
Columns
|
|
Columns of the Table
The IN_MACRO_PROPERTY database table is defined by the following columns.
Column: MACR_OID
| Value Type |
BIGINT |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: PRICING_MACRO
- Foreign field(s): OID
|
| Index(es) |
IX_IN_MACRO_PROPERTY
|
| Column Description |
The identifier of the pricing macro owning the property. |
Column: INDEX_IN_MACR
| Value Type |
DECIMAL(3), NOT NULL |
|
| Column Description |
The index of the property in the pricing macro. |
Column: NAME
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The name of the property. |
Column: DESCRIPTION
| Value Type |
VARCHAR(2000) |
|
| Column Description |
The description of the property. |
Column: VALUE_TYPE
| Value Type |
DECIMAL(1), NOT NULL |
|
| Column Description |
The type of the property. Possible values are:
- 0: number
- 1: string
- 2: date
- 4: multi-valued number
- 5: multi-valued string
|
Column: COUNTER
| Value Type |
DECIMAL(1), NOT NULL |
|
| Column Description |
Indicates if the property is a counter. Possible values are:
- 0: the property is not a counter.
- 1: the property is a counter and the VALUE_TYPE field is set to 0 as for any number.
|
Column: NB_ADDITIONAL_INFO
| Value Type |
DECIMAL(3), NOT NULL |
|
| Column Description |
The number of additional info for this parameter |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.