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