MOW_ASGN_MATCH_FINAL_GT
MOW_ASGN_MATCH_FINAL_GT is a Global Temp Table to store the data finally on POST phase
Details
-
Schema: FUSION
-
Object owner: MOW
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOW_ASGN_MATCH_FINAL_PK |
SEQ_ID |
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| SEQ_ID | NUMBER | 18 | Yes | SEQ_ID = To store the primary key value |
| PARTY_ID | NUMBER | 18 | PARTY_ID = Pulled from MOW_ASGN_MATCH_TF1 | |
| TERRITORY_ID | NUMBER | 18 | Yes | TERRITORY_ID = Pulled from MOW_ASGN_MATCH_TF1 |
| TERRITORY_VERSION_ID | NUMBER | 18 | Yes | TERRITORY_VERSION_ID = Pulled from MOW_ASGN_MATCH_TF1 |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| MOW_ASGN_MATCH_FINAL_U1 | Unique | SEQ_ID |