MOT_TERR_DIM_MEMBERS_B
This entity stores the values for territory dimension. The values might be organized in the flat structure, such as customer size, or they might be organized in the hierarchies, such as products or geographies.
Details
-
Schema: FUSION
-
Object owner: MOT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOT_TERR_DIM_MEMBERS_B_PK |
TERR_DIM_MEMBER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TERR_DIM_MEMBER_ID | NUMBER | 18 | Yes | Territory Dimension Member Identifier | |
| LEVEL_NUMBER | NUMBER | 18 | LEVEL_NUMBER | ||
| TERR_DIMENSION_ID | NUMBER | 18 | Yes | Territory Dimension Identifier | |
| TERR_DIMENSION_CODE | VARCHAR2 | 5 | Yes | Foreign key to MOT_TERR_DIMENSIONS_B. | |
| PARENT_TERR_DIM_MEMBER_ID | NUMBER | 18 | Parent Territory Dimension Member Identifier | ||
| SORT_ORDER | NUMBER | 18 | The sort order number for the dimension members. | ||
| ATTRIBUTE_PK1 | VARCHAR2 | 30 | Yes | Id of Geo, Inventory Item, or Product Category dimension member | |
| ATTRIBUTE_PK2 | VARCHAR2 | 30 | Id of Inventory Org dimension member | ||
| SEQUENCE_LOW | NUMBER | 18 | Sequence Number Low for Dimension Member | ||
| SEQUENCE_HIGH | NUMBER | 18 | Sequence Number High for Dimension Member | ||
| PARTITION_ID | NUMBER | 18 | Yes | Partition Identifier | |
| INTEGRATION_ID | VARCHAR2 | 80 | Yes | Common member identifier between OBI, Territory Management and Cube. | |
| NUM_INTEGRATION_ID | NUMBER | 18 | Integration Id for Account and Partner dimensions stored in numerical format. | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | Yes | A flag identifying if the member is deleted or not. | |
| DISPLAY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether a dimension member should be displayed. | |
| TYPE_CODE | VARCHAR2 | 30 | Describes the type of members. Valid values are 'NORMAL', 'UNSPECIFIED', and 'OTHERS'. All members except for Others and Unspecified are marked as NORMAL. | ||
| LEAF_FLAG | VARCHAR2 | 1 | A flag identifying if the member is a leaf in the tree structure or not. Ths flag is populated for the members in the Flagging Partition only. If a member has children - the flag value is 'N', otherwise it is 'Y'. | ||
| EXPLICIT_FLAG | VARCHAR2 | 1 | Identifier to indicate if the dimension member is explicit or implicit. | ||
| DIM_SUBTYPE_CODE | VARCHAR2 | 30 | Used only in the case of the Product dimension. The Dimension Subtype Code differentiates between products and product groups. Two allowed values are: PROD and PRODCAT. | ||
| 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. | |
| DIM_MEMBER_NAME | VARCHAR2 | 360 | Territory Dimension Member Name |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MOT_TERR_DIM_MEMBERS_B | mot_terr_dimensions_b | TERR_DIMENSION_ID |
| MOT_TERR_DIM_MEMBERS_B | mot_terr_dim_partitions | PARTITION_ID |
| mot_terr_dim_members_tl | mot_terr_dim_members_b | TERR_DIM_MEMBER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MOT_TERR_DIM_MEMBERS_B_N1 | Non Unique | Default | PARENT_TERR_DIM_MEMBER_ID, TERR_DIMENSION_CODE, TYPE_CODE, ACTIVE_FLAG |
| MOT_TERR_DIM_MEMBERS_B_N10 | Non Unique | Default | PARTITION_ID, TERR_DIMENSION_CODE, NVL("PARENT_TERR_DIM_MEMBER_ID", 0), SEQUENCE_LOW, SEQUENCE_HIGH |
| MOT_TERR_DIM_MEMBERS_B_N12 | Non Unique | Default | PARTITION_ID, SORT_ORDER |
| MOT_TERR_DIM_MEMBERS_B_N13 | Non Unique | Default | PARTITION_ID, TERR_DIMENSION_CODE, ACTIVE_FLAG, DISPLAY_FLAG, SORT_ORDER |
| MOT_TERR_DIM_MEMBERS_B_N14 | Non Unique | Default | PARTITION_ID, TERR_DIMENSION_CODE, UPPER("DIM_MEMBER_NAME"), ACTIVE_FLAG, DISPLAY_FLAG, SEQUENCE_LOW, SEQUENCE_HIGH |
| MOT_TERR_DIM_MEMBERS_B_N2 | Non Unique | Default | ATTRIBUTE_PK1, ATTRIBUTE_PK2 |
| MOT_TERR_DIM_MEMBERS_B_N3 | Non Unique | Default | UPPER("TERR_DIMENSION_CODE"), LEVEL_NUMBER, SORT_ORDER |
| MOT_TERR_DIM_MEMBERS_B_N4 | Non Unique | Default | INTEGRATION_ID, PARTITION_ID, TERR_DIMENSION_ID |
| MOT_TERR_DIM_MEMBERS_B_N5 | Non Unique | Default | PARTITION_ID, TERR_DIMENSION_CODE, SEQUENCE_LOW, SEQUENCE_HIGH |
| MOT_TERR_DIM_MEMBERS_B_N6 | Non Unique | Default | PARTITION_ID, TERR_DIMENSION_ID, PARENT_TERR_DIM_MEMBER_ID |
| MOT_TERR_DIM_MEMBERS_B_N7 | Non Unique | Default | PARTITION_ID, TERR_DIMENSION_CODE, PARENT_TERR_DIM_MEMBER_ID, SORT_ORDER |
| MOT_TERR_DIM_MEMBERS_B_N8 | Non Unique | Default | TERR_DIMENSION_ID, SORT_ORDER |
| MOT_TERR_DIM_MEMBERS_B_PK | Unique | Default | TERR_DIM_MEMBER_ID |
| MOT_TERR_DIM_MEMBERS_B_U1 | Unique | Default | PARTITION_ID, TERR_DIMENSION_CODE, INTEGRATION_ID |