This table contains a list of rules used in search configurations. Search configurations are used in ATG Merchandising.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| smallint | No | Identifier; primary key. | |
| varchar | 40 | No | Natural key of the rule. |
| varchar | 254 | Yes | Rule name. |
| varchar | 254 | Yes | Rule description. |
| smallint | No | Foreign key to | |
| timestamp | Yes | Date when the information in this warehouse record became effective | |
| timestamp | Yes | Date when the information in this warehouse record is no longer effective. | |
| timestamp | Yes | Date this record was last updated. | |
| one-digit | No | Indicates that this record is the most recent. 0 = No 1 = Yes Default value is 1. | |
| one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes Default value is 0. |