The personalization Attribute Value table. This table holds the values associated with personalization attributes.
Column Name | Column Type | Column Description |
---|---|---|
ATTACHMENT_ID | BIGINT NULL |
The internal reference number of the Attachment. |
ATTRTYPE_ID | CHARACTER (16) NOT NULL |
The data type of the Attribute. For example, STRING, INTEGER, FLOAT, DATETIME, FREEFORM, or BIGINT. |
BIGINTVALUE | BIGINT NULL |
Contains the Value if the data type of the Attribute is "DOUBLE". |
CHANGEABLE | INTEGER NOT NULL, DEFAULT 0 |
Indicates whether the personalization attribute is changeable or not. |
CORRELATIONGROUP | BIGINT NULL |
Any personalization attribute values that are part of the same group will have the same CORRELATIONGROUP values. |
DATEVALUE | TIMESTAMP NULL |
Contains the value if the data type of the Attribute is "DATETIME". |
ENCRYPTFLAG | INTEGER NOT NULL, DEFAULT 0 |
Set to 1 if personalized attribute value is encrypted. Default is 0. |
FLOATVALUE | DOUBLE NULL |
Contains the Value if the data type of the Attribute is "FLOAT". |
INTEGERVALUE | INTEGER NULL |
Contains the value if the data type of the Attribute is "INTEGER". |
MANDATORY | INTEGER NOT NULL, DEFAULT 0 |
Indicates whether the personalization attribute is mandatory or not. |
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;. |
ORDERITEMS_ID | BIGINT NULL |
The order item that this personalized attribute value describes. |
PATTRIBUTE_ID | BIGINT NOT NULL |
The internal reference number of the Personalized Attribute. |
PATTRVALUE_ID | BIGINT NOT NULL |
The internal reference number of the Personalized Attribute Value. |
QTYUNIT_ID | CHARACTER (16) NULL |
The internal reference number of the QTYUNIT. |
RFQPROD_ID | BIGINT NULL |
The RFQ Product that this personalized attribute value describes. |
RFQRSPPROD_ID | BIGINT NULL |
The RFQ Response Product that this personalized attribute value describes. |
SEQUENCE | INTEGER NULL |
Reserved for IBM internal use. |
STRINGVALUE | VARCHAR (254) NULL |
Contains the Value if the Attribute data type is "STRING". |
TERMCOND_ID | BIGINT NULL |
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035028970 | PATTRVALUE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_1004 | ATTACHMENT_ID | ATTACHMENT | ATTACHMENT_ID | Cascade |
F_569 | ATTRTYPE_ID | ATTRTYPE | ATTRTYPE_ID | Cascade |
F_570 | OPERATOR_ID | OPERATOR | OPERATOR_ID | Cascade |
F_571 | TERMCOND_ID | TERMCOND | TERMCOND_ID | Cascade |
F_572 | QTYUNIT_ID | QTYUNIT | QTYUNIT_ID | Cascade |
F_573 | PATTRIBUTE_ID | PATTRIBUTE | PATTRIBUTE_ID | Cascade |
F_987 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_988 | RFQRSPPROD_ID | RFQRSPPROD | RFQRSPPROD_ID | Cascade |
F_989 | RFQPROD_ID | RFQPROD | RFQPROD_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_990 | PATTRVALUE_ID | RFQRSPPARL | RFQRSPPATTRVAL_ID | Cascade |
F_993 | PATTRVALUE_ID | RFQRSPPARL | RFQPATTRVALUE_ID | Cascade |