Table: PMIN_ADDITIONAL_INFO

Table Name PMIN_ADDITIONAL_INFO
Table Description The PMIN_ADDITIONAL_INFO table contains the additional information for rating context properties in the pricing macro.
Tablespace CATALOG_DATA
Database Core Database
Columns
MACR_OID
INDEX_IN_MACR
NAME
VALUE_TYPE
NUMBER_VALUE
STRING_VALUE
DATE_VALUE

Columns of the Table

The PMIN_ADDITIONAL_INFO database table is defined by the following columns.

Column: MACR_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

  • Foreign table: PRICING_MACRO
  • Foreign field(s): OID

Column Description The identifier of the pricing macro.


Column: INDEX_IN_MACR

Value Type DECIMAL, NOT NULL
Column Description The index of the properties in the pricing macro.


Column: NAME

Value Type VARCHAR(256), NOT NULL
Column Description The name of the additional information.


Column: VALUE_TYPE

Value Type DECIMAL(1), NOT NULL
Column Description The type of the additional information. Possible values are:
  • 0: number
  • 1: string
  • 2: date


Column: NUMBER_VALUE

Value Type DECIMAL(28,6)
Column Description The value of the additional information when it is a number.


Column: STRING_VALUE

Value Type VARCHAR(2000)
Column Description The value of the additional information when it is a string.


Column: DATE_VALUE

Value Type DATE
Column Description The value of the additional information when it is a date.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.