The personalization attribute value table. This table holds the values associated with personalization attributes.
Column Description(s):
Column Name | Column Type | Description |
PATTRVALUE_ID |
BIGINT NOT NULL |
The internal reference number of the personalized attribute value. |
PATTRIBUTE_ID |
BIGINT NOT NULL |
The internal reference number of the personalized attribute. |
ATTRTYPE_ID |
CHAR(16) NOT NULL |
The data type of the Attribute. For example, STRING, INTEGER, FLOAT, DATETIME, FREEFORM, or BIGINT. |
OPERATOR_ID |
INTEGER NOT NULL |
The internal reference number of the Operator. The Operator determines the relationship between the Name and Value. For example, equal; not equal; or greater than;. |
TERMCOND_ID |
BIGINT |
The internal reference number of the TermAndCondition for this value. Only one of the columns ORDERITEMS_ID, TERMCOND_ID, RFQPROD_ID, or RFQRSPPROD_ID must be specified. |
QTYUNIT_ID |
CHAR(16) |
The internal reference number of the QTYUNIT. |
INTEGERVALUE |
INTEGER |
Contains the value if the data type of the Attribute is set to INTEGER. |
FLOATVALUE |
DOUBLE |
Contains the value if the data type of the Attribute is set to FLOAT. |
STRINGVALUE |
VARCHAR(254) |
Contains the value if the Attribute data type is set to STRING. |
DATEVALUE |
TIMESTAMP |
Contains the value if the data type of the Attribute is set to DATETIME. |
BIGINTVALUE |
BIGINT |
Contains the value if the data type of the Attribute is set to DOUBLE. |
SEQUENCE |
INTEGER |
Reserved for IBM internal use. |
ENCRYPTFLAG |
INTEGER NOT NULL DEFAULT 0 |
Set to 1 if personalized attribute value is encrypted. The default is 0. |
ORDERITEMS_ID |
BIGINT |
The order item that this personalized attribute value describes. |
MANDATORY |
INTEGER NOT NULL DEFAULT 0 |
Indicates whether the personalization attribute is mandatory or not. |
ATTACHMENT_ID |
BIGINT |
The internal reference number of the Attachment. |
CHANGEABLE |
INTEGER NOT NULL DEFAULT 0 |
Indicates whether the personalization attribute is changeable or not. |
RFQPROD_ID |
BIGINT |
The RFQ Product that this personalized attribute value describes. |
RFQRSPPROD_ID |
BIGINT |
The RFQ Response Product that this personalized attribute value describes. |
CORRELATIONGROUP |
BIGINT |
Any personalization attribute values that are part of the same group will have the same CORRELATIONGROUP values. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |