The personalization attribute value table. This table holds the values associated with personalization attributes.
Column Descriptions
| 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.
|