MOT_TERR_RULES
This is the entity that organizes the territory boundaries ie. dimensions in the form of Rules. Using this territories can be either just simple territories defined by a single rule or complex ones with multiple rules. This entity along with Territory Rule Boundary Value stores the dimensions of the Territory in an expression form. Rules are evaluated as choices ie. not additively. eg. if Rule 1 has Geography and Product as dimensions and Rule 2 has only Geography and Industry as dimensions, both will be evaluated and the Territory will be chosen if either Rule is a match.
Details
-
Schema: FUSION
-
Object owner: MOT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOT_TERR_RULES_PK |
TERR_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TERR_RULE_ID | NUMBER | 18 | Yes | Primary Key | |
| TERRITORY_VERSION_ID | NUMBER | 18 | Yes | Foreign key to MOT_TERRITORIES | |
| RULE_NUMBER | NUMBER | 18 | Yes | A unique number within a territory definition. Generated from a sequence. | |
| RULE_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifier for the type of rule, also known as coverage type. | |
| RULE_OPERATOR_CODE | VARCHAR2 | 30 | Yes | Identifies whether the rule is inclusion or exclusion | |
| 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. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MOT_TERR_RULES | mot_territories | TERRITORY_VERSION_ID |
| mot_terr_rule_boundaries | mot_terr_rules | TERR_RULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MOT_TERR_RULES_N1 | Non Unique | Default | TERRITORY_VERSION_ID |
| MOT_TERR_RULES_N2 | Non Unique | Default | LAST_UPDATE_DATE |
| MOT_TERR_RULES_PK | Unique | Default | TERR_RULE_ID |