MSC_CALENDAR_ASSIGNMENTS
This table keeps the association between trading partners and its calendars
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
MSC_CALENDAR_ASSIGNMENTS_PK |
ASSIGNMENT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | Yes | Unique identifier for a row generated by sequence MSC_CALENDAR_ASSIGNMENTS_S | |||
ASSOCIATION_TYPE | NUMBER | Yes | 1 - VENDOR 2 - CUSTOMER 3 - ORGANIZATION 4 - CARRIER 5 - VENDOR_SITE 6 - CUSTOMER_SITE 7 - CARRIER_VENDOR 8 - CARRIER_CUSTOMER 9 - CARRIER_ORGANIZATION 10 - CARRIER_VENDOR_SITE 11 - CARRIER_CUSTOMER_SITE. | |||
CALENDAR_CODE | VARCHAR2 | 22 | Yes | CALENDAR_CODE of the given Calendar | ||
CALENDAR_TYPE | VARCHAR2 | 10 | Yes | Type of the calendar. RECEIVING, SHIPPING, CARRIER | ||
PARTNER_ID | NUMBER | 18 | This value indicates the trading partner identifier generated during planning collections. | |||
PARTNER_SITE_ID | NUMBER | 18 | FK to msc_trading_partner_sites | |||
ORGANIZATION_ID | NUMBER | 18 | FK to org_id in msc_parameters | |||
SR_INSTANCE_ID | NUMBER | 18 | Yes | Source application instance identifier | Obsolete | |
CARRIER_PARTNER_ID | NUMBER | 18 | FK to msc_trading_partners.partner_id | |||
PARTNER_TYPE | NUMBER | Yes | 1 - Supplier 2 - Customer 3 - Organization 4 - Carrier | |||
ASSOCIATION_LEVEL | NUMBER | Yes | 1 - CARRIER_VENDOR_SITE, CARRIER_CUSTOMER_SITE 2 - CARRIER_VENDOR, CARRIER_CUSTOMER, CARRIER_ORGANIZATION 3 - VENDOR_SITE, CUSTOMER_SITE 4 - VENDOR, CUSTOMER, ORGANIZATION, CARRIER | |||
SHIP_METHOD_CODE | VARCHAR2 | 30 | Ship Method Code (eg: UPS-2ndday-Air) | |||
SERVICE_LEVEL | NUMBER | 18 | Service level specified while assigning the calendar. | |||
MODE_OF_TRANSPORT | NUMBER | 18 | MODE_OF_TRANSPORT | |||
REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
MSC_CALENDAR_ASSIGNMENTS | msc_calendars | CALENDAR_CODE |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
MSC_CALENDAR_ASSIGNMENTS_N1 | Non Unique | Default | ORGANIZATION_ID, CALENDAR_TYPE |
MSC_CALENDAR_ASSIGNMENTS_N2 | Non Unique | Default | PARTNER_ID, PARTNER_SITE_ID, PARTNER_TYPE, CALENDAR_TYPE, ASSOCIATION_TYPE |
MSC_CALENDAR_ASSIGNMENTS_U1 | Unique | Default | ASSIGNMENT_ID |