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 |