QP_SEARCH_ATTRIBUTE_VALUES
This table stores the values for the common attributes the users will search for the pricing entities like promotions, discount lists, etc. When the users perform the searches on the pricing entities, these attribute values in this table will be searched to return the results.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_SEARCH_ATTRIBUTE_VALUES_PK |
SEARCH_ATTRIBUTE_VALUE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SEARCH_ATTRIBUTE_VALUE_ID | NUMBER | 18 | Yes | This is the identifier for the search attribute value. This is system generated and is also the primary key for this table. | |
| ENTITY_TYPE_CODE | VARCHAR2 | 30 | Abbreviation that uniquely identifies the type of pricing entity for which the search attribute value is stored. For example, PROMOTION, DISCOUNT_LIST, etc. | ||
| ENTITY_SUB_TYPE_CODE | VARCHAR2 | 30 | Abbreviation that uniquely identifies the subtype of pricing entity for which the search attribute value is stored. For example, HEADER, LINE, BENEFITS, CONDITIONS, etc. | ||
| ENTITY_ID1 | NUMBER | 18 | Value that uniquely identifies the pricing entity for the search attribute value. For example, PROMOTION_ID. | ||
| ENTITY_ID2 | NUMBER | 18 | Value that uniquely identifies the pricing entity for the search attribute value. For example, PROMOTION_LINE_ID. | ||
| ENTITY_ID3 | NUMBER | 18 | Value that uniquely identifies the pricing entity for the search attribute value. For example, PROMOTION_RULE_ID. | ||
| ENTITY_ID4 | NUMBER | 18 | Value that uniquely identifies the pricing entity for the search attribute value. | ||
| ENTITY_ID5 | NUMBER | 18 | Value that uniquely identifies the pricing entity for the search attribute value. | ||
| ENTITY_ID6 | NUMBER | 18 | Value that uniquely identifies the pricing entity for the search attribute value. | ||
| ATTR_KEY_NAME | VARCHAR2 | 30 | The name of the attribute for which the search value is stored. For example, Item Id or Currency Code. | ||
| ATTR_KEY_VALUE_STRING | VARCHAR2 | 4000 | Attribute Value for an attribute with string data type. For example, for the attribute Currency Code which is a String data type, this column will store the Currency Code USD. | ||
| ATTR_KEY_VALUE_NUMBER | NUMBER | Attribute Value for an attribute with number data type. For example, for the attribute Item ID which is a Number data type, this column will store the inventory item id. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_SEARCH_ATTRIBUTE_VALUES_U1 | Unique | DEFAULT | SEARCH_ATTRIBUTE_VALUE_ID |
| QP_SEARCH_ATTR_VALUES_N1 | Non Unique | DEFAULT | ENTITY_TYPE_CODE, ENTITY_SUB_TYPE_CODE, ENTITY_ID1, ENTITY_ID2, ENTITY_ID3, ENTITY_ID4, ENTITY_ID5, ENTITY_ID6 |
| QP_SEARCH_ATTR_VALUES_N2 | Non Unique | DEFAULT | ATTR_KEY_NAME, ENTITY_TYPE_CODE |
| QP_SEARCH_ATTR_VALUES_N3 | Non Unique | DEFAULT | ATTR_KEY_VALUE_STRING |
| QP_SEARCH_ATTR_VALUES_N4 | Non Unique | DEFAULT | ATTR_KEY_VALUE_NUMBER |