MOT_TERR_DIM_MEMBERS_GT
In any session, this entity will contain dimension members for only one Dimension.
Details
-
Schema: FUSION
-
Object owner: MOT
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TERR_DIM_MEMBER_ID | NUMBER | 18 | Yes | TerritoryDimension Member Identifier | |
| PARENT_TERR_DIM_MEMBER_ID | NUMBER | 18 | Parent Territory Dimension Member Identifier | ||
| NAME | VARCHAR2 | 360 | Yes | NAME | |
| TYPE_CODE | VARCHAR2 | 30 | Describes the type of members .Valid values are 'NORMAL','UNSPECIFIED', AND 'OTHERS' | ||
| INTEGRATION_ID | VARCHAR2 | 80 | Yes | Common member identifier between OBI,Territory Management and Cube | |
| RANK_NUMBER | NUMBER | 5 | Ranking given to the nodes ,based on type of members and trash node | ||
| ATTRIBUTE_PK1 | VARCHAR2 | 30 | Id of Geo, Inventory Item, or Product Category dimension member | ||
| ATTRIBUTE_PK2 | VARCHAR2 | 30 | Id of Inventory Org dimension member | ||
| CONFLICT_ID | NUMBER | 18 | 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). | ||
| TERR_DIMENSION_CODE | VARCHAR2 | 5 | Foreign key to MOT_TERR_DIMENSIONS_B. | ||
| 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. | ||
| DATA_PROCESSING1 | NUMBER | 18 | Attribute to store derived values for processing |