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