MOT_SALES_ACCT_DIM_MEMBERS
This entity is introduced to enhance performance when showing Sales Accounts in the Territory Manager UI ( ie Dimension shuttle) and is an extension of the Sales Territory Dimension Member entity . It holds detail around the Sales Account dimension used to define a Territory as follows a) The attributes related to a Sales Account ie Geo, Industry, Org Type and Size b) Territory specific sequence info for the sales Account and each of its related attributes. This allows a quick way to filter Sales Accounts by the other ( Sales Account related ) dimensions chosen for a given Territory.
Details
-
Schema: FUSION
-
Object owner: MOT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOT_SALES_ACCT_DIM_MEMBERS_PK |
SALES_ACCT_DIM_MEMBER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SALES_ACCT_DIM_MEMBER_ID | NUMBER | 18 | Yes | Primary Key for this table | |
| PARTITION_ID | NUMBER | 18 | Yes | Identifier of the dimension member partition. | |
| SALES_ACCOUNT_INTG_ID | VARCHAR2 | 80 | Identifier of Customer Account dimension member. | ||
| SALES_ACCOUNT_SEQ_LOW | NUMBER | 18 | Lower value of the customer account dimension member range sequence. | ||
| SALES_ACCOUNT_SEQ_HIGH | NUMBER | 18 | Higher value of the customer account dimension member range sequence | ||
| ACCOUNT_INTG_ID | VARCHAR2 | 80 | Identifier of account dimension member. | ||
| ACCOUNT_SEQ_LOW | NUMBER | 18 | Lower value of the account dimension member range sequence. | ||
| ACCOUNT_SEQ_HIGH | NUMBER | 18 | Higher value of the account dimension member range sequence | ||
| GEO_INTG_ID | VARCHAR2 | 80 | Identifier of Geo dimension member | ||
| GEO_SEQ_LOW | NUMBER | 18 | Lower value of the dimension member range sequence | ||
| GEO_SEQ_HIGH | NUMBER | 18 | Higher value of the dimension member range sequence | ||
| INDUSTRY_INTG_ID | VARCHAR2 | 80 | Identifier of Industry dimension member | ||
| 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_INTG_ID | VARCHAR2 | 80 | Identifier of Customer Size dimension member | ||
| 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 | ||
| CUST_ORG_TYPE_INTG_ID | VARCHAR2 | 80 | Identifier of Org Type dimension member | ||
| CUST_ORG_TYPE_SEQ_LOW | NUMBER | 18 | Lower value of the dimension member range sequence | ||
| CUST_ORG_TYPE_SEQ_HIGH | NUMBER | 18 | Higher value of the dimension member range sequence | ||
| BUS_UNIT_INTG_ID | VARCHAR2 | 80 | Identifier of business unit dimension dimension member | ||
| BUS_UNIT_SEQ_LOW | NUMBER | 18 | Business unit dimension member Sequence Low Value | ||
| BUS_UNIT_SEQ_HIGH | NUMBER | 18 | Business unit dimension member Sequence Low Value | ||
| AUXILIARY1_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_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_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 | ||
| AUXILIARY4_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension4 dimension member | ||
| AUXILIARY4_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension4 dimension member Sequence Low Value | ||
| AUXILIARY4_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension4 dimension member Sequence High Value | ||
| AUXILIARY5_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension5 dimension member | ||
| AUXILIARY5_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension5 dimension member Sequence Low Value | ||
| AUXILIARY5_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension5 dimension member Sequence High Value | ||
| AUXILIARY6_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension6 dimension member | ||
| AUXILIARY6_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension6 dimension member Sequence Low Value | ||
| AUXILIARY6_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension6 dimension member Sequence High Value | ||
| AUXILIARY7_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension7 dimension member | ||
| AUXILIARY7_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension7 dimension member Sequence Low Value | ||
| AUXILIARY7_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension7 dimension member Sequence High Value | ||
| AUXILIARY8_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension8 dimension member | ||
| AUXILIARY8_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension8 dimension member Sequence Low Value | ||
| AUXILIARY8_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension8 dimension member Sequence High Value | ||
| AUXILIARY9_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension9 dimension member | ||
| AUXILIARY9_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension9 dimension member Sequence Low Value | ||
| AUXILIARY9_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension9 dimension member Sequence High Value | ||
| AUXILIARY10_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension10 dimension member | ||
| AUXILIARY10_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension10 dimension member Sequence Low Value | ||
| AUXILIARY10_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension10 dimension member Sequence High Value | ||
| AUXILIARY11_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension11 dimension member | ||
| AUXILIARY11_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension11 dimension member Sequence Low Value | ||
| AUXILIARY11_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension11 dimension member Sequence High Value | ||
| AUXILIARY12_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension12 dimension member | ||
| AUXILIARY12_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension22 dimension member Sequence Low Value | ||
| AUXILIARY12_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension12 dimension member Sequence High Value | ||
| AUXILIARY13_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension13 dimension member | ||
| AUXILIARY13_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension13 dimension member Sequence Low Value | ||
| AUXILIARY13_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension13 dimension member Sequence High Value | ||
| AUXILIARY14_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension14 dimension member | ||
| AUXILIARY14_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension14 dimension member Sequence Low Value | ||
| AUXILIARY14_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension14 dimension member Sequence High Value | ||
| AUXILIARY15_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension15 dimension member | ||
| AUXILIARY15_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension15 dimension member Sequence Low Value | ||
| AUXILIARY15_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension15 dimension member Sequence High Value | ||
| AUXILIARY16_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension16 dimension member | ||
| AUXILIARY16_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension16 dimension member Sequence Low Value | ||
| AUXILIARY16_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension16 dimension member Sequence High Value | ||
| AUXILIARY17_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension17 dimension member | ||
| AUXILIARY17_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension17 dimension member Sequence Low Value | ||
| AUXILIARY17_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension17 dimension member Sequence High Value | ||
| AUXILIARY18_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension18 dimension member | ||
| AUXILIARY18_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension18 dimension member Sequence Low Value | ||
| AUXILIARY18_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension18 dimension member Sequence High Value | ||
| AUXILIARY19_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension19 dimension member | ||
| AUXILIARY19_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension19 dimension member Sequence Low Value | ||
| AUXILIARY19_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension19 dimension member Sequence High Value | ||
| AUXILIARY20_INTG_ID | VARCHAR2 | 80 | Identifier of auxiliary dimension20 dimension member | ||
| AUXILIARY20_SEQ_LOW | NUMBER | 18 | Auxiliary Dimension20 dimension member Sequence Low Value | ||
| AUXILIARY20_SEQ_HIGH | NUMBER | 18 | Auxiliary Dimension20 dimension member Sequence High Value | ||
| ACCT_TYPE_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 | ||
| ACCT_EXPLICIT_FLAG | VARCHAR2 | 1 | Identifier to indicate if the account dimension member is attached explicitly or not. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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). | |
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MOT_SALES_ACCT_DIM_MEMBERS | mot_terr_dim_partitions | PARTITION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MOT_SALES_ACCT_DIM_MEMBERS_PK | Unique | Default | SALES_ACCT_DIM_MEMBER_ID |
| MOT_SALES_ACCT_DIM_MEM_N1 | Non Unique | Default | PARTITION_ID, ACCT_TYPE_INTG_ID |
| MOT_SALES_ACCT_DIM_MEM_N10 | Non Unique | Default | PARTITION_ID, INDUSTRY_INTG_ID |
| MOT_SALES_ACCT_DIM_MEM_N11 | Non Unique | Default | PARTITION_ID, ACCOUNT_INTG_ID |
| MOT_SALES_ACCT_DIM_MEM_N12 | Non Unique | Default | PARTITION_ID, ACCOUNT_SEQ_LOW, ACCOUNT_SEQ_HIGH |
| MOT_SALES_ACCT_DIM_MEM_N2 | Non Unique | Default | PARTITION_ID, SALES_ACCOUNT_INTG_ID |
| MOT_SALES_ACCT_DIM_MEM_N3 | Non Unique | Default | PARTITION_ID, GEO_SEQ_LOW, GEO_SEQ_HIGH, AUXILIARY1_SEQ_LOW, AUXILIARY1_SEQ_HIGH, AUXILIARY2_SEQ_LOW, AUXILIARY2_SEQ_HIGH, AUXILIARY3_SEQ_LOW, AUXILIARY3_SEQ_HIGH, CUST_SIZE_SEQ_LOW, CUST_SIZE_SEQ_HIGH, CUST_ORG_TYPE_SEQ_LOW, CUST_ORG_TYPE_SEQ_HIGH, INDUSTRY_SEQ_LOW, INDUSTRY_SEQ_HIGH, ACCT_TYPE_SEQ_LOW, ACCT_TYPE_SEQ_HIGH, SALES_ACCOUNT_SEQ_LOW, SALES_ACCOUNT_SEQ_HIGH |
| MOT_SALES_ACCT_DIM_MEM_N4 | Non Unique | Default | PARTITION_ID, GEO_INTG_ID |
| MOT_SALES_ACCT_DIM_MEM_N5 | Non Unique | Default | PARTITION_ID, AUXILIARY1_INTG_ID |
| MOT_SALES_ACCT_DIM_MEM_N6 | Non Unique | Default | PARTITION_ID, AUXILIARY2_INTG_ID |
| MOT_SALES_ACCT_DIM_MEM_N7 | Non Unique | Default | PARTITION_ID, AUXILIARY3_INTG_ID |
| MOT_SALES_ACCT_DIM_MEM_N8 | Non Unique | Default | PARTITION_ID, CUST_SIZE_INTG_ID |
| MOT_SALES_ACCT_DIM_MEM_N9 | Non Unique | Default | PARTITION_ID, CUST_ORG_TYPE_INTG_ID |