eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Lookup Type: MSC_ODS_TABLE

Product:	MSC - Advanced Supply Chain Planning
Meaning:	MSC_ODS_TABLE
Description:	List of ODS tables used by Collections

Quick Codes

Code	Meaning	Description
10	MSC_ASSIGNMENT_SETS	MSC_ASSIGNMENT_SETS
100	MSC_PARTNER_CONTACTS	MSC_PARTNER_CONTACTS
105	MSC_PERIOD_START_DATES	MSC_PERIOD_START_DATES
110	MSC_PLANNERS	MSC_PLANNERS
115	MSC_PARAMETERS	MSC_PARAMETERS
120	MSC_REGIONS	MSC_REGIONS
125	MSC_REGION_LOCATIONS	MSC_REGION_LOCATIONS
130	MSC_REPETITIVE_PERIODS	MSC_REPETITIVE_PERIODS
135	MSC_RESOURCE_CHANGES	MSC_RESOURCE_CHANGES
140	MSC_RESOURCE_GROUPS	MSC_RESOURCE_GROUPS
145	MSC_RESOURCE_SHIFTS	MSC_RESOURCE_SHIFTS
15	MSC_ATP_RULES	MSC_ATP_RULES
150	MSC_SALES_ORDERS	MSC_SALES_ORDERS
155	MSC_SHIFT_DATES	MSC_SHIFT_DATES
160	MSC_SHIFT_EXCEPTIONS	MSC_SHIFT_EXCEPTIONS
165	MSC_SHIFT_TIMES	MSC_SHIFT_TIMES
170	MSC_SIMULATION_SETS	MSC_SIMULATION_SETS
175	MSC_SOURCING_HISTORY	MSC_SOURCING_HISTORY
180	MSC_SOURCING_RULES	MSC_SOURCING_RULES
185	MSC_SR_ASSIGNMENTS	MSC_SR_ASSIGNMENTS
190	MSC_SR_RECEIPT_ORG	MSC_SR_RECEIPT_ORG
195	MSC_SR_SOURCE_ORG	MSC_SR_SOURCE_ORG
20	MSC_BILL_OF_RESOURCES	MSC_BILL_OF_RESOURCES
200	MSC_TRADING_PARTNERS	MSC_TRADING_PARTNERS
205	MSC_TRADING_PARTNER_SITES	MSC_TRADING_PARTNER_SITES
210	MSC_UNITS_OF_MEASURE	MSC_UNITS_OF_MEASURE
215	MSC_UNIT_NUMBERS	MSC_UNIT_NUMBERS
220	MSC_UOM_CLASS_CONVERSIONS	MSC_UOM_CLASS_CONVERSIONS
225	MSC_UOM_CONVERSIONS	MSC_UOM_CONVERSIONS
230	MSC_WORKDAY_PATTERNS	MSC_WORKDAY_PATTERNS
235	MSC_ZONE_REGIONS	MSC_ZONE_REGIONS
240	MSC_BOMS	MSC_BOMS
245	MSC_BOM_COMPONENTS	MSC_BOM_COMPONENTS
25	MSC_BIS_BUSINESS_PLANS	MSC_BIS_BUSINESS_PLANS
250	MSC_BOR_REQUIREMENTS	MSC_BOR_REQUIREMENTS
255	MSC_COMPONENT_SUBSTITUTES	MSC_COMPONENT_SUBSTITUTES
260	MSC_DEMANDS	MSC_DEMANDS
265	MSC_DEPARTMENT_RESOURCES	MSC_DEPARTMENT_RESOURCES
270	MSC_INTERORG_SHIP_METHODS	MSC_INTERORG_SHIP_METHODS
275	MSC_ITEM_SOURCING	MSC_ITEM_SOURCING
280	MSC_ITEM_SUBSTITUTES	MSC_ITEM_SUBSTITUTES
285	MSC_ITEM_SUPPLIERS	MSC_ITEM_SUPPLIERS
290	MSC_NET_RESOURCE_AVAIL	MSC_NET_RESOURCE_AVAIL
295	MSC_NET_RES_INST_AVAIL	MSC_NET_RES_INST_AVAIL
30	MSC_BIS_PERFORMANCE_MEASURES	MSC_BIS_PERFORMANCE_MEASURES
300	MSC_OPERATION_COMPONENTS	MSC_OPERATION_COMPONENTS
305	MSC_OPERATION_NETWORKS	MSC_OPERATION_NETWORKS
310	MSC_OPERATION_RESOURCES	MSC_OPERATION_RESOURCES
315	MSC_OPERATION_RESOURCE_SEQS	MSC_OPERATION_RESOURCE_SEQS
320	MSC_PROCESS_EFFECTIVITY	MSC_PROCESS_EFFECTIVITY
325	MSC_PROJECTS	MSC_PROJECTS
330	MSC_PROJECT_TASKS	MSC_PROJECT_TASKS
335	MSC_RESERVATIONS	MSC_RESERVATIONS
340	MSC_RESOURCE_REQUIREMENTS	MSC_RESOURCE_REQUIREMENTS
345	MSC_JOB_OPERATION_NETWORKS	MSC_JOB_OPERATION_NETWORKS
35	MSC_BIS_PERIODS	MSC_BIS_PERIODS
350	MSC_JOB_OPERATIONS	MSC_JOB_OPERATIONS
355	MSC_JOB_REQUIREMENT_OPS	MSC_JOB_REQUIREMENT_OPS
360	MSC_JOB_OP_RESOURCES	MSC_JOB_OP_RESOURCES
365	MSC_ROUTINGS	MSC_ROUTINGS
370	MSC_ROUTING_OPERATIONS	MSC_ROUTING_OPERATIONS
375	MSC_SAFETY_STOCKS	MSC_SAFETY_STOCKS
380	MSC_SUB_INVENTORIES	MSC_SUB_INVENTORIES
385	MSC_SUPPLIER_CAPACITIES	MSC_SUPPLIER_CAPACITIES
390	MSC_SUPPLIER_FLEX_FENCES	MSC_SUPPLIER_FLEX_FENCES
395	MSC_SUPPLIES	MSC_SUPPLIES
40	MSC_BIS_TARGETS	MSC_BIS_TARGETS
400	MSC_SYSTEM_ITEMS	MSC_SYSTEM_ITEMS
405	MSC_ITEMS	MSC_ITEMS
410	MSC_CALENDAR_ASSIGNMENTS	MSC_CALENDAR_ASSIGNMENTS
415	MSC_CALENDAR_EXCEPTIONS	MSC_CALENDAR_EXCEPTIONS
420	MSC_CATEGORY_SET_ID_LID	MSC_CATEGORY_SET_ID_LID
425	MSC_COMPANY_ID_LID	MSC_COMPANY_ID_LID
430	MSC_COMPANY_SITES	MSC_COMPANY_SITES
435	MSC_COMPANY_SITE_ID_LID	MSC_COMPANY_SITE_ID_LID
440	MSC_COMPANY_USERS	MSC_COMPANY_USERS
45	MSC_BIS_TARGET_LEVELS	MSC_BIS_TARGET_LEVELS
450	MSC_CARRIER_SERVICES	MSC_CARRIER_SERVICES
455	MSC_CRITICAL_PATHS	MSC_CRITICAL_PATHS
460	MSC_DEPT_RES_INSTANCES	MSC_DEPT_RES_INSTANCES
465	MSC_PO_RESCHEDULE_INTERFACE	MSC_PO_RESCHEDULE_INTERFACE
470	MSC_RESOURCE_BATCHES	MSC_RESOURCE_BATCHES
475	MSC_RESOURCE_CHARGES	MSC_RESOURCE_CHARGES
480	MSC_RESOURCE_INSTANCE_REQS	MSC_RESOURCE_INSTANCE_REQS
485	MSC_RESOURCE_SETUPS	MSC_RESOURCE_SETUPS
490	MSC_SERVICE_LEVELS	MSC_SERVICE_LEVELS
495	MSC_SETUP_TRANSITIONS	MSC_SETUP_TRANSITIONS
5	MSC_ABC_CLASSES	MSC_ABC_CLASSES
50	MSC_CALENDARS	MSC_CALENDARS
500	MSC_SUP_DEM_ENTRIES	MSC_SUP_DEM_ENTRIES
505	MSC_TRIPS	MSC_TRIPS
510	MSC_TRIP_STOPS	MSC_TRIP_STOPS
515	MSC_CURRENCY_CONVERSIONS	MSC_CURRENCY_CONVERSIONS
520	MSC_INSTANCE_ORGS	MSC_INSTANCE_ORGS
525	MSC_ITEM_ID_LID	MSC_ITEM_ID_LID
530	MSC_JOB_OP_RES_INSTANCES	MSC_JOB_OP_RES_INSTANCES
535	MSC_PLANNING_ORGS	MSC_PLANNING_ORGS
540	MSC_PO_RECEIPTS	MSC_PO_RECEIPTS
545	MSC_PO_REQUISITIONS_INTERFACE	MSC_PO_REQUISITIONS_INTERFACE
55	MSC_CALENDAR_DATES	MSC_CALENDAR_DATES
550	MSC_PQ_TYPES	MSC_PQ_TYPES
555	MSC_PURCHASE_ORDER_INTERFACE	MSC_PURCHASE_ORDER_INTERFACE
560	MSC_REGION_SITES	MSC_REGION_SITES
565	MSC_RES_INSTANCE_CHANGES	MSC_RES_INSTANCE_CHANGES
570	MSC_SECURITY_RULES	MSC_SECURITY_RULES
575	MSC_SO_RELEASE_INTERFACE	MSC_SO_RELEASE_INTERFACE
580	MSC_SUBSET_DESIG_DTLS	MSC_SUBSET_DESIG_DTLS
585	MSC_SUBSET_DESIGNATORS	MSC_SUBSET_DESIGNATORS
590	MSC_SUPPLIER_PLANS	MSC_SUPPLIER_PLANS
595	MSC_TEMP_REGION_LOCATIONS	MSC_TEMP_REGION_LOCATIONS
60	MSC_CALENDAR_SHIFTS	MSC_CALENDAR_SHIFTS
600	MSC_TEMP_SALES_ORDERS	MSC_TEMP_SALES_ORDERS
605	MSC_TP_ID_LID	MSC_TP_ID_LID
610	MSC_TP_SITE_ID_LID	MSC_TP_SITE_ID_LID
615	MSC_WIP_JOB_DTLS_INTERFACE	MSC_WIP_JOB_DTLS_INTERFACE
620	MSC_WIP_JOB_SCHEDULE_INTERFACE	MSC_WIP_JOB_SCHEDULE_INTERFACE
625	MSC_SR_LOOKUPS(1)	MSC_SR_LOOKUPS(1)
630	MSC_CALENDAR_MONTHS(1)	MSC_CALENDAR_MONTHS(1)
635	MSC_DELIVERY_DETAILS	MSC_DELIVERY_DETAILS
640	MSC_CALENDAR_MONTHS	MSC_CALENDAR_MONTHS
65	MSC_CAL_WEEK_START_DATES	MSC_CAL_WEEK_START_DATES
660	MSC_VISITS	MSC_VISITS
665	MSC_WO_MILESTONES	MSC_WO_MILESTONES
670	MSC_WO_ATTRIBUTES	MSC_WO_ATTRIBUTES
675	MSC_WO_TASK_HIERARCHY	MSC_WO_TASK_HIERARCHY
680	MSC_WORK_BREAKDOWN_STRUCT	MSC_WORK_BREAKDOWN_STRUCT
685	MSC_WO_OPERATION_REL	MSC_WO_OPERATION_REL
690	MSC_ORG_AGGR_IBUC	MSC_ORG_AGGR_IBUC
70	MSC_CAL_YEAR_START_DATES	MSC_CAL_YEAR_START_DATES
700	MSC_DMD_SCN_METRICS	MSC_DMD_SCN_METRICS
710	MSC_DOC_ATTACHMENTS	MSC_DOC_ATTACHMENTS
720	MSC_SHORT_TEXT	MSC_SHORT_TEXT
730	MSC_LONG_TEXT	MSC_LONG_TEXT
740	MSC_WO_SUB_COMP	MSC_WO_SUB_COMP
75	MSC_CATEGORY_SETS	MSC_CATEGORY_SETS
750	MSC_EAM_ACT_ASSOCIATIONS	MSC_EAM_ACT_ASSOCIATIONS
760	MSC_EAM_ASSET_EQUIP_DTLS	MSC_EAM_ASSET_EQUIP_DTLS
80	MSC_DEMAND_CLASSES	MSC_DEMAND_CLASSES
85	MSC_DESIGNATORS	MSC_DESIGNATORS
90	MSC_ITEM_CATEGORIES	MSC_ITEM_CATEGORIES
95	MSC_LOCATION_ASSOCIATIONS	MSC_LOCATION_ASSOCIATIONS
98	MSC_DUMMY	MSC_DUMMY