Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID. |
Implementation/DBA Data: | MSC.MSC_DEMANDS |
Table | |
Foreign Table | Foreign Key Column |
---|---|---|---|
MSC_DEMANDS | MSC_SYSTEM_ITEMS |
MSC_DEMANDS.INVENTORY_ITEM_ID
MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID | |
MSC_DEMANDS | MSC_PROJECT_TASKS |
MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS.TASK_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PLAN_ID | |
MSC_DEMANDS | MSC_TRADING_PARTNER_SITES | MSC_DEMANDS.SHIP_TO_SITE_ID | |
MSC_DEMANDS | MSC_DESIGNATORS | MSC_DEMANDS.SCHEDULE_DESIGNATOR_ID | |
MSC_DEMANDS | MSC_SUPPLIES |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.DISPOSITION_ID | |
MSC_DEMANDS | MSC_TRADING_PARTNERS | MSC_DEMANDS.CUSTOMER_ID | |
MSC_DEMANDS | MSC_TRADING_PARTNER_SITES | MSC_DEMANDS.CUSTOMER_SITE_ID | |
MSC_DEMANDS | MSC_SYSTEM_ITEMS |
MSC_DEMANDS.USING_ASSEMBLY_ITEM_ID
MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID | |
MSC_DEMANDS | MSC_PROJECTS |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.PROJECT_ID MSC_DEMANDS.ORGANIZATION_ID | |
MSC_DEMANDS | MSC_DEMANDS |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.PARENT_ID | |
MSC_DEMANDS | MSC_DEMANDS |
MSC_DEMANDS.PLAN_ID
MSC_DEMANDS.PARENT_ID | |
MSC_FORECAST_UPDATES | MSC_DEMANDS |
MSC_FORECAST_UPDATES.PLAN_ID
MSC_FORECAST_UPDATES.FORECAST_DEMAND_ID MSC_FORECAST_UPDATES.SR_INSTANCE_ID | |
MSC_FULL_PEGGING | MSC_DEMANDS |
MSC_FULL_PEGGING.PLAN_ID
MSC_FULL_PEGGING.DEMAND_ID |
|
|
|