| Table Name: | elgblty_set |
| Table Number: | 5765 |
| Group: | Morder |
| Description: | Criteria for eligibility |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| expr | CHAR | text | ALLOW_NULL | Expression text for the eligibility set | Search (1) | |||
| focus_lowid | LONG | int | DIRECT, ALLOW_NULL | Internal record number of the default drill down object for the event | ||||
| focus_type | LONG | smallint | DIRECT, ALLOW_NULL | Object type ID of the default drill down object for the event | ||||
| is_warning_only | LONG | tinyint | 0 | DIRECT, ALLOW_NULL | Indicates that the rule only generates a warning if it fails. 1=Yes, 0=No;Default = 0 | Search (1) | ||
| last_update | CLK_TIME | datetime | 46 | Date time of last update | ||||
| message | CHAR | varchar | 1000 | ALLOW_NULL | Message to be returned if the rule is false | Search (1) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
| rule_type | CHAR | varchar | 40 | User defined type of rule | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| elgbty_set2mod_level | MTM | mod_level | mod_level2elgblty_set | The products using the rules | mtm_mod_level56_ elgblty_set3 | Search (1) | ||||
| elgblty_set2offering | OTOP | offering | offering2elgblty_set | Offering using the eligibility expression | eligibility_for | focus_type | focus_lowid | |||
| elgblty_set2offr_price | OTOP | offr_price | offr_price2elgblty_set | Indirect offering price using the eligibility expression | eligibility_for | focus_type | focus_lowid | |||
| elgblty_set2price_prog | OTOP | price_prog | price_prog2elgblty_set | Cost price schedule using the eligibility expression | eligibility_for | focus_type | focus_lowid | |||
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| fl5765 | focus_lowid, focus_type | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| rt5765 | rule_type | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 6036 | product_rules_view | elgblty_set, mod_level |
| elgblty_set | |||