MOW_ASGN_MATCH_TF1_GT

MOW_ASGN_MATCH_TF1_GT is a Global Temp Table we are using on our POST phase to store the data temporarily.

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_ASGN_MATCH_TF1_PK	SEQ_ID

Columns

Name	Datatype	Precision	Not-null	Comments
SEQ_ID	NUMBER	18	Yes	SEQ_ID = To store primary key value
PARTY_ID	NUMBER	18	Yes	PARTY_ID = Pulled from MOW_ASGN_MATCH_TF0
TERRITORY_ID	NUMBER	18	Yes	TERRITORY_ID = Pulled from MOW_ASGN_MATCH_TF0
TERRITORY_VERSION_ID	NUMBER	18	Yes	TERRITORY_VERSION_ID = Pulled from MOW_ASGN_MATCH_TF0
TERRITORY_ID1	NUMBER	18	Yes	TERRITORY_ID1 = Pulled from MOW_ASGN_MATCH_TF0

Indexes

Index	Uniqueness	Columns
MOW_ASGN_MATCH_TF1_U1	Unique	SEQ_ID