MOW_ASGN_DIMENSIONS_GT

MOW_ASGN_DIMENSIONS_GT is a Global Temp Table to store the output of various dimention mappings like AcType, CSize, Aux1, Aux2, Aux3, Indst and OrgTp.

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_ASGN_DIMENSIONS_PK	SEQ_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SEQ_ID	NUMBER		18	Yes	SEQ_ID = To store the primary key
PARTY_ID	NUMBER		18	Yes	PARTY_ID = To store the value of PARTY_ID column of table MOW_ASGN_ACCOUNTS
SEQUENCE_LOW	NUMBER		18		SEQUENCE_LOW = To store value of column SEQUENCE_LOW of table MOT_TERR_DIM_MEMBERS_VL
TERR_DIMENSION_CODE	VARCHAR2	5		Yes	TERR_DIMENSION_CODE = To store the value of column TERR_DIMENSION_CODE of table MOT_TERR_DIM_MEMBERS_VL
SEQUENCE_HIGH	NUMBER		18		SEQUENCE_HIGH = To store value of column SEQUENCE_HIGH of table MOT_TERR_DIM_MEMBERS_VL

Indexes

Index	Uniqueness	Columns
MOW_ASGN_DIMENSIONS_U1	Unique	SEQ_ID