MOW_ASGN_MATCH_OTHERS_T2_GT
MOW_ASGN_MATCH_OTHERS_T2_GT is a Global Temp Table used at incluion matching phase
Details
-
Schema: FUSION
-
Object owner: MOW
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
MOW_ASGN_MATCH_OTHERS_T2_PK |
SEQ_ID |
Columns
Name | Datatype | Precision | Not-null | Comments |
---|---|---|---|---|
SEQ_ID | NUMBER | 18 | Yes | SEQ_ID = To store the primary key value |
TERR_RULE_BNDRY_VALS_DN_ID | NUMBER | 18 | Yes | TERR_RULE_BNDRY_VALS_DN_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T1 |
PARTY_ID | NUMBER | 18 | Yes | PARTY_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T1 |
TERRITORY_ID | NUMBER | 18 | Yes | TERRITORY_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T1 |
TERRITORY_VERSION_ID | NUMBER | 18 | Yes | TERRITORY_VERSION_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T1 |
TERR_RULE_ID | NUMBER | 18 | Yes | TERR_RULE_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T1 |
Indexes
Index | Uniqueness | Columns |
---|---|---|
MOW_ASGN_MATCH_OTHERS_T2_U1 | Unique | SEQ_ID |