MOT_TERR_BOUNDARY_DN
This entity stores information for territories and the cartesian product of boundary values for each territory.
Details
-
Schema: FUSION
-
Object owner: MOT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOT_TERR_BOUNDARY_DN_PK |
TERR_BOUNDARY_DN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TERR_BOUNDARY_DN_ID | NUMBER | 18 | Yes | Primary Key | |
| TERRITORY_ID | NUMBER | 18 | Yes | Foreign key to MOT_TERRITORIES | |
| TERRITORY_VERSION_ID | NUMBER | 18 | Yes | Foreign key to MOT_TERRITORIES | |
| TERR_RULE_ID | NUMBER | 18 | Yes | Identifier for the rule also known as coverage | |
| RULE_OPERATOR_CODE | VARCHAR2 | 30 | Yes | Identifies whether the rule is inclusion or exclusion. | |
| RULE_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifier for the type of rule, also known as coverage type. | |
| PARENT_TERRITORY_ID | NUMBER | 18 | Points to Parent Territory. | ||
| TERR_PROPOSAL_ID | NUMBER | 18 | Foreign Key to MOT_TERR_PROPOSALS | ||
| TERR_STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status the Territory is in. | |
| COVERAGE_MODEL | VARCHAR2 | 30 | Yes | Identifies whether the territory dimensionality is based on sales account attributes or partner attributes. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| GEO_SEQ_LOW | NUMBER | 18 | Geography Dimension Sequence Low Value | ||
| GEO_SEQ_HIGH | NUMBER | 18 | Geography Dimension Sequence High Value | ||
| PRODUCT_SEQ_LOW | NUMBER | 18 | Product Dimension Sequence Low Value | ||
| PRODUCT_SEQ_HIGH | NUMBER | 18 | Product Dimension Sequence High Value | ||
| ACCOUNT_SEQ_LOW | NUMBER | 18 | Account Dimension Sequence Low Value | ||
| ACCOUNT_SEQ_HIGH | NUMBER | 18 | Account Dimension Sequence High Value | ||
| INDUSTRY_SEQ_LOW | NUMBER | 18 | Lower value of the dimension member range sequence | ||
| INDUSTRY_SEQ_HIGH | NUMBER | 18 | Higher value of the dimension member range sequence | ||
| CUST_SIZE_SEQ_LOW | NUMBER | 18 | Lower value of the dimension member range sequence | ||
| CUST_SIZE_SEQ_HIGH | NUMBER | 18 | Higher value of the dimension member range sequence | ||
| ORG_TYPE_SEQ_LOW | NUMBER | 18 | Lower value of the dimension member range sequence | ||
| ORG_TYPE_SEQ_HIGH | NUMBER | 18 | Higher value of the dimension member range sequence | ||
| GEO_INTG_ID | VARCHAR2 | 80 | Identifier of geography dimension member | ||
| GEO_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of geography dimension member | ||
| GEO_DIM_CODE | VARCHAR2 | 5 | Dimension code for geography dimension. | ||
| PRODUCT_INTG_ID | VARCHAR2 | 80 | Identifier of product dimension member | ||
| PRODUCT_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of product dimension member | ||
| PRODUCT_DIM_CODE | VARCHAR2 | 5 | Dimension code for product dimension. | ||
| ACCOUNT_INTG_ID | VARCHAR2 | 80 | Identifier of account dimension member | ||
| ACCOUNT_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of account dimension member | ||
| ACCOUNT_DIM_CODE | VARCHAR2 | 5 | Dimension code for account dimension. | ||
| ACCOUNT_NODE_INTG_ID | NUMBER | 18 | Identifier for Accounts attached explicitly through inclusion or exclusion coverage. | ||
| INDUSTRY_INTG_ID | VARCHAR2 | 80 | Identifier of industry dimension member | ||
| INDUSTRY_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of industry dimension member | ||
| INDUSTRY_DIM_CODE | VARCHAR2 | 5 | Dimension code for industry dimension. | ||
| CUST_SIZE_INTG_ID | VARCHAR2 | 80 | Identifier of customer size dimension member | ||
| CUST_SIZE_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of customer size dimension member | ||
| CUST_SIZE_DIM_CODE | VARCHAR2 | 5 | Dimension code for customer size dimension. | ||
| ORG_TYPE_INTG_ID | VARCHAR2 | 80 | Identifier of organization type dimension member | ||
| ORG_TYPE_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of organization type dimension member | ||
| ORG_TYPE_DIM_CODE | VARCHAR2 | 5 | Dimension code for organization type dimension. | ||
| AUXILIARY1_DIM_CODE | VARCHAR2 | 30 | Auxiliary Dimension1 Code | ||
| AUXILIARY1_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension1 dimension member | ||
| AUXILIARY1_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension1 dimension member | ||
| AUXILIARY1_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension1 dimension member Sequence Low Value | ||
| AUXILIARY1_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension1 dimension member Sequence High Value | ||
| AUXILIARY2_DIM_CODE | VARCHAR2 | 30 | Auxiliary Dimension2 Code | ||
| AUXILIARY2_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension2 dimension member | ||
| AUXILIARY2_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension2 dimension member | ||
| AUXILIARY2_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension2 dimension member Sequence Low Value | ||
| AUXILIARY2_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension2 dimension member Sequence High Value | ||
| AUXILIARY3_DIM_CODE | VARCHAR2 | 30 | Auxiliary Dimension3 Code | ||
| AUXILIARY3_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension3 dimension member | ||
| AUXILIARY3_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension3 dimension member | ||
| AUXILIARY3_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension3 dimension member Sequence Low Value | ||
| AUXILIARY3_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension3 dimension member Sequence High Value | ||
| ACCT_TYPE_DIM_CODE | VARCHAR2 | 30 | Account Type Dimension Code | ||
| ACCT_TYPE_INTG_ID | VARCHAR2 | 80 | Identifier of account type dimension member | ||
| ACCT_TYPE_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of account type dimension member | ||
| ACCT_TYPE_SEQ_LOW | NUMBER | 18 | Account type dimension member Sequence Low Value | ||
| ACCT_TYPE_SEQ_HIGH | NUMBER | 18 | Account type dimension member Sequence High Value | ||
| SALES_CHANNEL_DIM_CODE | VARCHAR2 | 30 | Sales Channel Dimension Code | ||
| SALES_CHANNEL_INTG_ID | VARCHAR2 | 80 | Identifier of sales channel dimension member | ||
| SALES_CHANNEL_HIGH_INTG_ID | VARCHAR2 | 80 | Identifier of sales channel dimension member | ||
| SALES_CHANNEL_SEQ_LOW | NUMBER | 18 | Sales channel dimension member Sequence Low Value | ||
| SALES_CHANNEL_SEQ_HIGH | NUMBER | 18 | Sales channel dimension member Sequence High Value | ||
| PARTNER_DIM_CODE | VARCHAR2 | 30 | Partner Dimension Code | ||
| PARTNER_NODE_INTG_ID | NUMBER | 18 | Identifier for Partners attached explicitly through partner inclusion or exclusion coverage. | ||
| PARTNER_ID | NUMBER | 18 | Points to the partner associated to the territory | ||
| PARTNER_PROGRAM_ID | NUMBER | 18 | Points to the specific program that a partner is participating in. | ||
| 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_BOUNDARY_DN | mot_territories | TERRITORY_VERSION_ID |
| MOT_TERR_BOUNDARY_DN | mot_terr_proposals | TERR_PROPOSAL_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MOT_TERR_BOUNDARY_DN_N1 | Non Unique | Default | GEO_SEQ_LOW |
| MOT_TERR_BOUNDARY_DN_N10 | Non Unique | Default | CUST_SIZE_SEQ_LOW |
| MOT_TERR_BOUNDARY_DN_N11 | Non Unique | Default | CUST_SIZE_SEQ_HIGH |
| MOT_TERR_BOUNDARY_DN_N12 | Non Unique | Default | ORG_TYPE_SEQ_LOW |
| MOT_TERR_BOUNDARY_DN_N13 | Non Unique | Default | ORG_TYPE_SEQ_HIGH |
| MOT_TERR_BOUNDARY_DN_N14 | Non Unique | Default | TERR_RULE_ID |
| MOT_TERR_BOUNDARY_DN_N15 | Non Unique | Default | TERRITORY_ID, TERR_STATUS_CODE |
| MOT_TERR_BOUNDARY_DN_N16 | Non Unique | Default | ACCOUNT_NODE_INTG_ID, TERR_STATUS_CODE, GEO_SEQ_LOW, GEO_SEQ_HIGH, PRODUCT_SEQ_LOW, PRODUCT_SEQ_HIGH |
| MOT_TERR_BOUNDARY_DN_N2 | Non Unique | Default | GEO_SEQ_HIGH |
| MOT_TERR_BOUNDARY_DN_N3 | Non Unique | Default | PRODUCT_SEQ_LOW |
| MOT_TERR_BOUNDARY_DN_N4 | Non Unique | Default | PRODUCT_SEQ_HIGH |
| MOT_TERR_BOUNDARY_DN_N5 | Non Unique | Default | ACCOUNT_SEQ_LOW |
| MOT_TERR_BOUNDARY_DN_N6 | Non Unique | Default | ACCOUNT_SEQ_HIGH |
| MOT_TERR_BOUNDARY_DN_N7 | Non Unique | Default | TERRITORY_VERSION_ID, ACCOUNT_NODE_INTG_ID, TERR_STATUS_CODE |
| MOT_TERR_BOUNDARY_DN_N8 | Non Unique | Default | INDUSTRY_SEQ_LOW |
| MOT_TERR_BOUNDARY_DN_N9 | Non Unique | Default | INDUSTRY_SEQ_HIGH |
| MOT_TERR_BOUNDARY_DN_PK | Unique | Default | TERR_BOUNDARY_DN_ID |