MOW_ASGN_TERR_DIMENSIONS_GT

MOW_ASGN_TERR_DIMENSIONS_GT is a Global Temp Table is to store the data for TERRITORY DIMENSIONS on translation phase

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_ASGN_TERR_DIMENSIONS_PK	SEQ_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SEQ_ID	NUMBER		18	Yes	SEQ_ID = To store primary key value
TERR_RULE_BNDRY_VALS_DN_ID	NUMBER		18		TERR_RULE_BNDRY_VALS_DN_ID = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
TERRITORY_ID	NUMBER		18		TERRITORY_ID = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
TERRITORY_VERSION_ID	NUMBER		18		TERRITORY_VERSION_ID = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
TERR_RULE_ID	NUMBER		18		TERR_RULE_ID = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
RULE_TYPE_CODE	VARCHAR2	30			RULE_TYPE_CODE = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
TERR_DIMENSION_CODE	VARCHAR2	5			TERR_DIMENSION_CODE = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
TERR_DIM_INTG_SEQ_LOW	NUMBER		18		TERR_DIM_INTG_SEQ_LOW = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
TERR_DIM_INTG_SEQ_HIGH	NUMBER		18		TERR_DIM_INTG_SEQ_HIGH = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
TERR_DIM_NODE_INTG_ID	VARCHAR2	80			TERR_DIM_NODE_INTG_ID = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
INCLUDE_HIERARCHY_FLAG	VARCHAR2	1			INCLUDE_HIERARCHY_FLAG = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
TERR_DIM_NODE_RANGE_LOW_NAME	VARCHAR2	360			TERR_DIM_NODE_RANGE_LOW_NAME = Pulled fromtable MOT_TERR_BNDRY_VALS_DN
TERR_DIM_NODE_RANGE_HIGH_NAME	VARCHAR2	360			TERR_DIM_NODE_RANGE_HIGH_NAME = Pulled fromtable MOT_TERR_BNDRY_VALS_DN

Indexes

Index	Uniqueness	Columns
MOW_ASGN_TERR_DIMENSIONS_U1	Unique	SEQ_ID