| 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |