MSC_SNAPSHOT_PARTNER_LIST
This table is used to store the partner and site data that will be used to find the Intransits between Vendor to Org, Org to Customers and Vendor to Customer.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Plan Identifier. | |
| PARTNER_ID | NUMBER | Yes | Supplier or Customer Identifier | |
| PARTNER_SITE_ID | NUMBER | Yes | Supplier or Customer site Identifier | |
| PARTNER_TYPE | NUMBER | Yes | Partner Type : Customer-2, Supplier-1 | |
| SOURCE_ENTITY | VARCHAR2 | 40 | Contains the Source Entity name from where this partner info is inserted | |
| LOCATION_ID | NUMBER | Location Id of the partner site. | ||
| GEOGRAPHY_ID | NUMBER | GEOGRAPHY_ID : Region/Zone Identifier. | ||
| GEOGRAPHY_LEVEL | NUMBER | GEOGRAPHY_LEVEL | ||
| GEOGRAPHY_TYPE | VARCHAR2 | 1 | GEOGRAPHY_TYPE : Region-R, Zone-Z. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_SNAPSHOT_PART_LIST_N1 | Non Unique | Default | PLAN_ID, LOCATION_ID |
| MSC_SNAPSHOT_PART_LIST_N2 | Non Unique | Default | PLAN_ID, GEOGRAPHY_ID, GEOGRAPHY_TYPE, PARTNER_TYPE |
| MSC_SNAPSHOT_PART_LIST_U1 | Unique | Default | PLAN_ID, PARTNER_ID, PARTNER_SITE_ID, GEOGRAPHY_ID |