PMIN_ADDITIONAL_INFO

Definition

The PMIN_ADDITIONAL_INFO table contains the additional information for rating context properties in the pricing macro

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The PMIN_ADDITIONAL_INFO table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	FK	IX	Uses	Used by	Definition
MACR_OID				PRICING_MACRO (OID)		The identifier of the pricing macro
INDEX_IN_MACR						The index of the properties in the pricing macro
NAME						The name of the additional information
VALUE_TYPE						The type of the additional information More...
NUMBER_VALUE						The value of the additional information when it is a number
STRING_VALUE						The value of the additional information when it is a string
DATE_VALUE						The value of the additional information when it is a date

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

MACR_OID

Definition	The identifier of the pricing macro
Type	DECIMAL(28), NOT NULL

INDEX_IN_MACR

Definition	The index of the properties in the pricing macro
Type	DECIMAL(@), NOT NULL

NAME

Definition	The name of the additional information
Type	NVARCHAR(256), NOT NULL

VALUE_TYPE

Definition	The type of the additional information
Format	The possible values are: 0: number 1: string 2: date
Type	DECIMAL(1), NOT NULL

NUMBER_VALUE

Definition	The value of the additional information when it is a number
Type	DECIMAL(28,6), NULL

STRING_VALUE

Definition	The value of the additional information when it is a string
Type	NVARCHAR(2000), NULL

DATE_VALUE

Definition	The value of the additional information when it is a date
Type	DATETIME, NULL