PATTRVALUE

The personalization attribute value table. This table holds the values associated with personalization attributes.

Column Descriptions:

NameTypeDescription
PATTRVALUE_IDBIGINT NOT NULLThe internal reference number of the personalized attribute value.
PATTRIBUTE_IDBIGINT NOT NULLThe internal reference number of the personalized attribute.
ATTRTYPE_IDCHAR (16) NOT NULLThe data type of the Attribute. For example, STRING, INTEGER, FLOAT, DATETIME, FREEFORM, or BIGINT.
OPERATOR_IDINTEGER NOT NULLThe 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_IDBIGINTThe 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_IDCHAR (16)The internal reference number of the QTYUNIT.
INTEGERVALUEINTEGERContains the value if the data type of the Attribute is set to INTEGER.
FLOATVALUEDOUBLEContains the value if the data type of the Attribute is set to FLOAT.
STRINGVALUEVARCHAR (254)Contains the value if the Attribute data type is set to STRING.
DATEVALUETIMESTAMPContains the value if the data type of the Attribute is set to DATETIME.
BIGINTVALUEBIGINTContains the value if the data type of the Attribute is set to DOUBLE.
SEQUENCEINTEGERReserved for HCL internal use.
ENCRYPTFLAGINTEGER NOT NULL DEFAULT 0Set to 1 if personalized attribute value is encrypted. The default is 0.
ORDERITEMS_IDBIGINTThe order item that this personalized attribute value describes.
MANDATORYINTEGER NOT NULL DEFAULT 0Indicates whether the personalization attribute is mandatory or not.
ATTACHMENT_IDBIGINTThe internal reference number of the Attachment.
CHANGEABLEINTEGER NOT NULL DEFAULT 0Indicates whether the personalization attribute is changeable or not.
RFQPROD_IDBIGINTThe RFQ Product that this personalized attribute value describes.
RFQRSPPROD_IDBIGINTThe RFQ Response Product that this personalized attribute value describes.
CORRELATIONGROUPBIGINTAny personalization attribute values that are part of the same group will have the same CORRELATIONGROUP values.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PATTRVALUE_IDPrimary Key
I0000354TERMCOND_IDNon-Unique Index
I0000355RFQPROD_IDNon-Unique Index
I0000356RFQRSPPROD_IDNon-Unique Index
I0000367CORRELATIONGROUPNon-Unique Index
I0000682PATTRIBUTE_IDNon-Unique Index
I0000683ORDERITEMS_IDNon-Unique Index
I0001270ATTACHMENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1004ATTACHMENT_IDATTACHMENTATTACHMENT_IDCascade
F_569ATTRTYPE_IDATTRTYPEATTRTYPE_IDCascade
F_570OPERATOR_IDOPERATOROPERATOR_IDCascade
F_571TERMCOND_IDTERMCONDTERMCOND_IDCascade
F_572QTYUNIT_IDQTYUNITQTYUNIT_IDCascade
F_573PATTRIBUTE_IDPATTRIBUTEPATTRIBUTE_IDCascade
F_987ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_988RFQRSPPROD_IDRFQRSPPRODRFQRSPPROD_IDCascade
F_989RFQPROD_IDRFQPRODRFQPROD_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_990PATTRVALUE_IDRFQRSPPARLRFQRSPPATTRVAL_IDCascade
F_993PATTRVALUE_IDRFQRSPPARLRFQPATTRVALUE_IDCascade